db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Veaceslav Chicu ...@infologic.fr>
Subject Re: updatable resultSet
Date Wed, 05 Oct 2005 21:47:56 GMT
why derby don't support other types?
JTable want to scroll and update

I can't do such a simple application?

I want an simple updatable table with gui, how can I do it?
2.000.000 rows in the database

is this possible? any ideas?
jdk 1.5

Slavic

Knut Anders Hatlen wrote:
> Veaceslav Chicu <cs@infologic.fr> 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);
> 


Mime
View raw message