+1 Cross model relationships with different db connections is bugged, there's a few threads on the list about this. Even if it wasn't bugged, there's no 2-phases commit, so you can end up with inconsistent data. Anyway (as in your case), you can still fetch objects coming from whatever databases, in the same app, that's powerfull !
Alex 2012/8/24 Amedeo Mantica <[email protected]> > Theoretically table names could be same. You can have table name different > from entity name. Btw there is a bug in wo 5.4.3 that may cause issues in > cross database relationship, but for read only should work with no issues. > > Amedeo > > Sent from my iPhone > > On 23/ago/2012, at 20:28, Tim Worman <[email protected]> wrote: > > > +1 > > > > It just works. You simply can't have entities with the same name. I have > two different databases as well as JNDI entities. > > > > Tim > > UCLA GSE&IS > > > > On Aug 22, 2012, at 9:50 PM, Cheong Hee (Gmail) <[email protected]> > wrote: > > > >> The simplest way is to create two eomodel and set their connection > dictiionary respectively. It will then transparent to you when do fetching. > >> No worry b'cos it is wo. > >> > >> ----- Original Message ----- From: "Theodore Petrosky" < > [email protected]> > >> To: <[email protected]> > >> Cc: <[email protected]> > >> Sent: Thursday, August 23, 2012 9:55 AM > >> Subject: Re: creating a second database connection > >> > >> > >>> I hadn't even thought of JasperReports yet. but, I could probably > create a 'special EO', copy the attributes that I want to report on. and > print this third EO. > >>> > >>> or as you said pass the second EO as a parameter object and use a sub > report. i was doing that for my to-many relations. > >>> > >>> My issue was I couldn't image how to connect to two different > databases at the same time. It appears this is the easier of the difficult > parts. > >>> > >>> > >>> Ted > >>> > >>> --- On Wed, 8/22/12, [email protected] <[email protected]> wrote: > >>> > >>>> From: [email protected] <[email protected]> > >>>> Subject: Re: creating a second database connection > >>>> To: "Theodore Petrosky" <[email protected]> > >>>> Cc: "Amedeo Mantica" <[email protected]>, "Paul Yu" <[email protected]>, > "[email protected]" <[email protected]> > >>>> Date: Wednesday, August 22, 2012, 7:21 PM > >>>> Jasper Reports? You can't use two > >>>> data sources in the same report, you will have to use > >>>> sub-reports. > >>>> > >>>> Envoyé de mon iPhone > >>>> > >>>> Le 2012-08-22 à 19:19, "Theodore Petrosky" <[email protected]> > >>>> a écrit : > >>>> > >>>>> db two is to read only. I want to munge together a > >>>> report. I'll try the two models and see how it works out. it > >>>> just sounds too simple. > >>>>> > >>>>> Ted > >>>>> > >>>>> > >>>>> --- On Wed, 8/22/12, Paul Yu <[email protected]> > >>>> wrote: > >>>>> > >>>>>> From: Paul Yu <[email protected]> > >>>>>> Subject: Re: creating a second database connection > >>>>>> To: "Amedeo Mantica" <[email protected]> > >>>>>> Cc: "[email protected]" > >>>> <[email protected]> > >>>>>> Date: Wednesday, August 22, 2012, 6:28 PM > >>>>>> But cross model joins would be an > >>>>>> issue? > >>>>>> > >>>>>> Sent from my iPad > >>>>>> > >>>>>> On Aug 22, 2012, at 4:09 PM, Amedeo Mantica <[email protected]> > >>>>>> wrote: > >>>>>> > >>>>>>> Just create two eomodels > >>>>>>> > >>>>>>> Sent from my iPhone > >>>>>>> > >>>>>>> On 22/ago/2012, at 21:55, Theodore Petrosky > >>>> <[email protected]> > >>>>>> wrote: > >>>>>>> > >>>>>>>> I have an app that captures data on events > >>>> and > >>>>>> writes this to my postgresql database. > >>>>>>>> > >>>>>>>> I have other data that lives in an Oracle > >>>> database > >>>>>> that I need to query to merge with to create a > >>>> report. > >>>>>>>> > >>>>>>>> like (data from PG) + (data from Oracle) = > >>>>>> myReport. > >>>>>>>> > >>>>>>>> I have no experience trying to connect to a > >>>> second > >>>>>> database in an app. Are there any examples of doing > >>>> this? > >>>>>>>> > >>>>>>>> Please, I have no idea where to start. > >>>>>>>> > >>>>>>>> Ted > >>>> _______________________________________________ > >>>>>>>> Do not post admin requests to the list. > >>>> They will > >>>>>> be ignored. > >>>>>>>> Webobjects-dev mailing list > >>>> ([email protected]) > >>>>>>>> Help/Unsubscribe/Update your Subscription: > >>>>>>>> > https://lists.apple.com/mailman/options/webobjects-dev/amedeomantica%40me.com > >>>>>>>> > >>>>>>>> This email sent to [email protected] > >>>> _______________________________________________ > >>>>>>> Do not post admin requests to the list. They > >>>> will be > >>>>>> ignored. > >>>>>>> Webobjects-dev mailing list > >>>> ([email protected]) > >>>>>>> Help/Unsubscribe/Update your Subscription: > >>>>>>> > https://lists.apple.com/mailman/options/webobjects-dev/pyu%40mac.com > >>>>>>> > >>>>>>> This email sent to [email protected] > >>>>>> _______________________________________________ > >>>>>> Do not post admin requests to the list. They will > >>>> be > >>>>>> ignored. > >>>>>> Webobjects-dev mailing list ([email protected]) > >>>>>> Help/Unsubscribe/Update your Subscription: > >>>>>> > https://lists.apple.com/mailman/options/webobjects-dev/tedpet5%40yahoo.com > >>>>>> > >>>>>> This email sent to [email protected] > >>>>> > >>>>> _______________________________________________ > >>>>> Do not post admin requests to the list. They will be > >>>> ignored. > >>>>> Webobjects-dev mailing list ([email protected]) > >>>>> Help/Unsubscribe/Update your Subscription: > >>>>> > https://lists.apple.com/mailman/options/webobjects-dev/probert%40macti.ca > >>>>> > >>>>> This email sent to [email protected] > >>> > >>> _______________________________________________ > >>> Do not post admin requests to the list. They will be ignored. > >>> Webobjects-dev mailing list ([email protected]) > >>> Help/Unsubscribe/Update your Subscription: > >>> > https://lists.apple.com/mailman/options/webobjects-dev/chng34%40gmail.com > >>> > >>> This email sent to [email protected] > >> > >> _______________________________________________ > >> Do not post admin requests to the list. They will be ignored. > >> Webobjects-dev mailing list ([email protected]) > >> Help/Unsubscribe/Update your Subscription: > >> > https://lists.apple.com/mailman/options/webobjects-dev/lists%40thetimmy.com > >> > >> This email sent to [email protected] > > > > > > _______________________________________________ > > Do not post admin requests to the list. They will be ignored. > > Webobjects-dev mailing list ([email protected]) > > Help/Unsubscribe/Update your Subscription: > > > https://lists.apple.com/mailman/options/webobjects-dev/amedeomantica%40me.com > > > > This email sent to [email protected] > > _______________________________________________ > Do not post admin requests to the list. They will be ignored. > Webobjects-dev mailing list ([email protected]) > Help/Unsubscribe/Update your Subscription: > > https://lists.apple.com/mailman/options/webobjects-dev/alexis.tual%40gmail.com > > This email sent to [email protected] >
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
