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] -- Chuck Hill Senior Consultant / VP Development Come to WOWODC this July for unparalleled WO learning opportunities and real peer to peer problem solving! Network, socialize, and enjoy a great cosmopolitan city. See you there! http://www.wocommunity.org/wowodc11/
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________ 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]
