By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,640 Members | 2,167 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,640 IT Pros & Developers. It's quick & easy.

Getting Parse Error at or near and at character......

P: 3
Hi,

I am getting the parse error while i try to execute a simple sql query in postgres.

java.sql.SQLException: ERROR: parser: parse error at or near "and" at character 58

The Query has been changed and it is very much like the below one

select * from emp where empName like 'XXXXX' and empId=206

when I try to execute the same query in the postgresql console it is working fine but when i try to execute the same as a prepared statement from my java code it is giving the java.sql.SQLException like the above.

Do Anyone have the answer for this problem????????

Expecting a Quick response.

Regards,
urmyfriend.
Apr 25 '07 #1
Share this Question
Share on Google+
2 Replies


Expert 100+
P: 534
I suspect the problem could be with parsing of the 'XXXXX' value, maybe it's related to escaping of the single-quotes.

If you post the entire section of your code that deals with assembling and executing this query, it may help.
Apr 25 '07 #2

P: 3
I suspect the problem could be with parsing of the 'XXXXX' value, maybe it's related to escaping of the single-quotes.

If you post the entire section of your code that deals with assembling and executing this query, it may help.
Hi michaelb,
Here is my code:
String getEmpId=SQLQueriesHandler.getQuery("eis.toGetEmpI d");
psmt=conn.prepareStatement(getEmpId);
psmt.setString(1,empForm.getEmpName());
psmt.setInt(2,empForm.getDeptId());
System.out.println("The Query to empId with Parameters is : "+psmt.toString());
rs=psmt.executeQuery(getEmpId);

where the query will be like

select empId from empTab where empName like 'XXXXXXX' and deptId=13

And in the above code empForm is the Struts ActionForm object and getters are the form beans.
If i try to execute that as a statement it is executing well.
and also if i try to execute that query as a pprepare statement in the code itself it is executing well.
The only problem is when i try to get the query from the properties file eg:query.properties

The variable names are changed keeping the code as it is.

Thanks in Advance.

Regards,
urmyfriend
Apr 27 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.