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 12: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 09:35

James Sutherland
Messages: 1844
Registered: July 2009

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

Report message to a moderator

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

Thu, 10 January 2013 12:30

Abdelmajid LEADER
Messages: 2
Registered: January 2013

Junior Member

Thank you very much, do you know even any other alternative just to execute PLSQL Scripts, and queries using simple statements with java

Report message to a moderator

Previous Topic:	java.lang.ArrayIndexOutOfBoundsException: -1
Next Topic:	eclipselink 2.4 TABLE_PER_TENANT shared EMF

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 23 01:02:36 EDT 2013