Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: JSP & Oracle

Re: JSP & Oracle

From: Douglas SIX <dsix_at_faire-savoir.com>
Date: Wed, 21 Feb 2001 09:28:40 GMT
Message-ID: <cTLk6.710$ij6.2562118@nnrp1.proxad.net>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US