4 Replies Latest reply on Jan 31, 2006 10:07 AM by louis115

    [JBossManagedConnectionPool] Unable to fill pool

    louis115

      Hey,
      once in a while I get the following error when I fetch a connection from the pool (using JBoss 3.2.6 and Oracle 9i)

      [JBossManagedConnectionPool] Unable to fill pool
      org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.lang.NullPointerException)
      at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:168)
      at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:508)
      at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.fillToMin(InternalManagedConnectionPool.java:455)
      at org.jboss.resource.connectionmanager.PoolFiller.run(PoolFiller.java:69)
      at java.lang.Thread.run(Thread.java:534)
      Caused by: java.lang.NullPointerException
      at org.jboss.mx.loading.LoadMgr3.beginLoadTask(LoadMgr3.java:143)
      at org.jboss.mx.loading.UnifiedClassLoader3.loadClassImpl(UnifiedClassLoader3.java:186)
      at org.jboss.mx.loading.UnifiedClassLoader3.loadClass(UnifiedClassLoader3.java:136)
      at java.lang.ClassLoader.loadClass(ClassLoader.java:235)
      at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:302)
      at java.lang.Class.forName0(Native Method)
      at java.lang.Class.forName(Class.java:141)
      at oracle.net.ns.NetException.(Unknown Source)
      at oracle.net.ano.Ano.e(Ano)
      at oracle.net.ano.Ano.init(Ano)
      at oracle.net.ns.NSProtocol.connect(Unknown Source)
      at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:708)
      at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:219)
      at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:344)
      at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:148)
      at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
      at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:545)
      at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:158)
      ... 4 more
      15:52:38,148 WARN [JBossManagedConnectionPool] Unable to fill pool
      org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.lang.NullPointerException)
      at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:168)
      at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:508)
      at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.fillToMin(InternalManagedConnectionPool.java:455)
      at org.jboss.resource.connectionmanager.PoolFiller.run(PoolFiller.java:69)
      at java.lang.Thread.run(Thread.java:534)
      Caused by: java.lang.NullPointerException
      at org.jboss.mx.loading.LoadMgr3.beginLoadTask(LoadMgr3.java:143)
      at org.jboss.mx.loading.UnifiedClassLoader3.loadClassImpl(UnifiedClassLoader3.java:186)
      at org.jboss.mx.loading.UnifiedClassLoader3.loadClass(UnifiedClassLoader3.java:136)
      at java.lang.ClassLoader.loadClass(ClassLoader.java:235)
      at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:302)
      at java.lang.Class.forName0(Native Method)
      at java.lang.Class.forName(Class.java:141)
      at oracle.net.ns.NetException.(Unknown Source)
      at oracle.net.ano.Ano.e(Ano)
      at oracle.net.ano.Ano.init(Ano)
      at oracle.net.ns.NSProtocol.connect(Unknown Source)
      at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:708)
      at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:219)
      at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:344)
      at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:148)
      at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
      at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:545)
      at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:158)
      ... 4 more


      So my oracle-ds-xml look like this:
      <?xml version="1.0" encoding="UTF-8"?>


      <local-tx-datasource>
      <jndi-name>jdbc/ignis/trinity/elsdemob</jndi-name>
      <use-java-context>false</use-java-context>
      <connection-url>jdbc:oracle:thin:@trinity:1521:elsdemob</connection-url>
      <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
      <...>
      <min-pool-size>5</min-pool-size>
      <max-pool-size>20</max-pool-size>
      <blocking-timeout-millis>5000</blocking-timeout-millis>
      <idle-timeout-minutes>15</idle-timeout-minutes>

      <type-mapping>Oracle9i</type-mapping>

      </local-tx-datasource>
      <local-tx-datasource>
      <jndi-name>jdbc/ignis/beryll/ignis_s</jndi-name>
      <use-java-context>false</use-java-context>
      <connection-url>jdbc:oracle:thin:@beryll:1521:ignis_s</connection-url>
      <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
      <...>
      <min-pool-size>5</min-pool-size>
      <max-pool-size>20</max-pool-size>
      <blocking-timeout-millis>5000</blocking-timeout-millis>
      <idle-timeout-minutes>15</idle-timeout-minutes>

      <type-mapping>Oracle9i</type-mapping>

      </local-tx-datasource>



      If I access the JMX Management Console and stop and restart the ManagedConnectionPool, then everything works fine again.

      Any help?

      Louis