Oracle JDBC error

[sagarika chinya]

Hi,
I am getting the following error when I try to connect through source code, But query works fine when executed through SQLPLUS.
Here is my code

 
void query(String check) {
ResultSet rs,rs1;
try {
Statement stat = connection.createStatement();
rs = stat.executeQuery(check);
while (rs.next()) {
String s = rs.getString("status");
System.out.println(" the output of check before update ie status is " + s);
}
String upd = "UPDATE rental SET status='Complete'"+"WHERE movie_id =775329438" +
"AND to_char(return_date,'YYYY/MM/DD') = '2001/04/20'"+ 
" AND status="+ "'Active'";
stat.executeUpdate(upd);
System.out.println("updated"); 
String q1 = "SELECT movie_id,to_char(return_date,'Month DD,YYYY')"+
"AS ReturnDate FROM rental" +
"WHERE movie_id = 775329438 "+
"AND return_date = '2001/04/20'";
rs1 = stat.executeQuery(q1);
while(rs1.next()) {
int n = rs1.getInt("movie_id");
String str2 = rs1.getString("ReturnDate");
System.out.println("movie_id is" + n);
System.out.println("returnDate is "+ str2);
}// while
} 
catch (Exception e) {
e.printStackTrace();
}
}
 

I am getting the following error
java.sql.SQLException: ORA-00933: SQL command not properly ended
at java.lang.Throwable.fillInStackTrace(Native Method)
at java.lang.Throwable.fillInStackTrace(Compiled Code)
at java.lang.Throwable.<init>(Compiled Code)
at java.lang.Exception.<init>(Exception.java:42)
at java.sql.SQLException.<init>(SQLException.java:43)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(Compiled Code)
at oracle.jdbc.ttc7.Oall7.receive(Compiled Code)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(Compiled Code)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:830)
at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2391)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2672)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:572)
at Banni1.query(Compiled Code)
at Banni1.main(Compiled Code)

Could anyone please help me to find where the problem could be.
Thanks
sagarika

[Rene Larsen]

Try check the SQL statement that you are building. - Look for missing spaces in the statment, e.g. status='Complete'"+"WHERE
Rene
[ October 19, 2002: Message edited by: Rene Larsen ]

[Sri, Shankar]

Print the statement to the std err and check before it goes into execute...
btw. as a side note...you should indent your code...