aspose file tools
The moose likes JDBC and the fly likes JDBC3.0 DataSource supported in mySQL and Connector/J? Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


Win a copy of The Mikado Method this week in the Agile and other Processes forum!
JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "JDBC3.0 DataSource supported in mySQL and Connector/J?" Watch "JDBC3.0 DataSource supported in mySQL and Connector/J?" New topic
Author

JDBC3.0 DataSource supported in mySQL and Connector/J?

Tina Coleman
Ranch Hand

Joined: Dec 12, 2001
Posts: 150
I'm interested in using the support for connection pooling available in JDBC3.0. Looking through the information available at www.mysql.com, I've been unable to determine whether the Connector/J JDBC driver supports the DataSource interface, and more specifically, the ConnectionPoolDataSource interface.
If anyone can verify that it does, indeed, support that interface, please also tell me how to set up my system to be able to access it through JNDI. (Haven't done anything with JNDI yet. . . I'm using Tomcat as our servlet container and don't know if it supports JNDI.)
Tina Coleman
Ranch Hand

Joined: Dec 12, 2001
Posts: 150
Found my own answer, with help from a thread in the Servlet forum. Tomcat's documentation shows how to do exactly what I was looking for. See Tomcat's documentation - Database Connection Pool Configurations. They spec directions for using Apache's DBCP, which I wasn't aware of at the time of writing my request.
Sheesh. . . the things you find when you look in the right place. . .
 
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
 
subject: JDBC3.0 DataSource supported in mySQL and Connector/J?
 
Similar Threads
NoInitialContextException
Java beans + JDBC
com.mysql.jdbc.Driver
ODBC connection for MySQL
any free JDBC driver for MS SQL