How do you set up the server.xml and web.xml files to use connection pooling in Tomcat using the org.gjt.mm.mysql.Driver JDLC driver (version mm.mysql-2.0.11)?
I have set up and used a simple data source, but I can't get the pooled one working - do I need to set it up differently? Originally, I had the following in server.xml: <Resource name="jdbc/mptest" auth="Container" type="javax.sql.DataSource"/> <ResourceParams name="jdbc/mptest"> <parameter><name>driverClassName</name><value>org.gjt.mm.mysql.Driver</v alue></parameter> <parameter><name>driverName</name><value>jdbc:mysql://localhost/mptest</ value></parameter> </ResourceParams> And the following in web.xml: <resource-ref> <description>Test</description> <res-ref-name>jdbc/mptest</res-ref-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> </resource-ref> This works fine, but no connection pooling. I tried substituting javax.sql.ConnectionPoolDataSource for javax.sql.DataSource, but this blows up. Can I set this up via config files? Or do I need to resort to code to set this up? Tia, R --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
