Defining a Database Schema in JBOSS CMP

[afranken]

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.

[lekkim]

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