Thanks Chuck to your quick reaction, So the Only solution is to use my StoredProcedure which return data. The storedProcedures is declared in my model A. So how to call it and cast data like student and bind it to WODisplayGroup for my batch view?
I have seven parameters with IN and one with OUT to return data. Ray ======================================== Message du : 10/05/2011 De : "Chuck Hill " <ch...@global-village.net> A : naneon.raym...@neuf.fr Copie à : webobjects-dev@lists.apple.com Sujet : Re: Fetching on 2 EOMODELS using different schema in DATABASE with but have relationship 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, naneon.raym...@neuf.fr 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 (Webobjects-dev@lists.apple.com) > Help/Unsubscribe/Update your Subscription: > http://lists.apple.com/mailman/options/webobjects-dev/chill%40global-village.net > > This email sent to ch...@global-village.net -- 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/
_______________________________________________ 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: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
