关于CachedRowSet的疑问

[lj1558092371]

使用CachedRowSet的acceptChanges时候报出这样的异常，是什么原因
异常提示如下
Exception in thread "main" javax.sql.rowset.spi.SyncProviderException: 1 同步时发生冲突
at com.sun.rowset.internal.CachedRowSetWriter.writeData(Unknown Source)
at com.sun.rowset.CachedRowSetImpl.acceptChanges(Unknown Source)
at com.sun.rowset.CachedRowSetImpl.acceptChanges(Unknown Source)
at myproject.CachedRowSetTest.main(CachedRowSetTest.java:64)

[lj1558092371]

源代码如下

import java.io.FileInputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.Properties;

import javax.sql.rowset.CachedRowSet;
import javax.sql.rowset.RowSetFactory;
import javax.sql.rowset.RowSetProvider;

public class CachedRowSetTest {
	private static String driver;
	private static String url;
	private static String user;
	private static String password;
	public void initParam(String paramFile) throws Exception
	{
		Properties pop=new Properties();
		pop.load(new FileInputStream(paramFile));
		driver=pop.getProperty("driver");
		url=pop.getProperty("url");
		user=pop.getProperty("user");
		password=pop.getProperty("pass");
		
		
	}
	public CachedRowSet query(String sql) throws Exception
	{
		Class.forName(driver);
		Connection conn=DriverManager.getConnection(url, user, password);
		Statement statement=conn.createStatement();
		ResultSet rs=statement.executeQuery(sql);
		RowSetFactory factory=RowSetProvider.newFactory();
		CachedRowSet cachedRowSet=factory.createCachedRowSet();
		cachedRowSet.populate(rs);
		rs.close();
		statement.close();
		conn.close();
		return cachedRowSet;
		
		
	}
   public static void main(String[] args) throws Exception
   {
	   CachedRowSetTest cachedRowSetTest=new CachedRowSetTest();
	   cachedRowSetTest.initParam("F:/新建文件夹 (3)/codes/13/13.4/mysql.ini");
	   CachedRowSet rs=cachedRowSetTest.query("select * from student ");
	   rs.afterLast();
	   while(rs.previous())
	   {
		   System.out.println(rs.getString(1)+"\t"+rs.getString(2)+"\t"+rs.getString(3));
		   if(rs.getInt("id")==6)
		   {
			   rs.updateString("name", "qq");
		       rs.updateRow();
		       //rs.acceptChanges();
		   }
		   
	   }
	   Connection conn=DriverManager.getConnection(url,user,password);
	   conn.setAutoCommit(false);
	   rs.acceptChanges(conn);
	   
	   
	   
   }	

}

[lj1558092371]

我发现与语句没有问题，出问题的是数据库，只要我的数据表有一个字段用了unsigned not null auto_increment primarykey 他就报错