wood burning stoves*
The moose likes Oracle/OAS and the fly likes Error occurred during batching: ORA-00933: SQL command not properly ended Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Error occurred during batching: ORA-00933: SQL command not properly ended" Watch "Error occurred during batching: ORA-00933: SQL command not properly ended" New topic
Author

Error occurred during batching: ORA-00933: SQL command not properly ended

priya Anand
Greenhorn

Joined: Mar 30, 2009
Posts: 20
Hi
I am executing following code in my application and I am getting an error as,
: java.sql.BatchUpdateException:
error occurred during batching: ORA-00933: SQL command not properly ended


Any help is highly appreciated.

Thanks and Regards,
Priya
Jeanne Boyarsky
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 30764
    
156

Two debugging tips that will greatly narrow down your question:
1) Which is failing stmt or stmt1?
2) What is the literal String that you are passing in (after all the concatenation is done), does it work at command line Oracle?


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Error occurred during batching: ORA-00933: SQL command not properly ended