Search...
FAQs Subscribe
Pie
FAQs
Recent topics Flagged topics Hot topics Best topics
Search...
Search within JDBC and Relational Databases Search Coderanch
Advance search Google search
Register / Login
book review grid polymorphism granny advertise on coderanch thread boost
Win a copy of Practice Tests for OCP Java 17 Certification Exam (1Z0-829) this week in the OCPJP forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
thread boost building better world book advertise on coderanch book review grid meaningless drivel
this forum made possible by our volunteer staff, including ...
Marshals:
  • Tim Cooke
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Liutauras Vilda
Sheriffs:
  • Rob Spoor
  • Junilu Lacar
  • paul wheaton
Saloon Keepers:
  • Stephan van Hulst
  • Tim Moores
  • Tim Holloway
  • Carey Brown
  • Scott Selikoff
Bartenders:
  • Piet Souris
  • Jj Roberts
  • fred rosenberger

Batch Insertion

 
Meet Gaurav
Ranch Hand
Posts: 492
posted 12 years ago
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
    Send
  • Quote
  • Report post to moderator
Hi

Am trying to insert data in Batch using int[] updateCounts = stmt.executeBatch();. In case If I have duplicate records it's not inserting original records also simply throwing exception.

Am expecting, In case I have 10 records 2 or duplicate, am expecting remaining 8 to be inserted.

Exception

09/10/12 18:17:32 java.sql.BatchUpdateException: error occurred during batching: ORA-00001: unique constraint (Schema) violated
 
Paul Sturrock
Bartender
Posts: 10336
I like...
Hibernate Eclipse IDE Java
posted 12 years ago
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
    Send
  • Quote
  • Report post to moderator
executeBatch will only work if all statements in the batch are successful.

JavaRanch FAQ HowToAskQuestionsOnJavaRanch

 
Meet Gaurav
Ranch Hand
Posts: 492
posted 12 years ago
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
    Send
  • Quote
  • Report post to moderator
Please suggest me which one will be suitable for my requirement.
 
Jeanne Boyarsky
author & internet detective
Posts: 41110
848
I like...
Eclipse IDE VI Editor Java
posted 12 years ago
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
    Send
  • Quote
  • Report post to moderator
You could do them one at a time and commit after each rather than using a batch.

[OCP 17 book] | [OCP 11 book] | [OCA 8 book] [OCP 8 book] [Practice tests book] [Blog] [JavaRanch FAQ] [How To Ask Questions] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2

 
Meet Gaurav
Ranch Hand
Posts: 492
posted 12 years ago
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
    Send
  • Quote
  • Report post to moderator
But am doing morethan 2000 insertion in a single shot. If I do one by one then it's a performance issue :-(
 
Paul Sturrock
Bartender
Posts: 10336
I like...
Hibernate Eclipse IDE Java
posted 12 years ago
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
    Send
  • Quote
  • Report post to moderator
If you need to continue after inserts that don't work you cannot batch them. You are going to have to handle them one at a time.

JavaRanch FAQ HowToAskQuestionsOnJavaRanch

 
Ram Para
Ranch Hand
Posts: 50
posted 12 years ago
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
    Send
  • Quote
  • Report post to moderator
why don't you simply remove duplicates and then insert the records ?

Ram Parashar
http://doinfinite.com

 
Meet Gaurav
Ranch Hand
Posts: 492
posted 12 years ago
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
    Send
  • Quote
  • Report post to moderator
At java level I don't have any clue to identify the primary key. Not suitable..
 
Jan Cumps
Bartender
Posts: 2661
19
I like...
Netbeans IDE C++ Linux
posted 12 years ago
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
    Send
  • Quote
  • Report post to moderator

Meet Gaurav wrote:At java level I don't have any clue to identify the primary key. Not suitable..

Conclusion: one by one.

Regards, Jan

OCUP UML fundamental and ITIL foundation

 
pie. tiny ad:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
reply
reply
    Bookmark Topic Watch Topic
  • New Topic
Boost this thread!
Similar Threads
More...