Re: Pooled connections in Tomcat
От | Simon Mitchell |
---|---|
Тема | Re: Pooled connections in Tomcat |
Дата | |
Msg-id | 3E0EAC95.8020103@jseb.com обсуждение исходный текст |
Ответ на | Pooled connections in Tomcat (Thomas Wirth <thomaswirth@comcast.net>) |
Список | pgsql-jdbc |
Hi Thomas, I am running postgesql on tomcat 4.1.18 with jdk1.4.1 on win2000. Maybe you need to use <parameter><name>driverClassName</name><value>org.postgresql.Driver</value></parameter> Here are some of the configs i am using. server.xml <Resource name="jdbc/postgesql" scope="Shareable" type="javax.sql.DataSource" auth="Container"/> <ResourceParams name="jdbc/postgresql"> <parameter><name>factory</name><value>org.apache.commons.dbcp.BasicDataSourceFactory</value></parameter> <parameter><name>maxActive</name><value>100</value></parameter> <parameter><name>maxWait</name><value>100</value></parameter> <parameter><name>url</name><value>jdbc:postgresql://127.0.0.1:5432/mail</value></parameter> <parameter><name>driverClassName</name><value>org.postgresql.Driver</value></parameter> <parameter><name>maxIdle</name><value>30000</value></parameter> <parameter><name>username</name><value>username</value></parameter> <parameter><name>password</name><value>password</value></parameter> </ResourceParams> web.xml <description>postgresql</description> <resource-ref> <description>DB Connection</description> <res-ref-name>jdbc/postgresql</res-ref-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> </resource-ref> servlet/jsp Context initCtx = new InitialContext(); Context envCtx = (Context) initCtx.lookup("java:comp/env"); DataSource ds = (DataSource)envCtx.lookup("jdbc/postgresql"); Connection conn = ds.getConnection(); Regards, Simon Thomas Wirth wrote: >Hi, >I am trying to setup a DataSource for Postgre (7.2.2-1) in Tomcat >(4.1.12). Running on RedHat Linux 8, SDK is 1.4.1. I am using the >pg73jdbc2ee.jar jdbc-driver, which should have the support for >javax.sql.... See the Resource definition from server.xml below. I am >struggling with what value to use for the driverClassName. So far I have >tried >org.postgresql.Driver >org.postgresql.jdbc2.optional.PoolingDataSource >org.postgresql.jdbc2.optional.PooledConnectionImpl >org.postgresql.jdbc2.optional.ConnectionPool >All produce the same SQlException: Cannot load JDBC driver class 'null' > >Can someone who has this running give me a hint please. I can connect to >Postgre by establishing a connection via the DriverManager, so >connection url, database config,.. are OK. > >Thank you, >Thomas > > ><Resource > name="jdbc/pgdb" > auth="Container" > type="javax.sql.DataSource"/> > ><ResourceParams name="jdbc/pgdb"> ><parameter><name>factory</name> ><value>org.apache.commons.dbcp.BasicDataSourceFactory</value></parameter> ><parameter><name>username</name><value>user</value></parameter> <parameter><name>password</name><value>passwd</value></parameter> ><parameter><name>driverClassName</name> ><value>org.postgresql.jdbc2.optional.PoolingDataSource</value></parameter> ><parameter><name>url</name> ><value>jdbc:postgresql:db</value></parameter> ><parameter><name>maxActive</name><value>8</value></parameter> ><parameter><name>maxIdle</name><value>4</value></parameter> ></ResourceParams> > > > >---------------------------(end of broadcast)--------------------------- >TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org > > >
В списке pgsql-jdbc по дате отправления: