In my use, I build the cross-database relationship logic manually rather than actually modeling it.
Tim On Aug 23, 2012, at 11:52 AM, Amedeo Mantica <[email protected]> wrote: > 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/archive%40mail-archive.com This email sent to [email protected]
