Hibernate Community • View topic - Mapping of nested table created using OracleTypeCOLLECTION

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Mapping of nested table created using OracleTypeCOLLECTION

Page 1 of 1

[ 3 posts ]

Previous topic | Next topic

Author

Message

rahulp21

Post subject: Mapping of nested table created using OracleTypeCOLLECTION

Posted: Wed Nov 10, 2010 5:39 pm

Newbie

Joined: Wed Nov 10, 2010 5:28 pm
Posts: 2

I need to map a nested table in Oracle. Following are the details.

Table
==============
CREATE TABLE "ODSPROPERTY_OWNER"."PIM_TEST"
(
"PIM_ID" NUMBER,
"PIM_HOLES" "ODSPROPERTY_OWNER"."TYP_STRING" ,
"PIM_TEST_ID" NUMBER,
CONSTRAINT "PIM_TEST_ID_PK" PRIMARY KEY ("PIM_TEST_ID")
)

Oracle collection type
=================
create or replace
TYPE typ_string AS TABLE OF VARCHAR2(4000);

Thanks.

Top

eritne

Post subject: Re: Mapping of nested table created using OracleTypeCOLLECTION

Posted: Tue Feb 01, 2011 8:35 am

Newbie

Joined: Mon Jan 31, 2011 4:01 pm
Posts: 2

did you find a solution to this, appreciate it if you can share the solution, i am also looking to do the same

Top

rahulp21

Post subject: Re: Mapping of nested table created using OracleTypeCOLLECTION

Posted: Fri May 20, 2011 2:49 pm

Newbie

Joined: Wed Nov 10, 2010 5:28 pm
Posts: 2

Got nothing. We dropped the idea of using nested tables. Oracle toplink provides an option to do that. Here's the link http://download.oracle.com/docs/cd/B104 ... tm#1033517

Top

Page 1 of 1

[ 3 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum