Right now I'm using a XA datasource to an Oracle database in my application and it works very well, but I need to test it using the oci driver.
I've resolved some problems but now I'm getting the following exception:
.
.
.
20:57:53,520 INFO Oracle XA datasource with oci driver JNDI InitialContext properties:{}
20:57:54,017 WARN Oracle XA datasource with oci driver Connection error occured: org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener@155a2e[state=NORMAL mc=org.jboss.resource.adapter.jdbc.xa.XAManagedConnection@1ad96b4 handles=0 lastUse=1302055072412 permit=true trackByTx=true mcp=org.jboss.resource.connectionmanager.JBossManagedConnectionPool$PoolBySubject@aead4b context=org.jboss.resource.connectionmanager.InternalManagedConnectionPool@1f352c5 xaResource=org.jboss.resource.adapter.jdbc.xa.XAManagedConnection@1ad96b4 txSync=null]
oracle.jdbc.xa.OracleXAException
at oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java:938)
at oracle.jdbc.xa.client.OracleXAResource.start(OracleXAResource.java:244)
at org.jboss.resource.adapter.jdbc.xa.XAManagedConnection.start(XAManagedConnection.java:213)
at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.enlistResource(TransactionImple.java:799)
at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.enlistResource(TransactionImple.java:510)
at org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener$TransactionSynchronization.enlist(TxConnectionManager.java:908)
at org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener.enlist(TxConnectionManager.java:662)
at org.jboss.resource.connectionmanager.TxConnectionManager.managedConnectionReconnected(TxConnectionManager.java:403)
at org.jboss.resource.connectionmanager.BaseConnectionManager2.reconnectManagedConnection(BaseConnectionManager2.java:625)
at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:499)
at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:941)
at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:89)
at org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:92)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)
at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)
at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1573)
at org.hibernate.loader.Loader.doQuery(Loader.java:696)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)
at org.hibernate.loader.Loader.doList(Loader.java:2228)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2125)
at org.hibernate.loader.Loader.list(Loader.java:2120)
at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:118)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1596)
at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:306)
.
.
.
20:57:54,024 ERROR Oracle XA datasource with oci driver java.lang.IllegalMonitorStateException
20:57:54,024 ERROR Oracle XA datasource with oci driver at java.util.concurrent.locks.ReentrantLock$Sync.tryRelease(ReentrantLock.java:127)
20:57:54,025 ERROR Oracle XA datasource with oci driver at java.util.concurrent.locks.AbstractQueuedSynchronizer.release(AbstractQueuedSynchronizer.java:1175)
20:57:54,025 ERROR Oracle XA datasource with oci driver at java.util.concurrent.locks.ReentrantLock.unlock(ReentrantLock.java:431)
20:57:54,025 ERROR Oracle XA datasource with oci driver at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.unlock(BaseWrapperManagedConnection.java:277)
20:57:54,025 ERROR Oracle XA datasource with oci driver at org.jboss.resource.adapter.jdbc.xa.XAManagedConnection.start(XAManagedConnection.java:235)
20:57:54,025 ERROR Oracle XA datasource with oci driver at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.enlistResource(TransactionImple.java:799)
20:57:54,025 ERROR Oracle XA datasource with oci driver at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.enlistResource(TransactionImple.java:510)
20:57:54,025 ERROR Oracle XA datasource with oci driver at org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener$TransactionSynchronization.enlist(TxConnectionManager.java:908)
20:57:54,025 ERROR Oracle XA datasource with oci driver at org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener.enlist(TxConnectionManager.java:662)
20:57:54,025 ERROR Oracle XA datasource with oci driver at org.jboss.resource.connectionmanager.TxConnectionManager.managedConnectionReconnected(TxConnectionManager.java:403)
20:57:54,025 ERROR Oracle XA datasource with oci driver at org.jboss.resource.connectionmanager.BaseConnectionManager2.reconnectManagedConnection(BaseConnectionManager2.java:625)
20:57:54,025 ERROR Oracle XA datasource with oci driver at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:499)
20:57:54,025 ERROR Oracle XA datasource with oci driver at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:941)
20:57:54,025 ERROR Oracle XA datasource with oci driver at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:89)
20:57:54,031 ERROR Oracle XA datasource with oci driver at org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:92)
20:57:54,031 ERROR Oracle XA datasource with oci driver at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)
20:57:54,031 ERROR Oracle XA datasource with oci driver at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)
20:57:54,031 ERROR Oracle XA datasource with oci driver at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)
20:57:54,031 ERROR Oracle XA datasource with oci driver at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1573)
20:57:54,031 ERROR Oracle XA datasource with oci driver at org.hibernate.loader.Loader.doQuery(Loader.java:696)
20:57:54,031 ERROR Oracle XA datasource with oci driver at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)
20:57:54,031 ERROR Oracle XA datasource with oci driver at org.hibernate.loader.Loader.doList(Loader.java:2228)
20:57:54,032 ERROR Oracle XA datasource with oci driver at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2125)
20:57:54,032 ERROR Oracle XA datasource with oci driver at org.hibernate.loader.Loader.list(Loader.java:2120)
20:57:54,032 ERROR Oracle XA datasource with oci driver at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:118)
20:57:54,032 ERROR Oracle XA datasource with oci driver at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1596)
20:57:54,032 ERROR Oracle XA datasource with oci driver at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:306)
.
.
20:57:54,129 WARN Oracle XA datasource with oci driver SQL Error: 0, SQLState: null
20:57:54,129 ERROR Oracle XA datasource with oci driver Could not enlist in transaction on entering meta-aware object!; - nested throwable: (javax.transaction.SystemException: java.lang.Throwable: Unabled to enlist resource, see the previous warnings. tx=TransactionImple < ac, BasicAction: a040d3d:96b5:4d9bc88b:6b status: ActionStatus.ABORT_ONLY >); - nested throwable: (org.jboss.resource.JBossResourceException: Could not enlist in transaction on entering meta-aware object!; - nested throwable: (javax.transaction.SystemException: java.lang.Throwable: Unabled to enlist resource, see the previous warnings. tx=TransactionImple < ac, BasicAction: a040d3d:96b5:4d9bc88b:6b status: ActionStatus.ABORT_ONLY >))
20:57:54,135 WARN Oracle XA datasource with oci driver SQL Error: 0, SQLState: null
20:57:54,135 ERROR Oracle XA datasource with oci driver Transaction is not active: tx=TransactionImple < ac, BasicAction: a040d3d:96b5:4d9bc88b:6b status: ActionStatus.ABORT_ONLY >; - nested throwable: (javax.resource.ResourceException: Transaction is not active: tx=TransactionImple < ac, BasicAction: a040d3d:96b5:4d9bc88b:6b status: ActionStatus.ABORT_ONLY >)
.
.
.
20:57:54,146 ERROR Oracle XA datasource with oci driver Caused by: org.hibernate.exception.GenericJDBCException: Cannot open connection
20:57:54,146 ERROR Oracle XA datasource with oci driver at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:126)
20:57:54,146 ERROR Oracle XA datasource with oci driver at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:114)
20:57:54,146 ERROR Oracle XA datasource with oci driver at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
20:57:54,146 ERROR Oracle XA datasource with oci driver at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:52)
20:57:54,146 ERROR Oracle XA datasource with oci driver at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:449)
20:57:54,146 ERROR Oracle XA datasource with oci driver at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)
20:57:54,146 ERROR Oracle XA datasource with oci driver at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)
20:57:54,146 ERROR Oracle XA datasource with oci driver at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1573)
20:57:54,146 ERROR Oracle XA datasource with oci driver at org.hibernate.loader.Loader.doQuery(Loader.java:696)
20:57:54,146 ERROR Oracle XA datasource with oci driver at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)
20:57:54,146 ERROR Oracle XA datasource with oci driver at org.hibernate.loader.Loader.doList(Loader.java:2228)
20:57:54,146 ERROR Oracle XA datasource with oci driver at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2125)
20:57:54,146 ERROR Oracle XA datasource with oci driver at org.hibernate.loader.Loader.list(Loader.java:2120)
20:57:54,146 ERROR Oracle XA datasource with oci driver at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:118)
20:57:54,146 ERROR Oracle XA datasource with oci driver at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1596)
20:57:54,146 ERROR Oracle XA datasource with oci driver at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:306)
.
.
.
20:57:54,147 ERROR Oracle XA datasource with oci driver Caused by: org.jboss.util.NestedSQLException: Transaction is not active: tx=TransactionImple < ac, BasicAction: a040d3d:96b5:4d9bc88b:6b status: ActionStatus.ABORT_ONLY >; - nested throwable: (javax.resource.ResourceException: Transaction is not active: tx=TransactionImple < ac, BasicAction: a040d3d:96b5:4d9bc88b:6b status: ActionStatus.ABORT_ONLY >)
20:57:54,147 ERROR Oracle XA datasource with oci driver at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:95)
20:57:54,147 ERROR Oracle XA datasource with oci driver at org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:92)
20:57:54,147 ERROR Oracle XA datasource with oci driver at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)
20:57:54,147 ERROR Oracle XA datasource with oci driver ... 151 more
20:57:54,147 ERROR Oracle XA datasource with oci driver Caused by: javax.resource.ResourceException: Transaction is not active: tx=TransactionImple < ac, BasicAction: a040d3d:96b5:4d9bc88b:6b status: ActionStatus.ABORT_ONLY >
20:57:54,148 ERROR Oracle XA datasource with oci driver at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:370)
20:57:54,148 ERROR Oracle XA datasource with oci driver at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:496)
20:57:54,148 ERROR Oracle XA datasource with oci driver at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:941)
20:57:54,148 ERROR Oracle XA datasource with oci driver at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:89)
.
.
.
What i've already done is add the oracle_env.sh script provided by the oracle installation which added the following environment variables:
ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
ORACLE_SID=XE
NLS_LANG=`$ORACLE_HOME/bin/nls_lang.sh`
PATH=$ORACLE_HOME/bin:$PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib
That resolved a previous problem where a native library cannot be found in the 'java.library.path'.
Another thing I've done is configure a TNS service name in my tnsnames.ora file located in my home directory, which don't need before using the oci driver.
I'm working with:
Oracle 10g XE Release 10.2.0.1.0
JBoss AS 5.1.0.GA
Any help will be appreciated