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" <tedp...@yahoo.com>
To: <prob...@macti.ca>
Cc: <webobjects-dev@lists.apple.com>
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, prob...@macti.ca <prob...@macti.ca> wrote:
From: prob...@macti.ca <prob...@macti.ca>
Subject: Re: creating a second database connection
To: "Theodore Petrosky" <tedp...@yahoo.com>
Cc: "Amedeo Mantica" <amedeomant...@me.com>, "Paul Yu" <p...@mac.com>,
"webobjects-dev@lists.apple.com" <webobjects-dev@lists.apple.com>
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" <tedp...@yahoo.com>
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 <p...@mac.com>
wrote:
>
>> From: Paul Yu <p...@mac.com>
>> Subject: Re: creating a second database connection
>> To: "Amedeo Mantica" <amedeomant...@me.com>
>> Cc: "webobjects-dev@lists.apple.com"
<webobjects-dev@lists.apple.com>
>> 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 <amedeomant...@me.com>
>> wrote:
>>
>>> Just create two eomodels
>>>
>>> Sent from my iPhone
>>>
>>> On 22/ago/2012, at 21:55, Theodore Petrosky
<tedp...@yahoo.com>
>> 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
(Webobjects-dev@lists.apple.com)
>>>> Help/Unsubscribe/Update your Subscription:
>>>>
https://lists.apple.com/mailman/options/webobjects-dev/amedeomantica%40me.com
>>>>
>>>> This email sent to amedeomant...@me.com
>>>
_______________________________________________
>>> Do not post admin requests to the list. They
will be
>> ignored.
>>> Webobjects-dev mailing list
(Webobjects-dev@lists.apple.com)
>>> Help/Unsubscribe/Update your Subscription:
>>> https://lists.apple.com/mailman/options/webobjects-dev/pyu%40mac.com
>>>
>>> This email sent to p...@mac.com
>> _______________________________________________
>> Do not post admin requests to the list. They will
be
>> ignored.
>> Webobjects-dev mailing list (Webobjects-dev@lists.apple.com)
>> Help/Unsubscribe/Update your Subscription:
>> https://lists.apple.com/mailman/options/webobjects-dev/tedpet5%40yahoo.com
>>
>> This email sent to tedp...@yahoo.com
>>
>
> _______________________________________________
> Do not post admin requests to the list. They will be
ignored.
> Webobjects-dev mailing list (Webobjects-dev@lists.apple.com)
> Help/Unsubscribe/Update your Subscription:
> https://lists.apple.com/mailman/options/webobjects-dev/probert%40macti.ca
>
> This email sent to prob...@macti.ca
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
https://lists.apple.com/mailman/options/webobjects-dev/chng34%40gmail.com
This email sent to chn...@gmail.com
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to arch...@mail-archive.com
