Not able to access MySQL 5.0 database through JDBC adapter

, ,
1

Hi,
I have created a JDBC connection for mysql 5.0 and i created an insertsql adapter service.
i am getting the following error while executing the adapter service
kindly suggest which mysql version will be compatible with wm6 and how to over come this error.

Could not run ‘InsertOne’.
com.wm.app.b2b.server.ServiceException: [ART.117.4002] Adapter Runtime
(Adapter Service): Unable to invoke adapter service MySQL_Examples.Adapter_Service:InsertOne.
[ADA.1.316] Cannot execute the SQL statement “INSERT INTO sathishdb.ROOT@LOCALHOST.employee(Name, GlobalId) VALUES (?, ?)”. "
(42000/1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘@LOCALHOST.employee(Name, GlobalId) VALUES (‘sssss’, ‘s12345’)’ at line 1"
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘@LOCALHOST.employee(Name, GlobalId) VALUES (‘sssss’, ‘s12345’)’ at line 1

Connection details:
Transaction Type LOCAL_TRANSACTION
DataSource Class com.mysql.jdbc.jdbc2.optional.MysqlDataSource
serverName localhost
user root
password ******
databaseName sathishDB
portNumber 3306
networkProtocol
Other Properties

Thanks,
Sathish.

2

Hi Sathis,

which Version of the MySQL JDBC Connector are you using?
Check with the mysql homepage for updates.

Which JDBC Adapter Version are you using?

Which Adapter Template did you use for the service and how did you set it up?

Regards,
Holger

3

Hi Holger,
I am using the following versions

MySQL Version 5.0
JDBC Connector: mysql-connector-java-3.0.1-beta-bin.jar
webMethods JDBC Adapter 6.0.3
Adapter Service Template : InsertSQL Service

Thanks,
Sathish.

4

Hi.

Try to select your table from the current catalog.
Not from the other.

Thanks