users@glassfish.java.net

Re: how to set connection pooling for mysql on glassfish v 2.1?

From: <glassfish_at_javadesktop.org>
Date: Wed, 27 May 2009 23:15:56 PDT

You could created a JDBC connection pool using the administration console (http://localhost:4848) or admin CLI (command line interface). The port, username, password, database name etc. are to be configured in the additional properties section of the jdbc connection pool.

To create a connection pool, use asadmin create-jdbc-connection-pool command. There are some templates available under <GF_INSTALL>/lib/install/templates/resources/jdbc directory. You could refer to the template to create a mysql jdbc connection pool and resource and use the asadmin add-resources command to create the same.

For more details on the above, refer:
http://blogs.sun.com/JagadishPrasath/entry/creating_jdbc_connection_pool_resource
http://blogs.sun.com/technical/entry/glassfish_v3_using_jdbc_connection
[Message sent by forum member 'sm157516' (sm157516)]

http://forums.java.net/jive/thread.jspa?messageID=348014