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
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: