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 <[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);
> 

Reply via email to