WmDeveloper - ServiceException

, ,
1

I created a new Adapter Service (mysql connection).

My JDBC Adapter:
Connection Properties
Transaction Type LOCAL_TRANSACTION
DataSource Class com.mysql.jdbc.jdbc2.optional.MysqlDataSource
serverName
user root (just for testing permissions)
password ******
databaseName
portNumber 3306
networkProtocol tcp

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?

2

Edit the Table Name value on the Tables tab of your adapter service.

3

On the “Tables” , I have:

Table Alias Teste01
Table Name mysqlwm..teste01
Type Table

I cannot remove this !!

4

Sorry !! I know nothing about this…lol :o This works : ..teste01