|
|
|
Re: BatchUpdateException: invalid batch command: invalid SELECT batch command 0 [message #547143 is a reply to message #546353] |
Thu, 15 July 2010 16:51 |
|
Batch writing is off by default, so if it is being used, you have configured it somwhere. Check your persistence.xml or SessionCustomizer.
Batch writing should work with Oracle 11g2, are you using the correct JDBC driver version for your database version? Are you using thin or oci?
Please include the full exception stack trace including the caused by, and the log on finest of the transaction. Also include your persistence.xml, or if not using JPA, your sessions.xml or other configuration.
James : Wiki : Book : Blog : Twitter
|
|
|
|
Re: BatchUpdateException: invalid batch command: invalid SELECT batch command 0 [message #550831 is a reply to message #547162] |
Wed, 04 August 2010 13:23 |
|
The error seems to be a database/driver issue.
Without the full stack trace there is little more I can do.
If you are turning batch writing on for just one process, it is odd that you do not turn it back off when that process is done.
Check your SQL and see if the error is a valid error, i.e. the database should have thrown an error for one of the SQL's in the batch.
You could try resetting the JDBC connection or connection pool when the error occurs to attempt to avoid the error reoccurring.
James : Wiki : Book : Blog : Twitter
|
|
|
Powered by
FUDForum. Page generated in 0.04155 seconds