Problem of inserting java array into DB

[Farakh khan]

Hello,

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

int count=0;
	String query1 =  " update jobResponses set responseStatus=? where cv_id=? and job_id=?;

	PreparedStatement ps=cnn.prepareStatement(query1);
		for (int i=0;i<cvId.length;i++){
			if(!cvId[i].equals("")){
				ps.setInt(1, 1);
				ps.setString(2, cvId[i]);
				ps.setString(3, jobId);
				ps.addBatch();    
			}				
			ps.executeBatch();
			count+=1;
		}
	ps.close();

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

	boolean isChanged = jd.changeStatus(jobId,cvId,1);//1=shortlisted

	if(isChanged){
		res.sendRedirect("/servlet/MyServlet?pageNo=1&jobId="+jobId+"&status="+1);
	}
	else{
		out.println(error);
	}

Here what am seeing through SQL:

SQL> select cv_id,responseStatus from jobResponses where responseStatus=1;

     CV_ID RESPONSESTATUS
---------- --------------
      8062              1
      8075              1
      8062              1
      8075              1
      8062              1
      8075              1

6 rows selected.

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]

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).