application server 9.0 with mysql

Hello!

I'm using glassfish with application server 9.0 and i want to connect with mysql.

My settings are:

datasource classname: com.mysql.jdbc.jdbc2.optional.MysqlDataSource

resource type: javax.sql.connectionpoolDataSource

ARE OK?

I use mysql connector 3.1.13, 5.0.2 or 3.1.13? which is correct?

Thanks

[353 byte] By [joelnatural] at [2007-11-26 9:01:02]

# 1

Hi,

Please take a look at the following blog which talks about using mysql with Glassfish:

http://weblogs.java.net/blog/amyroh/archive/2006/02/roller_21_on_gl_1.html

In this example the driver that she uses is sql-connector-java-3.1.12-bin.jar

Also, she uses the following:

datasource-classname="com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSour ce"

which is slightly different to the one that you are using... maybe you should try this....

Also, please take a look at the three furum posts already raised on similar issues to this:

http://forum.sun.com/jive/thread.jspa?threadID=102999

Hope this helps

roho at 2007-7-6 23:06:43 >

Application & Integration Servers New Topic