Lists

Open Menu Close Menu

Terms and Conditions
Lists hosted on this site
Email the Postmaster
Tips for posting to public mailing lists

sql for qualifier that spans two databases

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

sql for qualifier that spans two databases

Subject: sql for qualifier that spans two databases
From: Travis Britt <email@hidden>
Date: Wed, 18 Jul 2007 10:54:25 -0400

Hoping someone can quickly tell me if this should be possible without writing my own SQL.

Two databases.
Two EOModels, one for each database.

A to-one relationship from an entity in one model to an entity in the other.

An EOQualifier is built from a search form that includes attributes on both entities (each in different models.) The destination key path is entered as "relationshipName.attributeName."

The SQL generated for the qualifier references both tables as if they were in the same DB (this is Oracle 9i using OraclePlugin, WO 5.3.)

Which blows up since of course the tables aren't in the same view/DB.

Thanks!

tb

_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden


Follow-Ups:

Re: sql for qualifier that spans two databases
From: Art Isbell <email@hidden>
Re: sql for qualifier that spans two databases
From: "Tonny Staunsbrink" <email@hidden>


Prev by Date:
Re: [OT] developing for the iPhone

Next by Date:
[OT] Which DB server does the iTunes Store use?

Previous by thread:
Re: janine's tutorial

Next by thread:
Re: sql for qualifier that spans two databases

Index(es):

Date
Thread