Hi Bob,
It is hard to tell what the problem is from the code below, since that
code only refers to one table. A more complete picture of the code might
suggest some clues.
Thanks,
-Rick
On 5/18/17 3:53 PM, Bob M wrote:
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.