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 Problem of inserting java array into DB Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Problem of inserting java array into DB " Watch "Problem of inserting java array into DB " New topic
Author

Problem of inserting java array into DB

Farakh khan
Ranch Hand

Joined: Mar 22, 2008
Posts: 732
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

Joined: Aug 22, 2010
Posts: 3610
    
  60

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).
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Problem of inserting java array into DB