Erik Steen Jakobsen <[EMAIL PROTECTED]> writes: > All I get from derby is resultsets that are read_only when I ask for > concurrent updatable....
You can update through JDBC result sets if you specify ResultSet.CONCUR_UPDATABLE. You do not even need for specify "FOR UPDATE" in that case in the underlying query (default if you use CONCUR_UPDATABLE). But not all queries are updatable, cf. this section of the reference manual: http://db.apache.org/derby/docs/dev/ref/rrefsqlj41360.html#rrefsqlj41360__sqlj15384 Essentially, only simple, single table selects are updatable. Hope this helps! If not, can you provide a repro? Thanks, Dag
