Re: [eclipselink-users] Entities spanning multiple databases

[Christopher.Mathrusse@xxxxxxxxxx]

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