Hi, in your eomodel, you should prefix your tables names by the schema they belong to. You should also use a single user to connect to your db, this user must have access to all the schemas used by your eomodels. This can be done in Properties of your app :
dbConnectURLGLOBAL = jdbc:oracle:thin:@localhost:1521:mydb dbConnectUserGLOBAL = user1 dbConnectPasswordGLOBAL = xxxx Hope it helps, Alex Le 10 mai 2011 à 13:49, [email protected] a écrit : > 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/alexis.tual%40gmail.com > > This email sent to [email protected]
_______________________________________________ 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]
