File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

error code when executing BatchUpdate

 
jeff zhang
Greenhorn
Posts: 9
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
When I tried to run a BatchUpdate command(executeBatch())
and got the following error info if the unique constraint
was violated.
getErrorCode() = 17081
getMessage() = error occurred during batching: ORA-00001: unique constraint (AWS.USERS_LOGIN_PK) violated
The SQLException was caught and the getErrorCode() returned 17081,
but not 1. Why?
Any help?
Thanks
Jeff
 
Jim Baiter
Ranch Hand
Posts: 532
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Did you disable the auto-commit? If not, do
connection.setAutoCommit(false);
 
jeff zhang
Greenhorn
Posts: 9
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Jim,
I did, but no help.
Thanks,
Jeff
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic