wood burning stoves*
The moose likes JDBC and the fly likes Batch execute fails in DB2 V9 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Batch execute fails in DB2 V9" Watch "Batch execute fails in DB2 V9" New topic
Author

Batch execute fails in DB2 V9

Baskaran Eswaran
Greenhorn

Joined: Dec 16, 2010
Posts: 5
Hi,

After we migrated from DB2 v8 to v9. we are getting this error for the batch insert operation which was working previously in v8.


A NON-ATOMIC STATEMENT ATTEMPTED TO PROCESS MULTIPLE ROWS OF DATA, BUT ERRORS OCCURRED


Please anyone shed some light on this issue.


Thanks in advance,
Baskaran
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 29253
    
139

Can you share the query you were trying to run? (editing the column names for sensitive date of course)


[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: Batch execute fails in DB2 V9
 
Similar Threads
DB2 v9 slower than DB2 v8 while inserting DDL and DML Scripts using Ant script
"XML" datatype in hibernate
DB2 V9.1 for z/OS
upgrade to database causes memory fault when running app
JDBC batch statement