File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Problem of inserting java array into DB

 
Farakh khan
Ranch Hand
Posts: 833
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello,

I am facing problem with the following piece of code that everytime it inserts in db (#ofRecords * 3)



I printed on tomcat console and output is:
JobId=>34
cvId=>8062
status=>1

JobId=>34
cvId=>8075
status=>1

I mean it showing correct results as I inserted two records whilst in database I see 6 records after this code. This code always insert (number of records * 3). Why?

Here how I calling this method


Here what am seeing through SQL:




The problem fixed as there was nothing wrong with the code but in database 3 records for each CVs were exists that was inserted with wrong code.

Sorry for inconvenience

Best regards
 
Martin Vajsar
Sheriff
Pie
Posts: 3747
62
Chrome Netbeans IDE Oracle
  • 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I'd suggest to add a primary key or unique constraints to prevent creating duplicates in the first place. This should expose the culprit (the code that tries to create the duplicates).
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic