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.
> >
> >
>
