WmDeveloper - ServiceException

I created a new Adapter Service (mysql connection).

My JDBC Adapter:
Connection Properties
DataSource Class com.mysql.jdbc.jdbc2.optional.MysqlDataSource
user root (just for testing permissions)
password ******
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?

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

On the “Tables” , I have:

Table Alias Teste01
Table Name mysqlwm..teste01
Type Table

I cannot remove this !!

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