In tomcat 5.5.9, defining the resources under the <Context> element seems to 
have this kind of an issue. One way to resolve this is to define your 
datasource (i.e, Resource) under Server/GlobalNamingResources element  and 
then define a ResourceLink  in context.xml (in the same location as 
server.xml). Hope this helps.

This worked for us.

Sastry Malladi,
Architect
SpikeSource 


> I'm having difficulty defining a JNDI data source using C3P0 pooling in 
> Tomcat 5.5.9.  Here is the context descriptor for my app:
> 
> <Context path="/ems" reloadable="true">
>     <Logger className="org.apache.catalina.logger.SystemOutLogger" 
> verbosity="4" timestamp="true"/>
>     <Loader className="org.apache.catalina.loader.DevLoader" 
> reloadable="true" debug="1"/>
>     <Resource
>         name="jdbc/EmsDb"
>         description="DB Connection"
>         auth="Container"
>         driverClass="net.sourceforge.jtds.jdbc.Driver"
>         minPoolSize="5"
>         maxPoolSize="10"
>         acquireIncrement="1"
>         user="sa"
>         password=""
>         factory="org.apache.naming.factory.BeanFactory"
>         type="com.mchange.v2.c3p0.ComboPooledDataSource"
>         jdbcUrl="jdbc:jtds:sqlserver://mars:1433/ems?autoReconnect=true"
>         />
> </Context>
> 
> Here is the resource-ref portion of my application descriptor:
> 
>   <resource-ref>
>       <description>Database Connection</description>
>     <res-ref-name>jdbc/EmsDb</res-ref-name>
>     <res-type>javax.sql.DataSource</res-type>
>     <res-auth>Container</res-auth>
>   </resource-ref>
> 
> And here is the error I get from Tomcat when deploying the application:
> 2005-09-27 00:55:33,559 [http-8080-Processor25] ERROR 
> JDBCExceptionReporter - Cannot create JDBC driver of class '' for 
> connect URL 'null'
> 
> It almost seems as if the resource-ref is somehow overriding the 
> Resource definition in the application context.
> Any suggestions?
> 
> Thanks,
> Dave
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to