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
