Mysql jdbc driver connection

[busybee]

hi, can someone please tell me how to configure a jdbc adapter connection to a mysql database. i have copied the jar file to IS/lib/jar. when i installed mysql, i did not create any users. what should the username, password and other parameter values be for this config.

thank yu,
busybee

[san]

hi busybee,

i hope you are using connector-j for your mysql database. refer to the documentation at
http://www.mysql.com/documentation/connector-j/index.html.

Regards
San
"Be Good, Do Good".

[gperezpr]

Hi busybee
In this forum, there was already a discussion about this issue, please refer to:
http://www.wmusers.com/wmusers/messages/1825/25619.shtml
Try it and see if it solve your problems

Regards
Gonzalo

[busybee]

thanks, Sanjay and Gonzalo. I did follow the links that you pointed and followed the instructions. When I try to enable the connection, I get the following error :

"
Error encountered
[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource conn:jdbcconn.
[ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.
null
"

When I look at the error log, following is the stack trace I obtained.

com.wm.pkg.art.error.DetailedServiceException: [ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource conn:jdbcconn.
[ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.
null
at com.wm.pkg.art.error.DetailedServiceException.create(DetailedServiceException.java:125)
at com.wm.pkg.art.error.DetailedServiceException.create(DetailedServiceException.java:116)
at com.wm.pkg.art.error.DetailedServiceException.create(DetailedServiceException.java:103)
at com.wm.pkg.art.ns.ConnectionDataNodeManager.setConnectionState(ConnectionDataNodeManager.java:1047)
at java.lang.reflect.Method.invoke(Native Method)
at com.wm.app.b2b.server.JavaService.baseInvoke(JavaService.java:287)
at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:344)
at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:119)
at com.wm.app.b2b.server.ns.Namespace.invoke(Namespace.java:522)
at com.wm.util.template.Reporter.invoke(Reporter.java:963)
at com.wm.util.template.InvokeToken.eval(InvokeToken.java:75)
at com.wm.util.template.TemplateToken.evalChild(TemplateToken.java:214)
at com.wm.util.template.SwitchToken.evalChild(SwitchToken.java:90)
at com.wm.util.template.TemplateToken.eval(TemplateToken.java:180)
at com.wm.util.template.SwitchToken.eval(SwitchToken.java:58)
at com.wm.util.template.TemplateToken.evalChild(TemplateToken.java:214)
at com.wm.util.template.IfVarToken.evalChild(IfVarToken.java:239)
at com.wm.util.template.TemplateToken.eval(TemplateToken.java:180)
at com.wm.util.template.IfVarToken.eval(IfVarToken.java:219)
at com.wm.util.template.TemplateToken.evalChild(TemplateToken.java:214)
at com.wm.util.template.TemplateToken.eval(TemplateToken.java:180)
at com.wm.util.template.Reporter.reportNoReset(Reporter.java:1299)
at com.wm.util.template.Reporter.reportToOutput(Reporter.java:1274)
at com.wm.util.template.Reporter.reportIData(Reporter.java:1163)
at com.wm.app.b2b


Any thoughts or suggestions would be appreciated.

Regards,
busybee

[gperezpr]

Hi busy:

I'm sorry, but that Java Error do not tell much, could you send us information about the connections settings.

Regards
Gonzalo Pérez-Prim López

[balasubramanya]

I am trying to connect to my SQL with following connection parameters but I am getting following error

[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource Balasubramanya:MySQL.
[ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.
null

can anyone help me?
Connection Details:
Transaction Type:NO_TRANSACTION
DataSource Class: com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource
ServerName: localhost (Your_mysql_server_name)
user: root (Your_mysql_user_name)
password: whatever
database name: your_mysql_database_name
port_number: 3306 (mysql default)
networkProtocol: <leave>
Other Properties: <leave>

Connection Management Properties:
Enable Connection Pooling: true
Minimum Pool Size: 1
Maximum Pool Size: 10
Block TimeOut: 1000
Expire TimeOut: 1000

[paul hasse]

Hi Balasubramanya

I have successfully set up a connection pool using the similar settings to yours.

which version of the mysql j-connector are you using?

[gauravjain512]

Try this as the DataSource class ...

com.mysql.jdbc.jdbc2.optional.MysqlDataSource

Thanks
Gaurav