Hi. I think I have all the configuration fine, but for some reason when my DBTest try to get the connection from the DB I only get this:
----------------------------- ERRORS start ------------------------ java.sql.SQLException: Cannot load JDBC driver class 'null' at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSourc e.java:529) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.j ava:312) at poseidon.ext.DBTest.init(DBTest.java:27) ------------------------------ ERRORS end ------------------------- What's done: 1.) In the $CATALINA_HOME/common/lib I have postgresql.jar (PostgreSQL Driver), commons-collections.jar, commons-pool.jar, commons-dbcp.jar 2.) My server.xml: --------------- SERVER XML starts ------------------------ <Resource name="jdbc/art" auth="Container" type="javax.sql.DataSource"/> <ResourceParams name="jdbc/art"> <parameter> <name>factory</name> <value>org.apache.commons.dbcp.BasicDataSourceFactory</value> </parameter> <parameter> <name>driverClassName</name> <value>org.postgresql.Driver</value> </parameter> <parameter> <name>url</name> <value>jdbc:postgresql://efch-mia-sr-02.efcholdings.com:5432/efch-art</value> </parameter> <parameter> <name>username</name> <value>[username]</value> </parameter> <parameter> <name>password</name> <value>[password]</value> </parameter> <parameter> <name>maxActive</name> <value>20</value> </parameter> <parameter> <name>maxIdle</name> <value>10</value> </parameter> <parameter> <name>maxWait</name> <value>100</value> </parameter> </ResourceParams> ----------------------- SERVER.XML end -------------------------- All that code inside a context tag. 3.) My web.xml ----------------- STARTS --------------- <resource-ref> <description>postgreSQL Art's Datasource</description> <res-ref-name>jdbc/art</res-ref-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> </resource-ref> --------------------- END ------------------- 5.) I'm using Tomcat 4.1.16 with Apache 2.0, Plus PostgreSQL 7.3 and jdk 1.4.1 Tomcat starts fine, all works fine but when my DBTest is triying to get the connection I get the error mentioned before. I really don't know why tomcat is not seeing the Driver if it is on common/lib...??????????? Thanks in advance for your help. -- = Roberto Bouza Fraga = =================================== Research & Development Engineer Ella Cisneros Fontanals Holdings Ph: (305)-860-0116 / Fax:(305)-860-9401 =================================== e-Mail:[EMAIL PROTECTED] -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>