java.sql.SQLException: Invalid argument value: Duplicate entry '3' for key 1

[Satyajeet Kadam]

Hi, i am getting following error
I am using mysql database


<code>
java.sql.SQLException: Invalid argument value: Duplicate entry '3' for key 1
</code>

   
 
 try
{
con=ds.getConnection();
cadmin=con.createStatement();
/*
 * saving admin details*/
 
 
 stmtad=con.prepareStatement(AdminConstants.INSERT_CREATE_TSADMIN);  
 stmtCom=con.prepareStatement(AdminConstants.SEL_COUNT_REGISERED_TSADMIN);
 rscout= stmtCom.executeQuery();
 rscout.next();
 countCompany=rscout.getInt("count(*)");
 System.out.println("countCompany=="+countCompany);
 stmtad.setString(1,createActionForm.getTsadmName());
 stmtad.setString(2,createActionForm.getTsadmEmailid());
 [B]stmtad.setInt(3,countCompany+1[/B]);
 stmtad.executeUpdate();
 stmtad.close();
 

 
}
catch(Exception e)
{
e.printStackTrace();

}

  
 
public class AdminConstants 
{
 
static final String  SEL_COUNT_REGISERED_TSADMIN="select count(*) from ts_company";
public static final String  INSERT_CREATE_TSADMIN="insert into ts_user(name,email,[B]user_id[/B])values(?,?,?)";


}
[CODE]  
 

 

ts_user CREATE TABLE `ts_user` (
`user_id` int(11) NOT NULL auto_increment,
`ref_company_id` int(11) default NULL,
`email` varchar(50) default NULL,
`password` varchar(10) default NULL,
`name` varchar(25) default NULL,
PRIMARY KEY (`user_id`),
KEY `ref_company_id` (`ref_company_id`),
FOREIGN KEY (`ref_company_id`) REFERENCES `ts_company` (`company_id`)
) TYPE=InnoDB


[/CODE]

[Scott Selikoff]

Please do not duplicate post.

To answer your question for both posts as previously stated, DO NOT USE COUNT(*) FOR AUTO_INCREMENT, your record count is out of sync with your data.

[Jeanne Boyarsky]

Please continue conversation in your other thread.