Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Modeling » EMF "Technology" (Ecore Tools, EMFatic, etc)  » teneo: same name problem using jpox
teneo: same name problem using jpox [message #114009] Thu, 06 March 2008 21:12 Go to next message
Julia is currently offline JuliaFriend
Messages: 85
Registered: July 2009
Member
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 21:52 Go to previous message
Martin Taal is currently offline Martin TaalFriend
Messages: 5468
Registered: July 2009
Senior Member
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 21:52 Go to previous message
Martin Taal is currently offline Martin TaalFriend
Messages: 5468
Registered: July 2009
Senior Member
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
Previous Topic:teneo: same name problem using jpox
Next Topic:Loading a GMF diagram resource from Hibernate
Goto Forum:
  


Current Time: Sun Jun 20 06:38:14 GMT 2021

Powered by FUDForum. Page generated in 0.01985 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top