My guess is that the Statement object is getting created with default resultset TYPE_FORWARD_ONLY. Is there a way to configure the client to create the Statement with TYPE_SCROLL_INSENSITIVE?
Mamta Amit Rao wrote: > 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
