Thanks for the tip. I put it in the server.xml in the /CustomFares context but it didn't help. Is there are equivalent entry for the web.xml file?
>-----Original Message----- >From: Parsons Technical Services >[mailto:[EMAIL PROTECTED] >Sent: 15 March 2004 20:55 >To: Tomcat Users List; [EMAIL PROTECTED] >Subject: Re: Problem using JNDI/DBCP to get DataSouce > > >Paul, > >Add this to the context for each application that needs the database. > ><ResourceLink name="jdbc/OscarsDB" global="jdbc/OscarsDB" >type="javax.sql.DataSource"/> > >Doug Parsons >www.parsonstechnical.com > > > >----- Original Message ----- >From: "Paul Mahoney" <[EMAIL PROTECTED]> >To: "'Tomcat Users List'" <[EMAIL PROTECTED]> >Sent: Monday, March 15, 2004 2:28 PM >Subject: Problem using JNDI/DBCP to get DataSouce > > >My code looks up a DataSource instance using JNDI. It get an >instance but >all the fields are default or null values. When I try to get a >connection I >get the error > Exception: Cannot create JDBC driver of class '' for connect >URL 'null' >Its like it finds my configured resource, but the server has >not initialised >it... > >I have followed the How-To's and gone through it all countless times. I >can't get tomcat to give me any debug or extra logging to help >me track the >cause. Below are the gory details for those that can help me >(please!!!) > >Version - Tomcat 4.1.24 > >Web.xml (last part as to DTD) >----------------------------- > <resource-ref> > <description>Reference to factory javax.sql.DataSource to create >connection instances for OSCARS</description> > <res-ref-name>jdbc/OscarsDB</res-ref-name> > <res-type>javax.sql.DataSource</res-type> > <res-auth>Container</res-auth> > </resource-ref> >------------------------------ > >Server.xml >------------------------------- > <GlobalNamingResources> > <Environment name="simpleValue" override="true" >type="java.lang.Integer" >value="30"/> > <Resource auth="Container" description="User database that can be >updated and saved" name="UserDatabase" scope="Shareable" >type="org.apache.catalina.UserDatabase"/> > <Resource auth="Container" name="jdbc/OscarsDB" scope="Shareable" >type="javax.sql.DataSource"/> > <ResourceParams name="UserDatabase"> > <parameter> > <name>factory</name> > ><value>org.apache.catalina.users.MemoryUserDatabaseFactory</value> > </parameter> > <parameter> > <name>pathname</name> > <value>conf/tomcat-users.xml</value> > </parameter> > </ResourceParams> > <ResourceParams name="jdbc/OscarsDB"> > <parameter> > <name>url</name> > ><value>jdbc:informix-sqli://oscar1.travel2.com:1420/oscars:INFO >RMIXSERVER=os >cars_dbsrv</value> > </parameter> > <parameter> > <name>password</name> > <value>notreal</value> > </parameter> > <parameter> > <name>maxActive</name> > <value>10</value> > </parameter> > <parameter> > <name>maxWait</name> > <value>5000</value> > </parameter> > <parameter> > <name>driverClassName</name> > <value>com.informix.jdbc.IfxDriver</value> > </parameter> > <parameter> > <name>username</name> > <value>trip</value> > </parameter> > <parameter> > <name>maxIdle</name> > <value>2</value> > </parameter> > </ResourceParams> > </GlobalNamingResources> >--------------------------------------- > >Code extract >--------------------------------------- > if (dataSource == null) > { > try > { > synchronized (this) > { > if (dataSource == null) > { > Context initContext = new InitialContext (); > Context envContext = (Context) initContext.lookup >("java:comp/env"); > dataSource = (DataSource) envContext.lookup >("jdbc/OscarsDB"); > } > } > } > catch (NamingException ne) > { > // wrap it up in an SQLException to keep calling code simple > SQLException se = new SQLException ("JNDI Data Source lookup >failed"); > se.initCause (ne); > throw se; > } > } > > try > { > connection = dataSource.getConnection (); > } > catch (SQLException se) > { > throw se; > } > > return connection; > } >------------------------------- > >End of message, thank you for your time > >Paul > > >--------------------------------------------------------------------- >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]
