Hi Until recently I had just the one single derby database table and could update it successfully. I now have two separate tables - the first is updating successfully, the second is NOT!
I use similar code for both............................ ********************************************************* psInsert = conn.prepareStatement("INSERT INTO xxxxx VALUES (?, ?, ?)"); statements.add(psInsert); psInsert.setInt(1, aaaaaaaa); psInsert.setString(2, bbbbb); psInsert.setString(3, ccccc); psInsert.executeUpdate(); // commit the above transactions conn.commit(); ********************************************************* I update the two tables, one after the other. Is there some missing code or am I not understanding something? Thanks for any advice / comments :) Bob M New Zealand -- View this message in context: http://apache-database.10148.n7.nabble.com/Updating-2-derby-tables-tp147386.html Sent from the Apache Derby Users mailing list archive at Nabble.com.