Showing results for 
Search instead for 
Did you mean: 

JDBC: Database-level error

Former Member
0 Kudos

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'.



Accepted Solutions (1)

Accepted Solutions (1)

Active Contributor
0 Kudos

give as

select * from employee where flag='X'

No whitespaces in the condition and try

Answers (2)

Answers (2)

Active Participant
0 Kudos

Hi Santosh,

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

Best Regards

Former Member
0 Kudos


Try with following sql query.

select * from employee where flag = "X".

Hope this helps.

Thanks and Regards,