On Tue, 2002-07-02 at 08:47, Przemyslaw Kowalczyk wrote: > On Tuesday 02 July 2002 15:16, Les Hughes wrote: > > Ignore the "remove //" comment - I was looking at my oracle notes :-) > > I really have no idea why it's trying to load the hsql driver if there's no > > ref in your > > server.xml > > Ok, the full versions (I cut off all comments): > > przem
Przem, Here are the setting I have used with Tomcat 4.0.4, postgresql 7.2.1 & jdk1.4 I had to put the postgresql.jar, commons-dbcp.jar, commons-pool.jar into the <DIR>/common/lib directory. SERVER.XML: <Resource name="jdbc/tropicos" auth="Container" type="javax.sql.DataSource"/> <ResourceParams name="jdbc/tropicos"> <parameter> <name>factory</name> <value>org.apache.commons.dbcp.BasicDataSourceFactory</value> </parameter> <parameter><name>maxActive</name><value>100</value></parameter> <parameter><name>maxIdle</name><value>30000</value></parameter> <parameter><name>maxWait</name><value>100</value></parameter> <parameter><name>username</name><value>XXXXX</value></parameter> <parameter><name>password</name><value>XXXX</value></parameter> <parameter> <name>driverClassName</name> <value>org.postgresql.Driver</value> </parameter> <parameter> <name>url</name> <value>jdbc:postgresql://localhost:5432/ids_tropicos</value> </parameter> </ResourceParams> Then the web.xml cruft: <resource-ref> <description>PostgreSQL DB Connection</description> <res-ref-name>jdbc/tropicos</res-ref-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> </resource-ref> -- Brian Millett Enterprise Consulting Group "Shifts in paradigms (314) 205-9030 often cause nose bleeds." [EMAIL PROTECTED] Greg Glenn -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>