Skip to Content
1
Jun 22, 2020 at 01:09 PM

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

252 Views Last edit Jun 22, 2020 at 01:12 PM 3 rev

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!

Attachments

jdbc-adapter.png (17.9 kB)
message-mapping.png (187.5 kB)