Eclipse Community Forums: EclipseLink » Can I use ClipseLink to work with Object-Relational datatypes(TYPSES, VARRAY, NESTED TABLES..)

Home » Eclipse Projects » EclipseLink » Can I use ClipseLink to work with Object-Relational datatypes(TYPSES, VARRAY, NESTED TABLES..)(Oracle + Eclipse Link + Object-Realational model)

Show: Today's Messages :: Show Polls :: Message Navigator

Can I use ClipseLink to work with Object-Relational datatypes(TYPSES, VARRAY, NESTED TABLES..) [message #997752]

Tue, 08 January 2013 17:08

Abdelmajid LEADER

Messages: 2
Registered: January 2013

Junior Member

Hello,
I have mad some types and typed tables in a schema on oracle 10g.
My database respects the Object Relational model, in which I work with VARRAY, TYPES, NESTED TABLES, PL/SQL,...

I have already install Enterprise Pack for Eclipse, and also have the Weblogic server, And I can generate tables. But the problem is that it gives to me this tables with wrong types, until they contains in fact other tables as Objet column, and also the types are not supported.

Please need a help !

Thank's in advance Smile

Report message to a moderator

Re: Can I use ClipseLink to work with Object-Relational datatypes(TYPSES, VARRAY, NESTED TABLES..) [message #998702 is a reply to message #997752]

Thu, 10 January 2013 14:35

James Sutherland

Messages: 1939
Registered: July 2009
Location: Ottawa, Canada

Senior Member

Object relational data-types are not very commonly used. Most users use the relational model.

You can map object relational data-types in EclipseLink using the @Struct, @Structure, @Array annotations.
DDL generation is not supported for object-relational data-types, you will need to use your own DDL scripts.

http://www.eclipse.org/eclipselink/documentation/2.4/jpa/extensions/a_struct.htm#CBBDCAHG

http://www.eclipse.org/eclipselink/documentation/2.4/jpa/extensions/a_array.htm#CHDDDFDA

James : Wiki : Book : Blog : Twitter

Report message to a moderator