Resolution:
Description:
=========
JDBC connection test is successful but while running the following stack error is seen:

2011 Feb 11 11:25:57:484 GMT -5 ajha-W510.na.tibco.com Warning [DistributedCache] - [jdbcstore] BECoherenceJdbcStore initialization failed.
java.lang.ArrayIndexOutOfBoundsException: 7
    at oracle.security.o3logon.C1.r(C1)
    at oracle.security.o3logon.C1.l(C1)
    at oracle.security.o3logon.C0.e(C0)
    at oracle.security.o3logon.O3LoginClientHelper.getEPasswd(O3LoginClientHelper)
    at oracle.jdbc.ttc7.O3log.<init>(O3log.java:287)
    at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:227)
    at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:198)
    at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:251)
    at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:224)
    at java.sql.DriverManager.getConnection(DriverManager.java:582)
    at java.sql.DriverManager.getConnection(DriverManager.java:185)
    at com.tibco.be.jdbcstore.impl.DBConnectionPool.makeNewConnection(DBConnectionPool.java:338)
    at com.tibco.be.jdbcstore.impl.DBConnectionPool.makeInitialConnections(DBConnectionPool.java:309)
    at com.tibco.be.jdbcstore.impl.DBConnectionPool.init(DBConnectionPool.java:124)
    at com.tibco.be.jdbcstore.impl.DBConnectionPoolManager.init(DBConnectionPoolManager.java:30)
    at com.tibco.be.jdbcstore.impl.DBManager.init(DBManager.java:210)
    at com.tibco.be.jdbcstore.BECoherenceJdbcStore.initialize(BECoherenceJdbcStore.java:450)
    at com.tibco.be.jdbcstore.BECoherenceJdbcStore.<init>(BECoherenceJdbcStore.java:129)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
    at com.tangosol.util.ClassHelper.newInstance(ClassHelper.java:615)
    at com.tangosol.run.xml.XmlHelper.createInstance(XmlHelper.java:2501)
    at com.tangosol.run.xml.XmlHelper.createInstance(XmlHelper.java:2426)
    at com.tangosol.net.DefaultConfigurableCacheFactory.instantiateAny(DefaultConfigurableCacheFactory.java:3256)
    at com.tangosol.net.DefaultConfigurableCacheFactory.instantiateCacheStore(DefaultConfigurableCacheFactory.java:3106)
    at com.tangosol.net.DefaultConfigurableCacheFactory.instantiateReadWriteBackingMap(DefaultConfigurableCacheFactory.java:1674)
    at com.tangosol.net.DefaultConfigurableCacheFactory.configureBackingMap(DefaultConfigurableCacheFactory.java:1429)
    at com.tangosol.net.DefaultConfigurableCacheFactory$Manager.instantiateBackingMap(DefaultConfigurableCacheFactory.java:3904)
    at com.tangosol.coherence.component.util.daemon.queueProcessor.service.grid.partitionedService.PartitionedCache$Storage.instantiateResourceMap(PartitionedCache.CDB:22)
    at com.tangosol.coherence.component.util.daemon.queueProcessor.service.grid.partitionedService.PartitionedCache$Storage.setCacheName(PartitionedCache.CDB:25)
    at com.tangosol.coherence.component.util.daemon.queueProcessor.service.grid.partitionedService.PartitionedCache$ServiceConfig$ConfigListener.entryInserted(PartitionedCache.CDB:17)
    at com.tangosol.util.MapEvent.dispatch(MapEvent.java:266)
    at com.tangosol.util.MapEvent.dispatch(MapEvent.java:226)
    at com.tangosol.util.MapListenerSupport.fireEvent(MapListenerSupport.java:556)
    at com.tangosol.util.ObservableHashMap.dispatchEvent(ObservableHashMap.java:229)
    at com.tangosol.util.ObservableHashMap$Entry.onAdd(ObservableHashMap.java:270)
    at com.tangosol.util.SafeHashMap.put(SafeHashMap.java:244)
    at com.tangosol.coherence.component.util.ServiceConfig$Map.put(ServiceConfig.CDB:43)
    at com.tangosol.coherence.component.util.daemon.queueProcessor.service.grid.partitionedService.PartitionedCache$StorageIdRequest.onReceived(PartitionedCache.CDB:45)
    at com.tangosol.coherence.component.util.daemon.queueProcessor.service.Grid.onMessage(Grid.CDB:11)
    at com.tangosol.coherence.component.util.daemon.queueProcessor.service.Grid.onNotify(Grid.CDB:33)
    at com.tangosol.coherence.component.util.daemon.queueProcessor.service.grid.PartitionedService.onNotify(PartitionedService.CDB:3)
    at com.tangosol.coherence.component.util.daemon.queueProcessor.service.grid.partitionedService.PartitionedCache.onNotify(PartitionedCache.CDB:3)
    at com.tangosol.coherence.component.util.Daemon.run(Daemon.CDB:42)
    at java.lang.Thread.run(Thread.java:619)


Environment:
==========
All


Cause:
=====
Logs show the following:

[Loaded oracle.jdbc.driver.OracleConnection from file:/C:/TIBCOBE/tibcojre/1.6.0/lib/ext/classes12.zip].  

classes12.zip is old and was for an older version of Java.  What should be used is ojdbc6.jar as the customer is using JRE 1.6

Resolution:
=========
Remove classes12.zip from all paths and CLASSPATH.  Download the correct ojdbc6.jar file.  Note that there are different JAR files for Oracle 11 Release 1 and Release 2.