Hi,
at least in Oracle it should be possible if you
1) qualify the table name with the schema name, e.g. "b.individu"
2) allow the user of the separate schemes to select the tables from the
other schemes.
If you have static (not changing) models, you can achieve the first by
adding the scheme names to the table names in your EOModel. WO will then
use the full qualified table names to build the fetch specification. For
the second you have to extend your initial SQL-generation script.
HTH,
Susanne
Message: 3
Date: Tue, 10 May 2011 10:36:49 -0700
From: Chuck Hill<[email protected]>
Subject: Re: Fetching on 2 EOMODELS using different schema in DATABASE
with but have relationship
To: [email protected]
Cc: WebObjects webobjects-dev<[email protected]>
Message-ID:<[email protected]>
Content-Type: text/plain; charset="us-ascii"
I think this is something that EOF can't do: qualify across schemas (databases
in EOF's view).
Chuck
On May 10, 2011, at 4:49 AM, [email protected] wrote:
Hi all,
I have 2 models using different schema of a database. but these schemas have table which have relationship.
So in my model "A", I use a fetch spec. on a table which have the maximum relation with tables in
model "A" and "B".
So when I excute my fech spec, WO don't see the schema of model A and show
exception ORA-00942 : table or view does not exist. This a the querry generate
by WO on fetching :
"SELECT t0.ANC_UV_OUVERTE_ID, t0.CATEG_ID, t0.CRE_DATE, t0.DIPL_SPEC_$C, t0.DIPLOME_$C, t0.MAJ_AUTEUR, t0.MAJ_DATE,
t0.NLE_UV_OUVERTE_ID, t0.UV_CREDITS_ECTS, t0.UV_OUV_ID FROM UV_OUVERTES t0, INDIVIDU T4, UV_OUV T1, ETU_INSCR_ADM T3, DIPLOME T2 WHERE
((T1.AN_UNIV like ? ESCAPE '\' AND T1.PRD_UNIV like ? ESCAPE '\') OR t0.DIPLOME_$C like ? ESCAPE '\' OR T3.NIVEAU_ADM = ? OR T1.UV_OUV_ID
= ?) AND T3.CONSEILLER_ID = T4.INDIV_ID AND t0.UV_OUV_ID = T1.UV_OUV_ID AND T2.DIPLOME_$C = T3.DIPLOME_$C AND t0.DIPLOME_$C =
T2.DIPLOME_$C ORDER BY T4.NOM ASC, T4.PRENOM ASC" withBindings: 1:"2005"(anUniv), 2:"1A"(prdUniv),
3:"ING2"(diplomec), 4:"1"(niveauAdm), 5:131(uvOuvId)>"
tables INDIVIDU, ETU_INSCR_ADM and DIPLOME are table of schema B but WO can't
translate it like that i.e : A.INDIVIDU or A.ETU_INSCR_ADM.
Thanks for your help
PS : I have a storedProcedure which return data and do the same request but I
don't know how to insert it in my code and binding it with WODisplayGroup for
batch view (previous, next) with 10 students per batch.
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/chill%40global-village.net
This email sent to [email protected]
--
Susanne Schneider
Coordinator secuTrial Development
iAS interActive Systems GmbH
Dieffenbachstraße 33 c, D-10967 Berlin
fon +49(0)30 22 50 50 - 498
fax +49(0)30 22 50 50 - 451
mail [email protected]
web http://www.interActive-Systems.de
----------------------------------------------------
Geschäftsführer: Dr. Marko Reschke, Thomas Fritzsche
Sitz der Gesellschaft: Berlin
Amtsgericht Berlin Charlottenburg, HRB 106103B
----------------------------------------------------
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [email protected]
