| teneo: same name problem using jpox [message #114009] |
Thu, 06 March 2008 16:12  |
Eclipse User |
|
|
|
Hi Martin,
I have 2 schemas (A & B) that collide with same name for several of its
table creations. Currently using DB2 and jdk 1.4.
There appears the be several way that I can fix this problem
1) create a separate database schema for each so that the tables can exist
along side each other in the same database. But would I have to create a
separate jpoxdatastore (separate epackage & pmf) object for each schema?
2) use @Entity annotation. But I seem to recall that I will need jdk 1.5
for this. Upgrading will cause other problems.
3) Use QualifyingEntityNameStrategy extensions to add prefix. One of my
collegues tried this method but still had issues due to the complexities
of our schemas and DB2 column limitations.
What would be your best suggestion?
Julia
|
|
|
| Re: teneo: same name problem using jpox [message #114021 is a reply to message #114009] |
Thu, 06 March 2008 16:52  |
| Eclipse User |
|
|
|
Hi Julia,
See my answers inline.
gr. Martin
Julia wrote:
> Hi Martin,
>
> I have 2 schemas (A & B) that collide with same name for several of its
> table creations. Currently using DB2 and jdk 1.4.
>
> There appears the be several way that I can fix this problem
>
> 1) create a separate database schema for each so that the tables can
> exist along side each other in the same database. But would I have to
> create a separate jpoxdatastore (separate epackage & pmf) object for
> each schema?
MT>> If you choose this solution then you would need to create a separate jpoxdatastore for each.
However if the epackages refer to eachother then this won't work.
>
> 2) use @Entity annotation. But I seem to recall that I will need jdk 1.5
> for this. Upgrading will cause other problems.
MT>> The @Entity is also supported in Teneo 0.7.5. You can also use the @Table annotation.
>
> 3) Use QualifyingEntityNameStrategy extensions to add prefix. One of my
> collegues tried this method but still had issues due to the complexities
> of our schemas and DB2 column limitations.
MT>> Normally this should solve any name clashes (assuming that the epackage prefix is unique. Just
let me know what issues you encounter.
> What would be your best suggestion?
>
> Julia
>
--
With Regards, Martin Taal
Springsite/Elver.org
Office: Hardwareweg 4, 3821 BV Amersfoort
Postal: Nassaulaan 7, 3941 EC Doorn
The Netherlands
Tel: +31 (0)84 420 2397
Fax: +31 (0)84 225 9307
Mail: mtaal@springsite.com - mtaal@elver.org
Web: www.springsite.com - www.elver.org
|
|
|
| Re: teneo: same name problem using jpox [message #615619 is a reply to message #114009] |
Thu, 06 March 2008 16:52 |
| Eclipse User |
|
|
|
Hi Julia,
See my answers inline.
gr. Martin
Julia wrote:
> Hi Martin,
>
> I have 2 schemas (A & B) that collide with same name for several of its
> table creations. Currently using DB2 and jdk 1.4.
>
> There appears the be several way that I can fix this problem
>
> 1) create a separate database schema for each so that the tables can
> exist along side each other in the same database. But would I have to
> create a separate jpoxdatastore (separate epackage & pmf) object for
> each schema?
MT>> If you choose this solution then you would need to create a separate jpoxdatastore for each.
However if the epackages refer to eachother then this won't work.
>
> 2) use @Entity annotation. But I seem to recall that I will need jdk 1.5
> for this. Upgrading will cause other problems.
MT>> The @Entity is also supported in Teneo 0.7.5. You can also use the @Table annotation.
>
> 3) Use QualifyingEntityNameStrategy extensions to add prefix. One of my
> collegues tried this method but still had issues due to the complexities
> of our schemas and DB2 column limitations.
MT>> Normally this should solve any name clashes (assuming that the epackage prefix is unique. Just
let me know what issues you encounter.
> What would be your best suggestion?
>
> Julia
>
--
With Regards, Martin Taal
Springsite/Elver.org
Office: Hardwareweg 4, 3821 BV Amersfoort
Postal: Nassaulaan 7, 3941 EC Doorn
The Netherlands
Tel: +31 (0)84 420 2397
Fax: +31 (0)84 225 9307
Mail: mtaal@springsite.com - mtaal@elver.org
Web: www.springsite.com - www.elver.org
|
|
|
Powered by
FUDForum. Page generated in 0.03016 seconds
Home