I am using JBoss 3.0RC2, DB2 7.1
I can deploy ok, I can get ref to home object ok.
Problem is when I do a findAll() or create() (or any other method).
I get the following error:
javax.ejb.FinderException: Find failed: COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL0204N "ADMIN.CMBN_DB" is an undefined name. SQLSTATE=42704 at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractQueryCommand.execute(JDBCAbstractQueryCommand.java:143)
ADMIN is the account with full rights to the database. CMBN_DB is the name of the database (not the table the bean is supposed to access).
In my login-config.xml I have specified "admin" for principal, user and password. I tried to use "CMBN_SCHEMA" for the principal but that didnt help (thats the name of the schema).
WHERE is it picking up the ADMIN part of ADMIN.CMBN_DB ?? I didnt specify it anywhere? Is this possibly an error returned from DB2 itself (different machine)?