This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes JDBC and the fly likes Records not getting inserted properly into the table in oracle Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Records not getting inserted properly into the table in oracle" Watch "Records not getting inserted properly into the table in oracle" New topic
Author

Records not getting inserted properly into the table in oracle

Santhosh ayiappan
Ranch Hand

Joined: Jan 30, 2007
Posts: 80

We are inserting approximately 80000 records in a single batch insert. But only 5000 records are getting inserted successfully. But if the record count is less than 70000, there are no issues(all the records are getting inserted properly).

Even there are no exceptions when executing the process.

We are using Weblogic 8.1.3. Is there any limit on the number of records that could be inserted in a batch insert.?

Any help is highly appreciated.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Records not getting inserted properly into the table in oracle
 
Similar Threads
problem with BatchUpdateException
How to insert all the records except the failed one.
Uncommitted transaction state
fast performance in jdbc insert
Data Integrity - Batch Programs in Weblogic 6.1