0 Replies Latest reply on Jul 4, 2003 11:42 AM by jernejm

    JBoss/DB2 configuration

    jernejm Newbie

      Hi,
      we're having problems configuring JBoss 3.2.1 to
      work with DB2 8.1. I connect to the database as db2admin user. When running the SELECT EJB-QL I keep getting the following error:

      javax.ejb.FinderException: Find failed: com.ibm.db2.jcc.c.SQLException: DB2 SQL error: SQLCODE: -204, SQLSTATE : 42704, SQLERRMC: DB2ADMIN.SCENARIO

      The SCENARIO database table is created in the schema called MW, not DB2ADMIN.

      How do I tell JBoss to use the schema I want when it
      generates SQL from EJB-QL statement?

      Thanks,
      Jernej