java.sql.SQLException: ORA-00933: SQL command not properly ended
807603Dec 10 2004 — edited Jan 31 2008HI,
When I'm executing a query, it's giving the below error.
java.sql.SQLException: ORA-00933: SQL command not properly ended
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:579)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1892)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:830)
at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2437)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2722)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:589)
at com.db.DCVLocks.getLockCount(DCVLocks.java:474)
at com.db.DCVLocks.lockMatchAction(DCVLocks.java:530)
at com.ui.msw.utils.Utility$1.run(ForceMatchUtility.java:74)
at java.awt.event.InvocationEvent.dispatch(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
But when I execute the query in sqlplus, it's giving the result.
What could be done to avoid this?
Thanks in Advance....