Re: JSP & Oracle

Well we have created a class that manage the connection to the database this is the
myConnect.connect();

In the myConnect.execSQL(sqlActu) function we create a resultset exectly like yours ( Statement s =
some_connection.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);) and the resultset of this SQL Query is returned by the function.

Normaly it has to be a scrollable one. With SQL Server we can move into the resultset with out any problem but not with Oracle. And I don't know if the resultset of SQL Server are scrollable. I think the "scrollability" is a JDBC functionality, and I don't understand anything no more :(((

Thanks for helping me and excuse me for my English errors, I'm just a poor french developper that just use Oracle for the time, and I began it on Monday!

Douglas.

"Matz" <matz_at_ossis.de> a écrit dans le message news: 96u4el$dm8$00$1_at_news.t-online.com...
> "Sybrand Bakker" <oradba_at_sybrandb.demon.nl> wrote
>
> Hmm but scrolling through resultsets works for me (with JDBC2):
>
> /* create a statement explicitly scrollable */
> Statement s =
> some_connection.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
> ResultSet.CONCUR_READ_ONLY);
>
>
> ResultSet rs = s.executeQuery(sqlActu);
>
> now you can do all the scrolling stuff (last(), absolute()...)
>
> Maybe you need the newset ODBC and JDBC drivers from Oracle (don't use the
> Microsoft driver).
>
>
> Matz
>
>
>
>
Received on Wed Feb 21 2001 - 03:28:40 CST