db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mamta Satoor <ma...@Remulak.Net>
Subject Re: rowset.last() unimplemented by Derby?
Date Wed, 03 Nov 2004 02:50:02 GMT
Derby does support read only scroll insensitive cursors but it does not support
updatable
scroll insensitive cursors. Make your rowset read only and then try using the last
method.

Mamta

Ken Yee wrote:

> I'm tring to run Derby with:
> http://swingset.sourceforge.net
> (I'm using 0.9.2)
>
> and get this error:
> JdbcRowSet (setTypeMap): Feature not implemented: no
> details.
> SQL Exception: The 'last()' method is only allowed on
> scroll cursors.
> at
> org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java)
>
> at
> org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java)
>
> at
> org.apache.derby.impl.jdbc.EmbedResultSet20.checkScrollCursor(EmbedResultSet20.java)
>
> at
> org.apache.derby.impl.jdbc.EmbedResultSet20.last(EmbedResultSet20.java)
>
> at
> com.sun.rowset.JdbcRowSetImpl.last(JdbcRowSetImpl.java:1664)
>
> at
> com.nqadmin.swingSet.datasources.SSJdbcRowSetImpl.last(SSJdbcRowSetImpl.java:656)
>
> at
> com.nqadmin.swingSet.SSTableModel.init(SSTableModel.java:157)
>
> at
> com.nqadmin.swingSet.SSTableModel.setRowSet(SSTableModel.java:128)
>
> at
> com.nqadmin.swingSet.SSDataGrid.init(SSDataGrid.java:322)
>
> at
> com.nqadmin.swingSet.SSDataGrid.setRowSet(SSDataGrid.java:427)
>
> but the rowset should be scrollable because it was
> created with:
>                         rowset = new
> JdbcRowSetImpl(ssConnection.getConnection());
>                         rowset.setType(ResultSet.TYPE_SCROLL_INSENSITIVE);
>                         rowset.setConcurrency(ResultSet.CONCUR_UPDATABLE);
>                         rowset.setCommand(query);
>
> Does Derby not support the last() method?
>
>  ken
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com


Mime
View raw message