hi
I have 2 classes: one for department(HRDepartment) and
another one for employer (HREmployer)
there is a 1:1 association with these 2 classes:
----------------------------------------------------
HRDepartment.manager : HREmployer
----------------------------------------------------
I try to use the manager's name to find his managed
department:
----------------------------------------------------
Criteria crit = new Criteria();
crit.addEqualTo("manager.name", managerName);
QueryByCriteria query = new
QueryByCriteria(HRDepartment.class, crit);
HRDepartment department = (HRDepartment)
broker.getObjectByQuery(query);
----------------------------------------------------
the executed sql as: (spy.log)
----------------------------------------------------
SELECT
A0.FULL_NAME,A0.MANAGER_ID,A0.DEPT_NO,A0.TOP_DEPT
FROM
HR_ORG A0
INNER JOIN
HR_EMP A1
ON
A0.MANAGER_ID=A1.EMP_NO
WHERE
A1.NAME = 'michael'
----------------------------------------------------
but I caught an exception:
----------------------------------------------------
java.sql.SQLException: ORA-00933: SQL...(message in
chinese)
//Oracle 8i doesnt support inner join, said in oracle
forum. (is it ture?)
----------------------------------------------------
I use Oracle 8i and classes12.zip as driver
does OJB inner join work with Oracle 8i?
(had you tried such usage with Oracle 8i?)
how to slove these problems?
thanks.
elvis
__________________________________
Do you Yahoo!?
Yahoo! Mail SpamGuard - Read only the mail you want.
http://antispam.yahoo.com/tools
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
