Oracle database object type import in JPA

Question

Is there a way to import oracle defined object type in JPA. I have a complex object defined in database :

create or replace TYPE "myType"{
someString varchar2(100),
someString2 varchar2(100),
constructor....}

this object type is than used in a database table.

Does this answer your question? JPA mapping to Oracle user defined types — dani herrera
– dani herrera, Commented Aug 22, 2021 at 15:52

James · Accepted Answer · 2013-01-30 14:30:31Z

1

There is no standard support for object-types in JPA.

If you are using EclipseLink, you can use the @Struct annotation to map object-types,

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

If you are mapped a table of the type, and the type has no nested types, then it will just look like a normal relational table, and you can just map in like a normal relational table.

answered Jan 30, 2013 at 14:30

James

18.5k13 gold badges100 silver badges154 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Oracle database object type import in JPA

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related