Monday, December 22, 2008

setup mysql in glassfish

1) Copy mysql-connector-java-[version].jar to /domain//lib
2) GlassfishAdmin:4848>Resources>JDBC/connection Pools/ New JDBC Connection Pool
-Name: <__mysqlpool>
-ResourceType:
-DatabaseVendor:

Click next> Additional Properties

Setup 5 parameters below:
-databaseName:
-user:
-password:
-serverName:
-portNumber:<3306>

Click Finish. Try ping the connection pool.

3)Goto Resources/JDBC/JDBC Resources Click New.
-JNDI Name:
-Pool Name: <__mysqlpool>
-status:
Create New.

No comments:

Post a Comment