RE: Passing Multiple Records

From: Lord David <dlord_at_haysits.co.uk>
Date: Wed, 17 Jan 2001 09:36:55 -0000
Message-Id: <10744.126862@fatcity.com>

Our developers are doing a similar thing, so I did a bit of investigation a while back to find out whether its possible. However, I haven't used it in anger, so there could well be hidden pitfalls.

There are a couple of ways of passing collections and objects through jdbc: -

Use the oracle.sql.STRUCT class. This is a bit basic, but is not too hard to program manually.
Create custom classes using the CustomDatum and CustomDatumFactory interfaces. This is only really feasible if you use the JPublisher bit of JDeveloper to automatically generate the class, but its a breeze when you do - you simply select the oracle package or object you want and it creates the java to access them.

Both methods are documented (badly) in the 'JDBC Developer's guide' and 'JPublisher User's Guide'.

Regards
David Lord
Senior DBA, Hays Commercial Services, IT Solutions

-----Original Message-----
From: Mathura Dev [mailto:dmathura2000_at_yahoo.com] Sent: 16 January 2001 17:11
To: Multiple recipients of list ORACLE-L Subject: Passing Multiple Records

Listers,

We recently started converting a client's mainframe system to a web-based system using JSP (Java Server Pages) technology. We use JDBC drivers to connect to an Oracle8i database. The developers want to use stored procedures to handle inserts/updates.

My exposure to the java environment is practically nil. I'm thinking of creating stored procedures which would use static SQL statements to perform the DML operations. While this would handle single record screens I'm stumped on how to handle multi-record screens as we want to pass these records one screenful
(between 10 and 15 records) at a time for
manipulation.
I'm open to any suggestions.

Also, is it practical to have these DML statements as stored procedures or would it be better to have the developers code them directly in the pages.

Your thoughts are comments are welcomed.

Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mathura Dev
  INET: dmathura2000_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

Received on Wed Jan 17 2001 - 03:36:55 CST