CachedRowSet更新H2中的记录

Question

我有一个带表的H2数据库

CREATE TABLE income_expense
(
  amount VARCHAR(255) NOT NULL,
  name VARCHAR(255) NOT NULL,
  ondate VARCHAR(255) NOT NULL
);

和一些像INSERT INTO income_expense VALUES ('10','Something','2015-04-15');这样的随机数据

然后，我用JDBC连接到这个数据库，并尝试通过CachedRowSet进行更新。

public void doUpdate()
{
    try
    { 
        Class.forName("org.h2.Driver");
        setConnection(
                DriverManager.getConnection("jdbc:h2:~/thisdb", "sa", ""));

        CachedRowSet crs2 = new CachedRowSetImpl();
        crs2.setType(CachedRowSet.TYPE_SCROLL_INSENSITIVE);
        crs2.setConcurrency(CachedRowSet.CONCUR_UPDATABLE);
        crs2.setCommand(
                "SELECT amount, name, ondate FROM income_expense");
        crs2.execute(getConnection());
        crs2.absolute(1);
        crs2.updateString("amount", "22");
        crs2.updateString("name"  , "33");
        crs2.updateString("ondate", "44");
        crs2.updateRow();
        crs2.acceptChanges();
    }
    catch (ClassNotFoundException | SQLException e)
    {
        System.out.println("Error occured." + e);
    }
}

此更新在同步时发生消息javax.sql.rowset.spi.SyncProviderException: 1冲突时失败。

我更新唱片做错了什么？

Answer 1

好吧..。只有在向表中添加主键之后，CachedRowSet更新才能正常工作：

ALTER TABLE income_expenses ADD COLUMN id INT NOT NULL AUTO_INCREMENT;
ALTER TABLE income_expenses ADD CONSTRAINT PRIMARY KEY (id);

和指定的列数，这些列构成唯一标识行的键，并将该列包含在SELECT中。

//First column from a command will be the key
crs2.setKeyColumns(new int[]{1});
crs2.setCommand("SELECT id, amount, name, ondate FROM income_expense");