wood burning stoves 2.0*
The moose likes JDBC and the fly likes Connection pool in Tomcat 4.1.3 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Connection pool in Tomcat 4.1.3" Watch "Connection pool in Tomcat 4.1.3" New topic
Author

Connection pool in Tomcat 4.1.3

lekha phijo
Greenhorn

Joined: Oct 09, 2003
Posts: 29
I have specified the configuration for jdbc in the server.xml
<Resource name="jdbc/mydb" auth="Container" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/mydb">
<parameter>
<name>driverClassName</name>
<value>org.gjt.mm.mysql.Driver</value>
</parameter>
<parameter>
<name>driverName</name>
<value>jdbc:mysql//localhost/authority</value>
</parameter>
<parameter>
<name>user</name>
<value>Lekha</value>
</parameter>
<parameter>
<name>password</name>
<value>abc</value>
</parameter>
<parameter>
<name>pool</name>
<value>ON</value>
</parameter>
<parameter>
<name>loop</name>
<value>ON</value>
</parameter>
</ResourceParams>



In my code when I look up for the datasource using JNDI I get the foll error
cannot create PoolableConnectionFactory cause,
A user Id and password are required to establish a JDBC connection
 
 
subject: Connection pool in Tomcat 4.1.3
 
Similar Threads
postgres pool with Tomcat 4.1
Static Connection object in BaseDAO class - Bad?
Tomcat4.1 ConnectionPool ( javax.naming.NameNot Found Exception: Name java:
Tomcat Database Connection Pooling Error
How to setup ConnectionPoolDataSource