List:MySQL and Java« Previous MessageNext Message »
From:Anuradha D Dodda Date:April 24 2004 4:22pm
Subject:Which mysql driver to use for WAS5.0.2 on AIX
View as plain text  



Hello All,
We are using Mysql with Websphere Application Server V5.0.2 on AIX.
To setup WAS5.0 datasource we have used MysqlConnectionPoolDataSource from
mysql-connector-java-3.0.11-stable-bin.jar
and "com.ibm.websphere.rsadapter.ConnectJDBCDataStoreHelper" as a
datasource helper class.
It looks like we have a problem in using these drivers with the above
version of WAS on AIX.
We are using prepared statements.
It gives SQLException with message "Parameter with index 2 is not set."
when we are running a prepared statement with only one parameter.
After we changed prepared statements to statements it neither gave the
above exception nor fetched the results.
Please help us with this problem!!
Please suggest a MySql driver that supports WAS5.0.2.
Thanks in advance!!

With Warm Regards,
Anu

Thread
Which mysql driver to use for WAS5.0.2 on AIX Anuradha D Dodda24 Apr