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 [joelnaturala] at [2007-10-3 1:18:47]
# 1
http://swforum.sun.com/jive/category.jspa?categoryID=10
CeciNEstPasUnProgrammeura at 2007-7-14 18:15:56 > top of Java-index,Java Essentials,New To Java...
# 2
where i go? please
joelnaturala at 2007-7-14 18:15:56 > top of Java-index,Java Essentials,New To Java...
# 3

Once again. All the info you need is in your server documentation. Try it out. If it does not work, post your configuration snippets, code snippets where the connection was made, and the error (preferrably with stack trace). We cannot read your mind (or scan your application from here) to find out what problem you might have or be having. And we can't help you fix it, even after we know what the problem (read symptom) is unless the config and code comes with it.

masijade.a at 2007-7-14 18:15:56 > top of Java-index,Java Essentials,New To Java...
# 4

Hello!

I'm using Glassfish and i'm attemting to configurate with mysql bd.

I did an application with java studio creator 2 update 1, and it connect with mysql perfectly, but when I put the application in to the server, I see the page but not connect to mysql and I don't see any error.

Can someone explain me how configure this connection?

I have problems with the classpath suffix, what connector use (version) and what resource type use:

- javax.sql.connectionPoolDataSource or javax.sql.datasource or javax.sql.XAdatasource

And what datasource classname?

I think that "com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource" but... i don't know. I'm very confusing.

Can someone help me, please?

Thanks

joeljoela at 2007-7-14 18:15:56 > top of Java-index,Java Essentials,New To Java...