On 4/15/05, Sevillano sevi llano <[EMAIL PROTECTED]> wrote: > I don�t know if it helps, but this is my environment: > > j2sdk1.4.2_07 > tomcat 5.0.28 > oracle 9 > > j2sdk1.4.2_07 > tomcat 5.0.28 > mysql (I don�t remember the version, this is my home environment) > > thanks > > >From: "Sevillano sevi llano" <[EMAIL PROTECTED]> > >Reply-To: "Tomcat Users List" <[email protected]> > >To: [email protected] > >Subject: Re: can�t Configurate Database Connection Pool (DBCP) with Tomcat > >5.0.28 > >Date: Fri, 15 Apr 2005 09:48:29 +0000 > > > >I think JDBC Drivers are correctly installed, because direct connection > >works correctly: > >DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver()); > >conn = > >DriverManager.getConnection("jdbc:oracle:thin:@*.*.*.*:1521:bddesa","**","**"); > > > > > >I have the .jar files in > >Tomcat 5.0\common\lib > > > > > >>From: "Benjamin Cuthbert" <[EMAIL PROTECTED]> > >>Reply-To: "Tomcat Users List" <[email protected]> > >>To: "Tomcat Users List" <[email protected]> > >>CC: [email protected] > >>Subject: Re: can�t Configurate Database Connection Pool (DBCP) with > >>Tomcat 5.0.28 > >>Date: Fri, 15 Apr 2005 10:45:01 +0100 > >> > >>And you have the JDBC Driver installed, and tomcat comes up with no > >>errors. > >> > >>Are you just trying to setup user authentication against a database > >>instead of tomcat-users.xml > >> > >> > >> > >>Ben Cuthbert > >>Deutsche Bank - Global Markets > >>TISO Customer Trading Technology > >>PGP: http://pgp.mit.edu > >> > >>+44 (0) 20 754 76389 (Tel) > >>+44 (0) 20 754 74996 (Fax) > >> > >> > >> > >> > >>"Sevillano sevi llano" <[EMAIL PROTECTED]> > >>04/15/2005 10:41 AM > >>Please respond to "Tomcat Users List" > >> > >> To: [email protected] > >> cc: > >> Subject: Re: can�t Configurate Database Connection Pool > >>(DBCP) with Tomcat 5.0.28 > >> > >> > >>Hi Benajmin, > >> > >>I�m testing with two different databases: > >>oracle 9 and mysql > >> > >>with both I�ve got the same error > >>org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of > >>class '' for connect URL 'null' > >> > >>and with both I can connect directly > >>for example, it works correctly: > >>... > >>DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver()); > >>conn = > >>DriverManager.getConnection("jdbc:oracle:thin:@*.*.*.*:1521:bddesa","**","**"); > >>... > >> > >> > >>Thanks very much > >> > >> > >> >From: "Benjamin Cuthbert" <[EMAIL PROTECTED]> > >> >Reply-To: "Tomcat Users List" <[email protected]> > >> >To: "Tomcat Users List" <[email protected]> > >> >CC: [email protected] > >> >Subject: Re: can�t Configurate Database Connection Pool (DBCP) with > >>Tomcat > >> >5.0.28 > >> >Date: Fri, 15 Apr 2005 10:36:30 +0100 > >> > > >> >Sevillano > >> > > >> >Can you show me your JDBC configuration. > >> > > >> > > >> > > >> >Ben Cuthbert > >> >Deutsche Bank - Global Markets > >> >TISO Customer Trading Technology > >> >PGP: http://pgp.mit.edu > >> > > >> >+44 (0) 20 754 76389 (Tel) > >> >+44 (0) 20 754 74996 (Fax) > >> > > >> > > >> > > >> > > >> >"Sevillano sevi llano" <[EMAIL PROTECTED]> > >> >04/15/2005 10:34 AM > >> >Please respond to "Tomcat Users List" > >> > > >> > To: [email protected] > >> > cc: > >> > Subject: can�t Configurate Database Connection Pool > >>(DBCP) > >> >with Tomcat 5.0.28 > >> > > >> > > >> >Hi, I�m a newbie trying to configurate DBCP with Tomcat 5.0.28 > >> > > >> >I�m following this documentation: > >> >http://jakarta.apache.org/tomcat/tomcat-5.0-doc/jndi-datasource-examples-howto.html > >> > > >> > > >> >"...Add this in between the </Context> tag of the examples context and > >>the > >> > > >> ></Host> tag closing the localhost definition..." > >> >but there is no </Context> in my server.xml > >> > > >> >also I�ver read tons of forums about this question, and I�ve tested a > >>lot > >> >of > >> >different configuration. > >> > > >> >this is the error I�ve got (the usual I think): > >> >org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of > >> >class '' for connect URL 'null' > >> > > >> > > >> > > >> >any help please? I�ve been the whole week trying to fix it > >> > > >> >thanks > >> > > >> > > >> > > >> > > >> >these are my files: > >> > > >> >SERVER.XML > >> > > >> ><Server port="8005" shutdown="SHUTDOWN"> > >> > > >> > > >> > <GlobalNamingResources> > >> > <!-- Used by Manager webapp --> > >> > <Resource name="UserDatabase" auth="Container" > >> > type="org.apache.catalina.UserDatabase" > >> > description="User database that can be updated and saved"> > >> > </Resource> > >> > <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> > >> > > >> > > >> > <Resource name="jdbc/myoracle" auth="Container" > >> >type="javax.sql.DataSource"/> > >> > <ResourceParams name="jdbc/myoracle"> > >> > > >> ><parameter><name>factory</name><value>org.apache.commons.dbcp.BasicDataSourceFactory</value></parameter> > >> > <parameter><name>username</name><value>***</value></parameter> > >> > <parameter><name>password</name><value>***</value></parameter> > >> > > >> ><parameter><name>driverClassName</name><value>oracle.jdbc.driver.OracleDriver</value></parameter> > >> > > >> ><parameter><name>url</name><value>jdbc:oracle:thin:@****:1521:bddesa</value></parameter> > >> > > >><parameter><name>removeAbandoned</name><value>false</value></parameter> > >> > > >> ><parameter><name>removeAbandonedTimeout</name><value>300</value></parameter> > >> > <parameter><name>logAbandoned</name><value>true</value></parameter> > >> > <parameter><name>maxActive</name><value>10</value></parameter> > >> > </ResourceParams> > >> > > >> > > >> > </GlobalNamingResources> > >> > > >> > <Service name="Catalina"> > >> > <Connector port="8080" /> > >> > > >> > <!-- This is here for compatibility only, not required --> > >> > <Connector port="8009" protocol="AJP/1.3" /> > >> > > >> > <Engine name="Catalina" defaultHost="localhost"> > >> > <Logger className="org.apache.catalina.logger.FileLogger" /> > >> > > >> > <Realm className="org.apache.catalina.realm.UserDatabaseRealm" > >> > resourceName="UserDatabase" /> > >> > > >> > <Host name="localhost" appBase="webapps" /> > >> > </Engine> > >> > </Service> > >> ></Server> > >> > > >> > > >> > > >> >WEB.XML > >> > > >> ><?xml version="1.0" encoding="ISO-8859-1"?> > >> > > >> ><web-app xmlns="http://java.sun.com/xml/ns/j2ee"; > >> > xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; > >> > xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee > >> >http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd"; > >> > version="2.4"> > >> > > >> > <display-name>Welcome to Tomcat</display-name> > >> > <description> > >> > Welcome to Tomcat > >> > </description> > >> > > >> > <resource-ref> > >> > <res-ref-name>jdbc/myoracle</res-ref-name> > >> > <res-type>javax.sql.DataSource</res-type> > >> > <res-auth>Container</res-auth> > >> > </resource-ref> > >> > > >> ></web-app> > >> > > >> > > >> > > >> > > >> >TEST.JSP > >> > > >> >... > >> >Context initContext = new InitialContext(); > >> >Context envContext = (Context)initContext.lookup("java:/comp/env"); > >> >DataSource ds = (DataSource)envContext.lookup("jdbc/myoracle"); > >> >conn = ds.getConnection(); > >> >... > >> > > >> >_________________________________________________________________ > >> >Descarga gratis la Barra de Herramientas de MSN > >> >http://www.msn.es/usuario/busqueda/barra?XAPID=2031&DI=1055&SU=http%3A//www.hotmail.com&HL=LINKTAG1OPENINGTEXT_MSNBH > >> > > >> > > >> > > >> >--------------------------------------------------------------------- > >> >To unsubscribe, e-mail: [EMAIL PROTECTED] > >> >For additional commands, e-mail: [EMAIL PROTECTED] > >> > > >> > > >> > > >> > >>_________________________________________________________________ > >>Un amor, una aventura, compa��a para un viaje. Reg�strate gratis en MSN > >>Amor > >>& Amistad. http://match.msn.es/match/mt.cfm?pg=channel&tcid=162349 > >> > >> > >>--------------------------------------------------------------------- > >>To unsubscribe, e-mail: [EMAIL PROTECTED] > >>For additional commands, e-mail: [EMAIL PROTECTED] > >> > >> > >> > > > >_________________________________________________________________ > >Acepta el reto MSN Premium: Protecci�n para tus hijos en internet. > >Desc�rgalo y pru�balo 2 meses gratis. > >http://join.msn.com?XAPID=1697&DI=1055&HL=Footer_mailsenviados_proteccioninfantil > > > > > >--------------------------------------------------------------------- > >To unsubscribe, e-mail: [EMAIL PROTECTED] > >For additional commands, e-mail: [EMAIL PROTECTED] > > > > _________________________________________________________________ > Descubre la descarga digital con MSN Music. M�s de medio mill�n de > canciones. http://music.msn.es/ > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > >
If it is not yet solved try removing <resource-ref> from web.xml. Another option is not to use <GlobalNamingResources> instead follow the instructions exactly given in the URL you have posted. BTW I couldnt find any <context> configured in your server.xml. May be it is the reason. -- Anto Paul --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
