I think you're right.. I just need an example to look at on how to
use the ROWID operator with JDBC.
> -----Original Message-----
> From: Neal Kaiser [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, March 26, 1999 1:31 PM
> To: [EMAIL PROTECTED]
> Subject: Re: Cursors in JDBC
>
> Maybe I misunderstand your problem, but can't you just use Oracle's ROWID
> operator?
>
> At 11:59 AM 3/26/99 -0600, you wrote:
> >At 11:47 AM 3/26/99 -0500, you wrote:
> >>Hi
> >>Does anyone have a example of using cursors with JDBC.
> >>The issue we are trying to solve is using a servlet to display only
> >>10 rows at a time to the user from a table that may contain a million
> >>records.
> >>The table is in an oracle database.
> >>The oracle driver apis have not been very helpful.
> >>Any information will be greatly appreciated
> >>
> >
> >Beena,
> >
> >This is not an easy problem to solve, especially with Oracle. Oracle does
> >not have the concept of scrolling cursors. Also, JDBC does not have
> >scrolling cursors due to the fact that very few RDBMS products support
> >them. There are several approaches. The brute force method is to open a
> >cursor on the entire table with an order by clause on the primary key.
> Then
> >fetch the first ten records and save the last key value. Then close the
> >cursor. When the next page is asked for submit a query that asks for the
> >data that is greater than the last saved key. Repeat for paging. The
> >problem with this approach is that each cursor that you open will create
> an
> >image of the complete query. This has too much overhead with a million
> >records. It can also be slow.
> >
> >Another approach works if your table is very static. You can make another
> >table based on your main table that only contains a sequence number and
> the
> >primary key of the main table. You then query the data asking for records
> >1-10. The next page gets records 11-20 and so forth. This works great if
> >your table doesn't change very often, like every night. You then just
> have
> >to rebuild the lookup table. If your table changes all the time in a
> >transaction environment this won't work.
> >
> >The approach that I'm using is to use the Oracle ConText cartridge. This
> >wonderful add-on to Oracle allows me to perform many useful functions
> that
> >are very dificult to do with just plain Oracle. Some of those are very
> low
> >overhead query hit counts, the ability to do next/previous sections of a
> >query result set, intelligent queries on the text content within large
> text
> >fields, thesaurus expansion of keyword searching, to name just a few. The
> >major drawbacks of the ConText cartridge is that you have to pay extra
> for
> >it and in order to use it you MUST go to Oracle training for it. There
> just
> >isn't any good documentation on ConText. I have been to the training
> >recently and it is of high quality.
> >
> >-Eric
> >
> >_________________________________________________________________________
> __
> >To unsubscribe, send email to [EMAIL PROTECTED] and include in the
> body
> >of the message "signoff SERVLET-INTEREST".
> >
> >Archives: http://archives.java.sun.com/archives/servlet-interest.html
> >Resources: http://java.sun.com/products/servlet/external-resources.html
> >LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
> >
> >
>
> __________________________________________________________________________
> _
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the
> body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources: http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
