File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
JDBC and Relational Databases
Batch execute fails in DB2 V9
Joined: Dec 16, 2010
May 11, 2011 21:08:31
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,
author & internet detective
Joined: May 26, 2003
May 12, 2011 19:14:44
Can you share the query you were trying to run? (editing the column names for sensitive date of course)
OCA 8 book
How To Ask Questions The Smart Way
SCEA Part 1
Part 2 & 3
Core Spring 3
TOGAF part 1
I agree. Here's the link:
subject: Batch execute fails in DB2 V9
DB2 v9 slower than DB2 v8 while inserting DDL and DML Scripts using Ant script
"XML" datatype in hibernate
upgrade to database causes memory fault when running app
DB2 V9.1 for z/OS
JDBC batch statement
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015