I have configured iSQL- Viewer and tried to connected to derby from it.I created a schem,table and inserted values into it...but when i run a simple select query i get the following error (on the console in iSQL).
[15:51:12] Exception Occured While Retrieving Query Results [15:51:12] Runtime Exception::(com.ibm.db2.jcc.c.SqlException: This method should only be called on ResultSet objects that are scrollable(type TYPE_SCROLL_SENSITIVE or TYPE_SCROLL_INSENSITIVE)) On reading around on the manual i came across the following in the reference manual for java.sql.Connection under section Table 15. JDBC 2.0 Connection Methods Supported Returns : Statement Signature : createStatement( int resultSetType, int resultSetConcurrency) Implementation Notes : ResultSet.TYPE_FORWARD_ONLY and ResultSet.TYPE_SCROLL_INSENSITIVE are the only scrolling types supported. If you request TYPE_SCROLL_SENSITIVE, Derby issues an SQLWarning and returns a TYPE_SCROLL_INSENSITIVE ResultSet. Any work-around for this??? Please help Thanks, Amit
