Hi Rebecca, Unless your JDBC driver and/or database support updateable result sets, then you cannot use them. The documentation for your driver and database should mention these details. With my Oracle 8i database and the Oracle (thin) JDBC driver, there are restrictions on the type of database query I can execute if I want an updateable result set -- even though that combination is supposed to support updateable result sets. Hope this helps. Good Luck, Avi.
Joined: Feb 20, 2003
Thank you for the information. My query has a join. I guess that's y i'm unable to update the resultset. Rebecca
Peter den Haan
Joined: Apr 20, 2000
It certainly will be. Only a few databases support updating the results of joins, and even then only under very specific circumstances. - Peter