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