1 Reply Latest reply on Feb 15, 2002 2:26 AM by koonkay

    Problem on inserting data to DB2 7.1 when using connection p

    koonkay

      I've tried to insert a number of record just use 2-tired jdbc connection to DB2. It is ok. However , after i used connection pool, some record's insertion show
      "[Default] COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/LINUX] SQL0301N The value of a host variable in the EXECUTE or OPEN statement cannot be used because of its data type. SQLSTATE=07006
      [Default] at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(SQLExceptionGenerator.java:260)
      [Default]
      "
      how can i do?

        • 1. Re: Problem on inserting data to DB2 7.1 when using connecti
          koonkay

          FurtherMore, my mbean configuration is

          org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl<!-- [JBoss 2.4] -->
          <!-- attribute name="DataSourceClass">org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImpl</attribute --><!-- [JBoss 2.2.2] -->
          DB2DS
          <!-- attribute name="URL">jdbc:db2://host.domain.com:port/database</attribute -->
          jdbc:db2:dev
          gdb
          password
          jdbc/DB2DS