db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dag.Wan...@Sun.COM (Dag H. Wanvik)
Subject Re: updatable selects
Date Mon, 19 Nov 2007 15:42:34 GMT
Erik Steen Jakobsen <esj@logodata.dk> 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


Mime
View raw message