File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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
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
Data Integrity - Batch Programs in Weblogic 6.1
How to insert all the records except the failed one.
problem with BatchUpdateException
fast performance in jdbc insert
Uncommitted transaction state