1 Reply Latest reply on Dec 17, 2003 1:33 PM by Mikkel Heisterberg

    Defining a Database Schema in JBOSS CMP

    afranken Newbie

      Is there a specific way to specify an EJB to use a table located in a schema? Example, I have an oracle database with tables located in the VSXLIB schema. In jbosscmp-jdbc.xml I specify <table-name>VSXLIB.tablename</table-name>.
      <abstract-schema-name>TaAcctSum</abstract-schema-name> in ejbjar.xml.

      Everything works except findByPrimaryKey and findXXX methods with parameters(?1,etc).

      My findByPrimaryKey returns a NoSuchEntityException.

      Example EJBQL: SELECT OBJECT(a) FROM TaAcctSum a WHERE a.tid = ?1

      Thanks.