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.