Re: WAS / Java / Cursors

This sounds a little mercenary, but check out our book titled "The Developer's Guide to Oracle Web Application Server 3", by Dennis Harvey and Steve Beitler, Addison Wesley, 1998.
You'll find it on amazon.

We have two complete advanced chapters on the Java cartridge which includes a complete HelpDesk application. JDBC includes the concept of a cursor using java.sql.Statement and java.sql.PreparedStatement.

Hope it helps,

Dennis Harvey
harvey_at_newpath.com

Sam Jordan wrote in message <36C7E038.8800A5C_at_spin.ch>...
>Hi
>
>I'm using Web application server 3.0.1 to access an Oracle 8 db
>(for Linux). Now I'd like to write programs in Java, which are
>started through the Java cartridge and which should access the db.
>
>Problem: all sample programs seem to evaluate the number of rows
>first (select count(*)) before reading the data, to be able to
>provide arrays with sufficient size, and this seems to be inefficient.
>Is there no way to use a cursor concept in Java? Note, that I don't
>like to communicate between Java programs and PLSQL programs, since
>this would have to be done through ICX, which requires to use the
>Java native interface (JNI seems to be quite unusable in jdk 1.0.2).
>Therefore my preferred way to access Oracle data from Java is to
>call stored procedures, as done in the sample programs found in the
>WAS distribution.
>
>Has anyone made experiences with the Java cartridge by accessing
>an Oracle DB? Some general hints about methods and strategies are
>very welcome.
>
>bye
>--
>Sam Jordan
Received on Wed Feb 17 1999 - 01:35:31 CST