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]
