I know it’s not supported by webMethods, but I saw a couple posts where it seemed that suggest others have successfully had webMethods connect to MySQL with Connector/J.

I set up a JDBC Adapter connection to my MySQL server and am trying to create an Adapter Service that does a simple select from a table.

I think the problem is that the syntax webMethods sends is like this:

SELECT t1.dmh_store,t1.dmh_ticket…FROM rmps.WEBMETHODS@RH-MYSQL-2.RED-MAN.COM.dmh t1 WHERE…

because the error comes back from MySQL as:

“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 ‘@RH-MYSQL-2.RED-MAN.COM.dmh t1 WHERE…’”

I’ve never seen the username and host passed in the select statement like that, and was wondering if there is a way to turn that off? the statement should read like:

SELECT t1.dmh_store,t1.dmh_ticket…FROM rmps.dmh t1 WHERE…

Thanks for any help you all can provide.