3 Replies Latest reply on Jan 29, 2004 5:46 PM by sam ramirez

    Connecting every Second

    Frank Breckle Newbie

       

      "frank_breckle" wrote:
      Hi,

      I've got a JBoss 3.2.3 instance running on Linux. My BMP beans are connecting via JBDC to an iSeries. We are using the connection pooling of the JBoss. The iSeries is writing a protocoll when a connection is started and dropped.

      My questions: Why is every second a connection started even in the night where no beans are loaded and no processes are running in our JBoss environment (this is protocolled on the iSeries)? Is this a control mechanism to check if the database is still available? How can we switch that off?

      The datasource parameters are:

      datasources>
      <local-tx-datasource>
      <jndi-name>AS400DS</jndi-name>
      <connection-url>jdbc:as400://AS400/GLDAT;sort=language;sort language=DEU;date format=eur;libraries=GLDAT_HST,GLDAT_WRK</connection-url>

      <driver-class>com.ibm.as400.access.AS400JDBCDriver</driver-class>
      <user-name>xxxx</user-name>
      <password>xxxxx</password>
      <min-pool-size>10</min-pool-size>
      <max-pool-size>50</max-pool-size>
      <!-- sql to call when connection is created
      <new-connection-sql>some arbitrary sql</new-connection-sql>
      -->

      <!-- sql to call on an existing pooled connection when it is obtained from pool
      <check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql>
      -->

      </local-tx-datasource>

      </datasources>

      Regards
      Frank


        • 1. Re: Connecting every Second
          Franco Apprentice

           

          "fbiaggi" wrote:
          Hi,
          I suspect that this is done by jt400, we have smilar implementations without similar problems.
          Is your "libraries=..." working ? This should be onlye supported in native mode (naming=system).

          Sample DS:

          <datasources>
          <local-tx-datasource>
          <jndi-name>legacy</jndi-name>
          <connection-url>jdbc:as400://10.1.1.1;block size=128;extended dynamic=true;package=JBOSS;package cache=true;package library=QGPL</connection-url>
          <driver-class>com.ibm.as400.access.AS400JDBCDriver</driver-class>
          <user-name>jb</user-name>
          <password>jbwd</password>
          </local-tx-datasource>





          • 2. Re: Connecting every Second
            Frank Breckle Newbie

             

            "frank_breckle" wrote:
            Hi,

            the "libraries"-tag is working. We are using that because of triggers on db-files.

            I can't really believe that this is caused by the IBM java toolbox. If we stop JBoss no further connect information is logged on the iSeries. Which JTOpen Version are you using?

            Regards
            Frank


            • 3. Re: Connecting every Second
              sam ramirez Newbie

               

              "samofborg" wrote:
              Hello,

              I'm experiencing the very same thing on Linux (RH8), Sun JDK 1.4.2, JBoss 3.2.2, and Oracle. Oracle's listener is logging a connection every second or so. I've looked for a switch or something to turn that off or at least decrease the frequency in jboss, but am not talented enough to find one. Everything runs fine, except that the logs are filling up quite fast - 27,000 entries in the database logs in one day - today.

              My DS looks identical to what's been posted, except for driver and url info.

              Sam