Problem when moving context from server.xml to web.xml

[Ivan Jouikov]

I want to move <context> element from server.xml to web.xml, so I can add new applications without restarting the server.

Everything works fine, my DB and all, until I move this entry:

  <Context path="/ablogic" docBase="C:\Documents and Settings\SysOp\My Documents\AB LOGIC\Eclipse Workspace\abLogic\web" debug="9" reloadable="true">
 
<!-- Database -->
<Resource name="jdbc/ablogic" auth="Container" type="javax.sql.DataSource"/>

<ResourceParams name="jdbc/ablogic">
<!-- Max pool connections -->
<parameter><name>maxActive</name><value>5</value></parameter>
<!-- Max idle connections -->
<parameter><name>maxIdle</name><value>5</value></parameter>
<!-- Username -->
<parameter><name>username</name><value>ivan</value></parameter>
<!-- Password -->
<parameter><name>password</name><value>kittiesrcute</value></parameter>
<!--DB Driver -->
<parameter><name>driverClassName</name><value>com.mysql.jdbc.Driver</value></parameter>
<!--DB URL -->
<parameter><name>url</name><value>jdbc:mysql://192.168.0.1:3306/school?autoReconnect=true</value></parameter>
</ResourceParams>
 
</Context> 

As soon as I move this thing, and try to use my DB, I get the following error:

Error message: Cannot create JDBC driver of class '' for connect URL 'null'

My mysql connector is both in my /common/lib and my /WEB-INF/lib/, just to keep it safe. Also, to my web.xml I added these two entries:

 <ResourceLink name="jdbc/ablogic" global="jdbc/ablogic"/>

<resource-ref>
<description>DB Connection</description>
<res-ref-name>jdbc/ablogic</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref> 

I have no idea what the hell is wrong. Theoretically, I am not changing anything by simply copying <context> element, yet, it seems to stop working .

[Alexey Chervyakov]

There is a new ugly feature in Tomcat 5.xx When your web-application have been deployed, Resource reference created for each context, but this referrence have an empty value of URL and DriverClass name.

You have to describe an additional reference to Resource for each HOST and context. You can use Tomcat admin interface and repeat resource description from general section (Resources->Data Sources) in context related Tomcat (Server->Service->Host(yourhost)->Context(/sccm)->Resources->Data Sources). But you will have to repeat it after every deployment Another way is creation an additional web.xml file in folder "Tomcat 5.xx\conf\Catalina\yourhost\web.xml" with description of resource for your context like follow:

<Context displayName="CNTX" docBase="web" path="/web" workDir="work\Catalina\localhost\web">
<Resource auth="Container" description="" name="jdbc/license" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/license">
<parameter><name>url</name><value>jdbc:mysql://localhost:3306/licenses?autoReconnect=true</value></parameter>
<parameter><name>driverClassName</name><value>com.jdbc.mysql.Driver</value></parameter>
</ResourceParams>
</Context>