Any advanced CMP mapping for int[] via java.sql.Array to a VARRAY col type?

2002-05-19 Thread Andy Parkman

Can anyone point me in the direction of some more detailed information on
advanced CMP mapping techniques?

I was wondering if a CMP mapping can be found which would generate JDBC code
to bind a field variable defined as an array of integer via a java.sql.Array
type to a database column defined as a varray of number under Oracle?

I have been experimenting a little in and around this area but am not
finding
much on this in the Orion documentation and am having difficulty applying
what I can find to my needs. My searches on the mailing list archives also
don't find anything on java.sql.Array or much relevant traffic on other
terms
such as 'persistence-type'.

Is there an API which allows users to provide enhancements to the facilities
provided by the current CMP implementation? If so am I missing some more
detailed documentation or useful examples on this?

Regards,
Andy Parkman







RE: Any advanced CMP mapping for int[] via java.sql.Array to a VARRAY col type?

2002-05-19 Thread Juan Pablo Lorandi

I think there's a PersistanceManager interface for this, but I remember
it not being configurable from files, that is, it seems it's not fully
implemented yet. I guess you'll have to resort to BMP for such complex
mappings.

My 2c,

Juan Pablo Lorandi
Chief Software Architect
Code Foundry Ltd.
[EMAIL PROTECTED]

Barberstown, Straffan, Co. Kildare, Ireland.
Tel: +353-1-6012050  Fax: +353-1-6012051
Mobile: +353-86-2157900
www.codefoundry.com


 -Original Message-
 From: [EMAIL PROTECTED] 
 [mailto:[EMAIL PROTECTED]] On Behalf Of 
 Andy Parkman
 Sent: Sunday, May 19, 2002 6:36 PM
 To: Orion-Interest
 Subject: Any advanced CMP mapping for int[] via 
 java.sql.Array to a VARRAY col type?
 
 
 Can anyone point me in the direction of some more detailed 
 information on advanced CMP mapping techniques?
 
 I was wondering if a CMP mapping can be found which would 
 generate JDBC code to bind a field variable defined as an 
 array of integer via a java.sql.Array type to a database 
 column defined as a varray of number under Oracle?
 
 I have been experimenting a little in and around this area 
 but am not finding much on this in the Orion documentation 
 and am having difficulty applying what I can find to my 
 needs. My searches on the mailing list archives also don't 
 find anything on java.sql.Array or much relevant traffic on 
 other terms such as 'persistence-type'.
 
 Is there an API which allows users to provide enhancements to 
 the facilities provided by the current CMP implementation? If 
 so am I missing some more detailed documentation or useful 
 examples on this?
 
 Regards,
 Andy Parkman