Hi Drew, > This code for instance: ( shortened from the Issue entry ) > ... > will generate an error on the last line because the result set is read only. > ... > But the question is - should the first version be in read only mode or > not - is this a confirmed issue or an invalid one...
First, one important information is which DB type you use - let's assume HSQLDB. Second, the first code should work, in general. It is the more "direct" version, in that it directly works with database-driver-supplied implementations, where the second version works with Base-provided implementations which sometimes are able to compensate shortcomings of the DB driver. Looking into the HSQLDB code, there's a comment in org.hsqldb.jdbcResultSet saying that since HSQLDb 1.7.2, UPDATABLE will always be downgraded to READONLY - though I do not know the reason, I suppose that UPDATABLE result sets are simply not implemented ATM. Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
