+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/archive%40mail-archive.com This email sent to [email protected]
