db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Fernanda Pizzorno <Fernanda.Pizzo...@Sun.COM>
Subject Re: Garbage Collector and memory
Date Tue, 25 Oct 2005 11:56:29 GMT
Juan Ignacio Villa wrote:

>  Consulta =
>  Rs = Consulta.executeQuery(sql);

Scrollable sensitive result sets (ResultSet.TYPE_SCROLL_SENSITIVE) are 
not implemented
in Derby. Scrollable insensitive result sets 
implemented in Derby, but only with concurrency ResultSet.CONCUR_READ_ONLY.

If your application needs updatable result sets (ie. if you are going to 
use updateXXX,
updateRow(), insertRow() or deleteRow() methods), you will have to use 
forward only result
sets (ResultSet.TYPE_FORWARD_ONLY), and you will only be able to move 
between rows in the
result set using next().

On the other hand, if you do not need to use updatable result sets, you 
can use scrollable
insensitive result sets. The difference between this type and the one 
you are using is that
it is not sensitive to changes to the underlying table.

Since the result set type and concurrency you are trying to use are not 
implemented in
Derby, the driver will generate a SQLWarning. And you can check the type 
and concurrency
of the result set returned by the driver using ResultSet.getType() and
ResultSet.getConcurrency() respectively.


View raw message