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.


Reply via email to