1 Reply Latest reply on Nov 9, 2005 10:08 AM by mroodzant

    ArrayIndexOutOfBoundsException on connection

      Hi,

      I am using jboss 4.0.2 and trying to connect to a datasource that is configured as follows:

      <local-tx-datasource>
      <jndi-name>jdbc/oracle/APP_ECM_PLT</jndi-name>
      <connection-url>jdbc:oracle:thin:@10.95.20.20:1522:EMESO</connection-url>
      <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
      <user-name>username</user-name>
      password

      <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->

      <type-mapping>Oracle8</type-mapping>

      </local-tx-datasource>



      As soon as a connection is set up the following stacktrace occurs:

      2005-11-09 14:30:54,179 DEBUG [nl.ibsp.postcodecheck.services.PostcodeCheckServicesEJB] Retrieved datasource
      2005-11-09 14:30:54,191 DEBUG [org.jboss.resource.connectionmanager.IdleRemover] internalRegisterPool: registering pool with interval 900000 old interval: 9223372036854775807
      2005-11-09 14:30:54,191 DEBUG [org.jboss.resource.connectionmanager.IdleRemover] internalRegisterPool: about to notify thread: old next: 1131543504191, new next: 1131543504191
      2005-11-09 14:30:54,191 DEBUG [org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory] Using properties: {user=APP_ECM_PLT, password=--hidden--}
      2005-11-09 14:30:54,191 DEBUG [org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory] Checking driver for URL: jdbc:oracle:thin:@10.95.20.20:1522:EMESO
      2005-11-09 14:30:54,192 DEBUG [org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory] Driver not yet registered for url: jdbc:oracle:thin:@10.95.20.20:1522:EMESO
      2005-11-09 14:30:54,452 DEBUG [org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory] Driver already registered for url: jdbc:oracle:thin:@10.95.20.20:1522:EMESO
      2005-11-09 14:30:55,145 DEBUG [org.jboss.util.NestedThrowable] org.jboss.util.NestedThrowable.parentTraceEnabled=true
      2005-11-09 14:30:55,145 DEBUG [org.jboss.util.NestedThrowable] org.jboss.util.NestedThrowable.nestedTraceEnabled=false
      2005-11-09 14:30:55,145 DEBUG [org.jboss.util.NestedThrowable] org.jboss.util.NestedThrowable.detectDuplicateNesting=true
      2005-11-09 14:30:55,140 WARN [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] Throwable while attempting to get a new connection: null
      org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.lang.ArrayIndexOutOfBoundsException: 7)
      at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:161)
      at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:508)
      at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:207)
      at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:534)
      at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:395)
      at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:297)
      at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:447)
      at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:874)
      at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:103)
      at nl.ibsp.postcodecheck.services.PostcodeCheckServicesEJB.getConnection(PostcodeCheckServicesEJB.java:462)
      at nl.ibsp.postcodecheck.services.PostcodeCheckServicesEJB.getAddressModel(PostcodeCheckServicesEJB.java:110)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:585)
      at org.jboss.invocation.Invocation.performCall(Invocation.java:345)


      Can anyone shed any light on what is wrong here?
      thanks beforehand,
      Marjon Roodzant