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.
Here is my code:
String getEmpId=SQLQueriesHandler.getQuery("eis.toGetEmpId");
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.
Plz reply back soon
Thanks in Advance.
Regards,
urmyfriend
---------------------------------
Ahhh...imagining that irresistible "new car" smell?
Check outnew cars at Yahoo! Autos.
