com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table sql73488xx.dbTableName doesnt exist

[brenm1989]

Hi

I tried to post SQL Statements via JDBC Receiver Adapter.

According to documentation like here I built up the structure of my datatype (Message Mapping, right side)

I configured the JDBC Receicer Adapter as follows:

In the Monitoring I got the impression, that PI concatinates the table name (sql73488xx) with the secound tag ("dbTableName") and therefore the data base can't be found (sql73488xx).

I would be thankful for your input!

[brenm1989 · Accepted solution]

I got a hint, that JDBC Adapter requires an exact naming convention:

I had to replace one tag in the Receiver Datatyp. ("FROM" --> "table")