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

    Defining a Database Schema in JBOSS CMP

    afranken
    afranken Dec 15, 2003 9:15 AM

      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.

      • 2647 Views
      • Tags:
        • 1. Re: Defining a Database Schema in JBOSS CMP
          lekkim
          lekkim Dec 17, 2003 1:33 PM (in response to afranken)

          I am also quite interested in this... Have you tried switching on debug for the CMP engine to see what SQL is actually used ?

          To enable debug add the following to your log4j.xml file in the conf directory. The output is sent to the server.log:




          lekkim

            • Actions