ke, 2003-12-03 kello 04:19, Doug Parsons wrote

> Had the same problem on 4.1.29 and 3.23.58
> Try adding this to the Web.xml
> <servlet-mapping>
>
> <servlet-name>invoker</servlet-name>
>
> <url-pattern>/servlet/*</url-pattern>
>
> </servlet-mapping>
>

Does not make sense, since I do not have servlets in my web app...

>
>
> > Server.xml (important parts):
> >  <GlobalNamingResources>
> >   <Resource name="jdbc/TestDB" auth="Container"
> >          type="javax.sql.DataSource"/>
> >   <ResourceParams name="jdbc/TestDB">
>   |
>   |
>   |
> >      <name>url</name>
> >      <value>jdbc:mysql://localhost/TestDB?autoReconnect=true</value>
> >     </parameter>
> >   </ResourceParams>
>
> This section of my code is in a set of context tags.

I need it in GlobalNamingResources, since the realm uses the same DBCP.

>
>
> >  </GlobalNamingResources>
> >  <Service...>
> >  <Engine...>
> >  <Realm className="org.apache.catalina.realm.DataSourceRealm"
> >   debug="99" dataSourceName="jdbc/TestDB" userTable="UserTBL"
> >   userNameCol="userid" userCredCol="pass" userRoleTable="RoleTBL"
> >   roleNameCol="role"/>
> >  </Engine>
> >  </Service>
>
> Not used in my case yet.

Works well in my case...

> Everything else looks like my code. I'm no expert and don't know how most of
> it works but it does.
>
> I have one catch on my system. I have to restart Tomcat after I deploy the
> war file via manager. I get null pointer exceptions if I don't.

Actually I was lucky enough to solve this problem myself. Hints for the
solution was in the examples section of the default server.xml. I had to
add a Context-element for my web application into the server.xml, and in
that I needed to include ResourceLink-element telling the use of the
global datasource. Then I needed to delete the resource-ref element from
the web.xml of my web app. And voila, it started working... The downside
is that I cannot anymore use the manager ant-task to install or reload
the web application context (resulting exception when trying to use it:
javax.naming.NameNotFoundException: Name jdbc is not bound in this
Context).

I have included parts of the server.xml if someone else has the same
problem:
</GlobalNamingResources>
<Resource name="TestDB" auth="Container"
        type="javax.sql.DataSource"
</Resource>
<ResourceParams name="TestDB">
  <parameter>
   <name>factory</name>
   <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
  </parameter>
  <parameter>
   <name>maxActive</name>
   <value>100</value>
  </parameter>
  <parameter>
   <name>maxIdle</name>
   <value>30</value>
  </parameter>
  <parameter>
   <name>maxWait</name>
   <value>10000</value>
  </parameter>
  <parameter>
   <name>username</name>
   <value>userx</value>
  </parameter>
  <parameter>
   <name>password</name>
   <value>passx</value>
  </parameter>
  <parameter>
   <name>driverClassName</name>
   <value>com.mysql.jdbc.Driver</value>
  </parameter>
  <parameter>
   <name>url</name>
   <value>jdbc:mysql://localhost/TestDB?autoReconnect=true</value>
  </parameter>
</ResourceParams>
</GlobalNamingResources>
...
<Context path="/testapp" docBase="testapp" debug="0"
reloadable="true" crossContext="true">
<Logger className="org.apache.catalina.logger.FileLogger"
  prefix="localhost_testapp_log." suffix=".txt" timestamp="true"/>
<ResourceLink name="jdbc/TestDB" global="TestDB"
  type="javax.sql.DataSource"/>
</Context>

The <Realm> did not change.


---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@(protected)
For additional commands, e-mail: tomcat-user-help@(protected)