I created a new Adapter Service (mysql connection).
My JDBC Adapter:
Transaction Type LOCAL_TRANSACTION
DataSource Class com.mysql.jdbc.jdbc2.optional.MysqlDataSource
user root (just for testing permissions)
Everything looks perfect except when I try a “SELECT” .
Unable to invoke adapter service mysql2:Mysqls2. [ADA.1.316] Cannot execute the SQL statement “SELECT teste01.ID FROM mysqlwm.ROOT@LOCALHOST.teste01 teste01”. "
Obviously this “ROOT@LOCALHOST” was not supposed to be there. I did not find out how to remove it. Anyone?