1 Reply Latest reply on Mar 6, 2003 9:08 AM by davidjencks

    problem accessing cmr field

    rostiarso

      hi guys,

      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)]
      at org.hsqldb.Trace.getError(Trace.java:180)
      at org.hsqldb.Result.(Result.java:175)
      at org.hsqldb.jdbcConnection.executeHSQL(jdbcConnection.java:907)
      at org.hsqldb.jdbcConnection.execute(jdbcConnection.java:718)
      at org.hsqldb.jdbcStatement.fetchResult(jdbcStatement.java:686)
      at org.hsqldb.jdbcStatement.executeQuery(jdbcStatement.java:68)
      at org.hsqldb.jdbcPreparedStatement.executeQuery(jdbcPreparedStatement.j
      ava:133)

      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.