JDBC: Database-level error

[Former Member]

Hi Folks,

I'm trying a JDBC to JDBC scenario and I'm getting the following error.

*Database-level error reported by JDBC driver while executing statement 'select * from EMPLOYEE where flag = 'X'.'. The JDBC driver returned the following error message: 'java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'flag = 'X'.'.'. For details, contact your database server vendor.*

My select statement is : select * from employee where flag = 'X'.

Regards,

Santosh

[Shabarish_Nair · Accepted solution]

give as

select * from employee where flag='X'

No whitespaces in the condition and try

[former_member732072]

Hi Santosh,

Please have a look at the following link and see if it helps

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

Best Regards

[Former Member]

Hi,

Try with following sql query.

select * from employee where flag = "X".

Hope this helps.

Thanks and Regards,

Kalpesh