2 Replies Latest reply on Jan 28, 2005 1:44 PM by Adrian Brock

    firebird *-xa-ds.xml problem Jboss freezes

    jivkoto Newbie

      Hi, I am using jboss 3.2.6 and I am migrating from ms sqlserver 2000 to firebird 1.5.2 (jeybird driver). When i start jboss it freezes. I am wondering why (yes i read first and second first.)
      Here is my firebird-xa-ds.xml file


      <xa-datasource>
      <jndi-name>WORKFLOWDB</jndi-name>
      <track-connection-by-tx>true</track-connection-by-tx>
      <isSameRM-override-value>false</isSameRM-override-value>
      <xa-datasource-class>org.firebirdsql.pool.FBConnectionPoolDataSource</xa-datasource-class>
      <xa-datasource-property name="Database">localhost/3050:WORKFLOWDB</xa-datasource-property>
      <user-name>SYSDBA</user-name>
      masterkey
      <!--transaction isolation-->
      <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
      <!--pooling parameters-->
      <min-pool-size>10</min-pool-size>
      <max-pool-size>500</max-pool-size>
      <blocking-timeout-millis>60000</blocking-timeout-millis>
      <idle-timeout-minutes>15</idle-timeout-minutes>
      <!-- Debugging -->
      <track-statements>true</track-statements>
      </xa-datasource>


      Last message before jboss freezes is:
      14:19:28,359 INFO [WORKFLOWDB] Bound connection factory for resource adapter fo
      r ConnectionManager 'jboss.jca:service=XATxCM,name=WORKFLOWDB to JNDI name 'java
      :/WORKFLOWDB'

      10x for even reading this

        • 1. Re: firebird *-xa-ds.xml problem Jboss freezes
          jivkoto Newbie

          UPDATE:
          after a while, exception occures (blocking timeout), any idea
          15:51:22,421 WARN [JBossManagedConnectionPool] Throwable while attempting to ge
          t a new connection: null
          org.jboss.resource.JBossResourceException: Could not create connection; - nested
          throwable: (java.sql.SQLException: Could not obtain connection during blocking
          timeout (2147483 ms))
          at org.jboss.resource.adapter.jdbc.xa.XAManagedConnectionFactory.createM
          anagedConnection(Unknown Source)
          at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.cr
          eateConnectionEventListener(Unknown Source)
          at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.ge
          tConnection(Unknown Source)
          at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BaseP
          ool.getConnection(Unknown Source)
          at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManage
          dConnection(Unknown Source)
          at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedCo
          nnection(Unknown Source)
          at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateC
          onnection(Unknown Source)
          at org.jboss.resource.connectionmanager.BaseConnectionManager2$Connectio
          nManagerProxy.allocateConnection(Unknown Source)
          at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(Unkno
          wn Source)
          at org.jboss.mq.pm.jdbc2.PersistenceManager.getConnection(Unknown Source
          )
          at org.jboss.mq.pm.jdbc2.PersistenceManager.resolveAllUncommitedTXs(Unkn
          own Source)
          at org.jboss.mq.pm.jdbc2.PersistenceManager.startService(Unknown Source)

          at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(Unknown Sourc
          e)
          at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(Unknown S
          ource)
          at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source)
          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
          sorImpl.java:25)
          at java.lang.reflect.Method.invoke(Method.java:324)
          at org.jboss.mx.server.ReflectedDispatcher.dispatch(Unknown Source)
          at org.jboss.mx.server.Invocation.dispatch(Unknown Source)
          at org.jboss.mx.server.Invocation.dispatch(Unknown Source)
          at org.jboss.mx.server.Invocation.invoke(Unknown Source)
          at org.jboss.mx.server.AbstractMBeanInvoker.invoke(Unknown Source)
          at org.jboss.mx.server.MBeanServerImpl.invoke(Unknown Source)
          at org.jboss.system.ServiceController$ServiceProxy.invoke(Unknown Source
          )
          at $Proxy18.start(Unknown Source)
          at org.jboss.system.ServiceController.start(Unknown Source)
          at org.jboss.system.ServiceController.start(Unknown Source)
          at org.jboss.system.ServiceController.start(Unknown Source)
          at sun.reflect.GeneratedMethodAccessor6.invoke(Unknown Source)
          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
          sorImpl.java:25)
          at java.lang.reflect.Method.invoke(Method.java:324)
          at org.jboss.mx.server.ReflectedDispatcher.dispatch(Unknown Source)
          at org.jboss.mx.server.Invocation.dispatch(Unknown Source)
          at org.jboss.mx.server.Invocation.dispatch(Unknown Source)
          at org.jboss.mx.server.Invocation.invoke(Unknown Source)
          at org.jboss.mx.server.AbstractMBeanInvoker.invoke(Unknown Source)
          at org.jboss.mx.server.MBeanServerImpl.invoke(Unknown Source)
          at org.jboss.mx.util.MBeanProxyExt.invoke(Unknown Source)
          at $Proxy4.start(Unknown Source)
          at org.jboss.deployment.SARDeployer.start(Unknown Source)
          at org.jboss.deployment.MainDeployer.start(Unknown Source)
          at org.jboss.deployment.MainDeployer.deploy(Unknown Source)
          at org.jboss.deployment.MainDeployer.deploy(Unknown Source)
          at sun.reflect.GeneratedMethodAccessor18.invoke(Unknown Source)
          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
          sorImpl.java:25)
          at java.lang.reflect.Method.invoke(Method.java:324)
          at org.jboss.mx.server.ReflectedDispatcher.dispatch(Unknown Source)
          at org.jboss.mx.server.Invocation.dispatch(Unknown Source)
          at org.jboss.mx.server.Invocation.dispatch(Unknown Source)
          at org.jboss.mx.server.Invocation.invoke(Unknown Source)
          at org.jboss.mx.server.AbstractMBeanInvoker.invoke(Unknown Source)
          at org.jboss.mx.server.MBeanServerImpl.invoke(Unknown Source)
          at org.jboss.mx.util.MBeanProxyExt.invoke(Unknown Source)
          at $Proxy8.deploy(Unknown Source)
          at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(Unknown Sour
          ce)
          at org.jboss.deployment.scanner.URLDeploymentScanner.scan(Unknown Source
          )
          at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.
          doScan(Unknown Source)
          at org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(U
          nknown Source)
          at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(Unknown Sourc
          e)
          at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(Unknown S
          ource)
          at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source)
          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
          sorImpl.java:25)
          at java.lang.reflect.Method.invoke(Method.java:324)
          at org.jboss.mx.server.ReflectedDispatcher.dispatch(Unknown Source)
          at org.jboss.mx.server.Invocation.dispatch(Unknown Source)
          at org.jboss.mx.server.Invocation.dispatch(Unknown Source)
          at org.jboss.mx.server.Invocation.invoke(Unknown Source)
          at org.jboss.mx.server.AbstractMBeanInvoker.invoke(Unknown Source)
          at org.jboss.mx.server.MBeanServerImpl.invoke(Unknown Source)
          at org.jboss.system.ServiceController$ServiceProxy.invoke(Unknown Source
          )
          at $Proxy0.start(Unknown Source)
          at org.jboss.system.ServiceController.start(Unknown Source)
          at sun.reflect.GeneratedMethodAccessor6.invoke(Unknown Source)
          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
          sorImpl.java:25)
          at java.lang.reflect.Method.invoke(Method.java:324)
          at org.jboss.mx.server.ReflectedDispatcher.dispatch(Unknown Source)
          at org.jboss.mx.server.Invocation.dispatch(Unknown Source)
          at org.jboss.mx.server.Invocation.dispatch(Unknown Source)
          at org.jboss.mx.server.Invocation.invoke(Unknown Source)
          at org.jboss.mx.server.AbstractMBeanInvoker.invoke(Unknown Source)
          at org.jboss.mx.server.MBeanServerImpl.invoke(Unknown Source)
          at org.jboss.mx.util.MBeanProxyExt.invoke(Unknown Source)
          at $Proxy4.start(Unknown Source)
          at org.jboss.deployment.SARDeployer.start(Unknown Source)
          at org.jboss.deployment.MainDeployer.start(Unknown Source)
          at org.jboss.deployment.MainDeployer.deploy(Unknown Source)
          at org.jboss.deployment.MainDeployer.deploy(Unknown Source)
          at org.jboss.deployment.MainDeployer.deploy(Unknown Source)
          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
          at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
          java:39)
          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
          sorImpl.java:25)
          at java.lang.reflect.Method.invoke(Method.java:324)
          at org.jboss.mx.server.ReflectedDispatcher.dispatch(Unknown Source)
          at org.jboss.mx.server.Invocation.dispatch(Unknown Source)
          at org.jboss.mx.server.Invocation.dispatch(Unknown Source)
          at org.jboss.mx.server.Invocation.invoke(Unknown Source)
          at org.jboss.mx.server.AbstractMBeanInvoker.invoke(Unknown Source)
          at org.jboss.mx.server.MBeanServerImpl.invoke(Unknown Source)
          at org.jboss.mx.util.MBeanProxyExt.invoke(Unknown Source)
          at $Proxy5.deploy(Unknown Source)
          at org.jboss.system.server.ServerImpl.doStart(Unknown Source)
          at org.jboss.system.server.ServerImpl.start(Unknown Source)
          at org.jboss.Main.boot(Unknown Source)
          at org.jboss.Main$1.run(Unknown Source)
          at java.lang.Thread.run(Thread.java:534)
          Caused by: java.sql.SQLException: Could not obtain connection during blocking ti
          meout (2147483 ms)
          at org.firebirdsql.pool.PooledConnectionQueue.take(PooledConnectionQueue
          .java:313)
          at org.firebirdsql.pool.AbstractConnectionPool.getPooledConnection(Abstr
          actConnectionPool.java:208)
          at org.firebirdsql.pool.FBConnectionPoolDataSource.getPooledConnection(F
          BConnectionPoolDataSource.java:352)
          at org.firebirdsql.pool.FBConnectionPoolDataSource.getPooledConnection(F
          BConnectionPoolDataSource.java:371)
          at org.firebirdsql.pool.FBConnectionPoolDataSource.getXAConnection(FBCon
          nectionPoolDataSource.java:402)
          ... 105 more

          • 2. Re: firebird *-xa-ds.xml problem Jboss freezes
            Adrian Brock Master

            This is a firebird issue:

            Caused by: java.sql.SQLException: Could not obtain connection during blocking ti
            meout (2147483 ms)
            at org.firebirdsql.pool.PooledConnectionQueue.take(PooledConnectionQueue
            .java:313)
            


            I dispair sometimes at java developers inability to read stack traces.