Oracle database supports only forward cursor. Random access implemented by jdbc driver by caching records in memory. Not a nice solution for dumping the whole database as xml file.
Ilia -----Original Message----- From: Daniel Rall [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 01, 2001 9:00 PM To: Turbine Users List Subject: Re: TorqueDataDumpTask problem Is there any way to open the result set with a different type of cursor than forward only? You need a "random access" cursor. "Ilia Iourovitski" <[EMAIL PROTECTED]> writes: > Looks like Oracle resultset implementation doesn't like isLast() > > public boolean TableTool::hasNext() > { > try > { > return !(rs.isLast() || this.isEmpty); > } > catch (SQLException se) > { > System.err.println("SQLException :"); > se.printStackTrace(); > } > return false; > } > >> fetching table FOO_TBLSQLException : >> java.sql.SQLException: Invalid operation for forward only resultset : >> isLast >> at >> oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168) >> at >> oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:210) >> at >> > oracle.jdbc.driver.OracleResultSetImpl.isLast(OracleResultSetImpl.java:2 > > 88) >> at >> > org.apache.torque.task.TorqueDataDumpTask$TableTool.hasNext(TorqueDataDu > > mpTask.java:381) -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
