tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ilari Kontinen <ikont...@cc.hut.fi>
Subject Re: Problems with Tomcat 4.1.27 and MySQL J/Connector 3.0.9 (stable)
Date Wed, 03 Dec 2003 11:07:29 GMT
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@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


Mime
View raw message