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]
