Re: [JDBC] StoredProcedure cursor returned is not TYPE_SCROLL_INSENSITIVE

I don't believe the 9i JDBC drivers fully support scrollable result sets. At some point they added some scrolling capability (9.X?) but I believe it was initially on the client side only, so would likely be a performance hog if used.

--Peter

hikemike_at_gmail.com wrote:
> I have seen the problem reported in various news groups going back to
> 1999 (Deja.News). Does anyone know if it's been fixed yet. There
> appears to be no solution on the web.
>
> I call a simple stored procedure from a java program and use the
> following line:
>
> protected static final String GET_ACCOUNTS_PROC = "{call
> ACCOUNT.GET_ACCOUNTS_PROC_ALL(?,?)}";
>
> cs = connection.prepareCall(GET_ACCOUNTS_PROC,
> ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
>
> cs.execute();
> rset = (ResultSet) cs.getObject(2);
> rset.first();
>
> throws a SQL Exception:
>
> Invalid operation for forward only resultset : first
>
> Ridiculous that I can't do this. Someone please tell me I'm wrong.
>
> oracle 9 driver: ojdbc14.jar --> jdbc:oracle:thin driver
>
Received on Mon Feb 20 2006 - 12:33:59 CST