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" <tomcat-user@jakarta.apache.org>
To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
CC: tomcat-user@jakarta.apache.org
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: tomcat-user@jakarta.apache.org 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" <tomcat-user@jakarta.apache.org> >To: "Tomcat Users List" <tomcat-user@jakarta.apache.org> >CC: tomcat-user@jakarta.apache.org >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: tomcat-user@jakarta.apache.org > 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]
