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 Thu, 06 Oct 2005 05:27:59 GMT
in embeded environement this works?

so no chanses to see this working in derby?

best regards,
Slavic

Satheesh Bandaram wrote:
> I believe it is by design... Current Derby Network server and/or client
> needs to be enhanced to support this. Kathey Marsden may have more info
> on this.
> 
> Would it be possible to use FORWARD_ONLY cursors and issue a direct
> update SQL statement to update the rows? May need a way to uniquely
> identify the row in the base table. Any other ideas for workaround?
> 
> Satheesh
> 
> Veaceslav Chicu wrote:
> 
>>it's difficult to support updatable scrollable cursors?
>>it's by design?
>>
>>
>>thank you,
>>Slavic
>>
>>Q2: Does DB2 UDB V8 support updatable scrollable cursors?
>>
>>A2: Updatable scrollable cursors are supported using the Universal JDBC
>>drivers in DB2 UDB V8.1. If you are using DB2 UDB for Linux, UNIX, and
>>Windows v7.x, then you can use the legacy/CLI drivers and the
>>setCursorName APIs to simulate updatable scrollable cursors. We
>>recommend that you migrate to the Universal JDBC driver.
>>
>>
>>
>>Veaceslav Chicu wrote:
>>  
>>
>>>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