Re: Running Rowsets tests against Derby database

John Kline 20 Dec 2004 22:00:21 -0000

Hi Mamta,

Keep in mind though that Derby at this point does not support scrollable sensitive cursors. Derby has support for forward only resultsets and scroll insensitive resultsets, both in read only mode.

So Derby supports forward only and scroll insensitive resultsets and you are working on only supporting CONCUR_UPDATABLE on forward only result sets. Correct? I think we need to support both. In most cases, one will want CONCUR_UPDATABLE for scrollable resultsets. Do you know of anyone working on this? Does anyone if any work is taking place in this area?

- John

On Dec 20, 2004, at 1:41 PM, Mamta Satoor wrote:

Hi John,

Yes, my patch on the list supports CONCUR_UPDATABLE
for forward only result sets.

I am not currently looking at working on scrollable updatable resultsets. Keep in mind though that Derby at this point does not support scrollable sensitive cursors. Derby has support for forward only resultsets and scroll insensitive resultsets, both in read only mode.

Mamta.

John Kline wrote:

Hi Mamta,

As a first step, you are going to support CONCUR_UPDATABLE for forward
only result sets.  Is that correct?  But will you then continue your
work to support scrollable updatable result sets?  If not, does your
solution just not apply to scrollable result sets?  Please let me know
as I'm going to need to figure out how to implement updatable
scrollable result sets if this isn't already being addressed.

Cheers,
John

On Nov 29, 2004, at 11:55 AM, Mamta Satoor wrote:

Just couple more comments to Satheesh's reply. I have a pending patch
on the
list
to support delete using updatable resultset apis. I am working on
support for
update
using updatable resultset apis next.

Please keep in mind though that this support would be for forward only updatable

resultsets only. I noticed that you are trying to get scroll sensitive updatable resultset. Derby does not currently support scroll sensitive read only resultsets and hence my patch will not have support for scroll sensitive updatable resultset.

Hope this helps,
Mamta

Satheesh Bandaram wrote:

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Derby currently doesn't support Updatable resultSets. I suspect the JdbcRowSetImpl might be invoking the updatable resultSet API of JDBC specification. Hence you might be getting the feature not implemented error.

There are some pending patches to Derby that will get us closer to
Updatable resultsets. Derby might have complete updatable resultset
API
support, hopefully, soon after that.

Satheesh

Ias wrote:

The same thing happens when using embedded mode, but with a
different error
message:

SQL Exception: Feature not implemented: no details.

Ias

-----Original Message-----
From: Ias [mailto:[EMAIL PROTECTED]
Sent: Friday, November 26, 2004 8:41 PM
To: 'Derby Development'
Subject: RE: Running Rowsets tests against Derby database

I met

com.ibm.db2.jcc.c.SqlException: Driver not capable

error from the following code

           String driverName = "com.ibm.db2.jcc.DB2Driver";
           Class.forName(driverName);
           String dbUrl = "jdbc:derby:net://localhost:1527/test";
           String username = "APP";
           String password = "APP";
           con = DriverManager.getConnection(dbUrl, username,
password);
           Statement stmt =
con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.
CONCUR_UPDATAB
LE);
           ResultSet res = stmt.executeQuery("select * from
message_log");
           logRowset = new JdbcRowSetImpl(res);
           logRowset.moveToInsertRow(); <- at this point

Im using Network mode with IBM DB2 Universal Driver (just
downloaded last week).

Is there any solution to this problem?

Thanks,

Ias

P.S. CacheRowset seems to work fine under the same circumstances.

-----Original Message-----
From: Ias [mailto:[EMAIL PROTECTED]
Sent: Saturday, November 20, 2004 6:22 PM
To: 'Derby Development'; [EMAIL PROTECTED]
Subject: RE: Running Rowsets tests against Derby database
Hi all,
I have been following the Derby project on Apache for quite
sometime.
I have experimented using the Derby database with JDBC Rowsets
implementation which is part of JDK 5.0.
I am pleased to infrom that we have run all the RowSets
Implementation
(JSR 114) tests against the Derby database.We have a pass
percentage
of about *88%* which we feel is great number to begin with.
We hope to
make it better as we go ahead using Derby.
I also have used Derby (network-mode) for running examples in JDBC RowSet for JWSDP 1.5 and learned that it worked fine. Now I'm thinking of using Derby with J2SE 5.0 JDBC RowSet


for my web

services gateway implementation.
Probably I'll test Derby with more (realistic) cases :-)
Thanks,
Ias
I am interested in the progress of Derby Project and


would like to

contribute actively going forward.

thanks,

Shreyas Kaushik
Sun Microsystems,Inc.

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.5 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFBq3pwENVNIY6DZ7ERAtXlAJ99oagVMcaOXq6QjML82JJxG48jfQCcD2UQ
/I5/T/R7WcmV3A0+gMq6TGE=
=CLfA
-----END PGP SIGNATURE-----

Re: Running Rowsets tests against Derby database

Reply via email to