Invalid SQL statement or JDBC escape

HJlassi1619437866 — Thu, 18 Nov 2021 08:51:28 GMT

Hello everyone,

I hope you're doing well,

I'm having an error in reading a string global map variable in a query clause

I get this error every time i ran my job "tdbInput 10 Invalid SQL statement or JDBC escape, terminating ''' not found"

here i get my string, than i just use a "globalMap.put("SERVICE_EMAIL", input_row.SERVICE_EMAIL);" in "tJavaRow"

Than i try to use it in another tdbinput (Microsoft Sql Server)

And i get this error "tdbInput 10 Invalid SQL statement or JDBC escape, terminating ''' not found"

Have anyone face it before ?

I'll appreciate your help, thank you.

Re: Invalid SQL statement or JDBC escape

MattE — Thu, 18 Nov 2021 09:39:26 GMT

The problem isn't with the global variable it is that your SQL statement is incomplete. You need to wrap the string in single quote

"...where lower(b.[eme_email]) in ('"+(String)globalMap.get("service_email)+"')"