0 Replies Latest reply on May 26, 2002 1:30 PM by Kenny

    DB2 problem

    Kenny Newbie

      Hi all,

      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)
      ...etc...


      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)?

      Regards,
      Kenny