Veaceslav Chicu <[EMAIL PROTECTED]> writes:
> Hello,
>
> why this is not working?
> PreparedStatement st = conn.prepareStatement("select person_id,
> name, surname from tiers.person for update",
> ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
> ...
> rs.setObject(1, "aaa");
> rs.updateRow();
>
> in embeded mode?
Derby only supports forward-only updatable result sets. If you don't
need a scrollable result set, try the following:
conn.prepareStatement("select ... for update",
ResultSet.TYPE_FORWARD_ONLY,
ResultSet.CONCUR_UPDATABLE);
--
Knut Anders
