need some help.
i'm trying to test my CMR in a stateless session bean.
the relationship is Departments - Employees (1:N) bidirectional.
using Oracle 9i's example tables.
i've successfully accessed the related entity beans individually through the session bean,
and also getting employee's department.
But the problem is trying to get department's employees
JBoss throws exceptions started with:
21:23:14,098 ERROR [LogInterceptor] TransactionRolledbackLocalException, causedBy:
java.sql.SQLException: Table not found: EMPLOYEES in statement [SELECT EMPLOYEE_
ID FROM EMPLOYEES WHERE (DEPARTMENT_ID=20)]
now, remember that i said i'm using Oracle?
and the employees table definitely exist in my oracle db.
then why its the hsqldb driver that throws the exceptions?
i guess JBoss is using the default hsqldb driver,
and in the hsqldb the employees table doesn't exist :)
i guess it's some kind of configuration problem that i made,
can somebody point me where did i do wrong?
hanks in advance.
Is the resource-ref correct for the Employees EJB in jboss.xml and ejb-jar.xml?