Re: [eclipselink-users] Entities spanning multiple databases

[Christopher.Mathrusse@xxxxxxxxxx]

I just created a test project and verified
using @Table( catalog="customer" schema="dbo", table="customers")
does indeed generate the desired SQL. 

customer.dbo.customers

Thanks for the help. This appears to
have resolved my problem.

Chris Mathrusse
christopher.mathrusse@xxxxxxxxxx
Sybase, Inc
One Sybase Drive
Dublin, CA 94568
(925) 236-5553

From:	<Christopher.Mathrusse@xxxxxxxxxx>
To:	EclipseLink User Discussions <eclipselink-users@xxxxxxxxxxx>
Cc:	eclipselink-users-bounces@xxxxxxxxxxx
Date:	12/15/2009 04:15 PM
Subject:	Re: [eclipselink-users] Entities spanning multiple databases
Sent by:	<eclipselink-users-bounces@xxxxxxxxxxx>

---

So if I were to give the catalog, schema
and table name to the @Table annotation, how would the generated SQL look?

Chris Mathrusse
christopher.mathrusse@xxxxxxxxxx
Sybase, Inc
One Sybase Drive
Dublin, CA 94568
(925) 236-5553

From:	Tim Hollosy <hollosyt@xxxxxxxxx>
To:	EclipseLink User Discussions <eclipselink-users@xxxxxxxxxxx>
Date:	12/15/2009 03:46 PM
Subject:	Re: [eclipselink-users] Entities spanning multiple databases
Sent by:	<eclipselink-users-bounces@xxxxxxxxxxx>

---

Ah, alright I'm not familiar with ASE, perhaps the catalog attribute on
the @Table annotation is what you're looking for?

./tch


On Tue, Dec 15, 2009 at 6:32 PM, <Christopher.Mathrusse@xxxxxxxxxx>
wrote: 
Then where would I specify the database name? With ASE, the syntax is <database>.<schema>.<table>,
and if I specify customer..customers, it translates to customer.dbo.customers.
(dbo is assumed when unspecified) So I'm still left with a need to specify
the database name. 

Chris Mathrusse
christopher.mathrusse@xxxxxxxxxx
Sybase, Inc 
One Sybase Drive
Dublin, CA 94568
(925) 236-5553

From:	Tim Hollosy <hollosyt@xxxxxxxxx>
To:	EclipseLink User Discussions <eclipselink-users@xxxxxxxxxxx>
Date:	12/15/2009 02:41 PM
Subject:	Re: [eclipselink-users] Entities spanning multiple databases
Sent by:	<eclipselink-users-bounces@xxxxxxxxxxx>

---

would the @Table(name="customer",schema="customer")
work for you?

./tch



On Tue, Dec 15, 2009 at 4:06 PM,  <Christopher.Mathrusse@xxxxxxxxxx>
wrote:
> I'm using EclipseLink and working with a legacy Sybase ASE database.
The
> model is terrible and spans over multiple databases (but on the same
> server). Is it possible to have EclipseLink access tables residing
in other
> databases? I was thinking of something like
>
> @Table(name="customer..customers")
>
> I currently have an existing application using iBatis and this is
how I can
> retrieve objects from multiple tables residing in different databases
(but
> on the same server). I'm reasonably certain that this would work with
> EclipseLink but I was just wondering if anyone had tried and if there
is a
> cleaner way of accomplishing this.
>
> Thanks for the help..
>
> Chris Mathrusse
> christopher.mathrusse@xxxxxxxxxx
> Sybase, Inc
>
> _______________________________________________
> eclipselink-users mailing list
> eclipselink-users@xxxxxxxxxxx
> https://dev.eclipse.org/mailman/listinfo/eclipselink-users
>
>
_______________________________________________
eclipselink-users mailing list
eclipselink-users@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/eclipselink-users




_______________________________________________
eclipselink-users mailing list
eclipselink-users@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/eclipselink-users

_______________________________________________
eclipselink-users mailing list
eclipselink-users@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/eclipselink-users

_______________________________________________
eclipselink-users mailing list
eclipselink-users@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/eclipselink-users