Importing table schema from MySQL using dbTab

[sugata_bagchi2]

Hello Experts,

any one have tried to export the table schema in ESR - part of dbTab using JDBC adapter from MySQL ?

I tired it and later compared the config from the below link -

But it is giving error as below -

'Error processing request in sax parser: Error when executing statement for table/stored proc. 'metadataRequest' (structure 'statement'): com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"lookuptable" WHERE 1<0' at line 1'.

The same is mentioned in the comment section of this blog.

can you please provide any input ?

Thanks in advance

Sugata B

[sugata_bagchi2 · Accepted solution]

issue resolved after adding  below query string in the connection data -

?sessionVariables=sql_Mode=ANSI

jdbc:mysql://<DBhost>:<port>/<DB Name>?sessionVariables=sql_Mode=ANSI