What version does openadaptor work with?
Tested using the version 3.0.9 of the MySQL JDBC driver and versions 4.0.16 and 3.23.58 of the MySQL database. For more details, see: http://www.mysql.com/documentation/connector-j/index.html http://www.mysql.com/documentation/index.html I get “SQL syntax near ‘CHAINED OFF'” The openadaptor JDBC components make use of the JdbcConnectionParams class to configure the JDBC connection. One of the properties it uses is UsingChainedTransactions. This works in “reverse” fashion as if it is not set then a “SET CHAINED OFF” command is issued. MySQL does not support this command so make sure that you avoid it by using the following line in your properties file: A.C2.UsingChainedTransactions = true Note that the “A.C2” prefix needs to be modified to suit your adaptor. I get an access denied error when I run the cookbook examples In order to run the Cookbook examples you must get the database administrater to create an account for oa_user by running the following command: GRANT USAGE ON [db].* TO
