1 Reply Latest reply on Jul 31, 2002 6:54 AM by Tranchida Giampaolo

    AS/400 (part 2)

    Jose Antonio Newbie

      How folks,

      I'm 2.4.4 with MySQL (non-transactional) and everytime I close a connection I simply get the log message

      '[INFO,DefaultDS] No transaction right now.'

      which makes me think we're not putting connections back into the pool correctly.

      The root problem is that we're overloading the DB pool much too easily.

      I've placed the jboss.jcml section below. Can anybody please help with this, or is more info needed?

      Many Thanks
      Ian Hunter

      =============================================




      org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl


      DefaultDS
      [THE URL]

      [USER]
      [PWORD]

      true
      60000
      true
      30
      true
      30
      0
      true
      60000
      10000



        • 1. Re: AS/400 (part 2)
          Tranchida Giampaolo Newbie

          You give the wrong class as JDBC driver in your configuration file.

          Modify this


          org.hsqldb.jdbcDriver,com.ibm.as400.access.AS400JDBCDataSource


          with this


          org.hsqldb.jdbcDriver,com.ibm.as400.access.AS400JDBCDriver


          Warning

          If you use the two phase commit, your dbfile must be journalized or set as read-only.