Hi all,
In a game I'm writing I get an error:
The result set is readonly. You may need to use
conn.createStatement(.., ResultSet.CONCUR_UPDATABLE). [90140-130]
st1 = con.createStatement();
rs1 = st1.executeQuery("SELECT * FROM CSVREAD('" + home +
"/Monsters.csv" + "')");
st2 = con.createStatement();
rs2 = st2.executeQuery("SELECT * FROM Monsters");
rsmd = rs2.getMetaData();
int cols = rsmd.getColumnCount();
while (rs1.next()) {
rs2.moveToInsertRow(); // fails here
for (int j = 1; j <= cols; j++) {
rs2.updateObject(j, rs1.getObject(j));
}
rs2.insertRow();
}
It works fine on my Windows machine.
any ideas?
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
