<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<body link="#355491" alink="#4262a1" vlink="#355491" style="background: #e2e2e2; margin: 0; padding: 20px;">
<div>
<table cellpadding="0" bgcolor="#FFFFFF" border="0" cellspacing="0" style="border: 1px solid #dadada; margin-bottom: 30px; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td>
<table border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" style="border: solid 2px #ccc; background: #dadada; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td bgcolor="#000000" valign="middle" height="58px" style="border-bottom: 1px solid #ccc; padding: 20px; -moz-border-radius-topleft: 3px; -moz-border-radius-topright: 3px; -webkit-border-top-right-radius: 5px; -webkit-border-top-left-radius: 5px;">
<h1 style="color: #333333; font: bold 22px Arial, Helvetica, sans-serif; margin: 0; display: block !important;">
<!-- To have a header image/logo replace the name below with your img tag -->
<!-- Email clients will render the images when the message is read so any image -->
<!-- must be made available on a public server, so that all recipients can load the image. -->
<a href="http://community.jboss.org/index.jspa" style="text-decoration: none; color: #E1E1E1">JBoss Community</a></h1>
</td>
</tr>
<tr>
<td bgcolor="#FFFFFF" style="font: normal 12px Arial, Helvetica, sans-serif; color:#333333; padding: 20px; -moz-border-radius-bottomleft: 4px; -moz-border-radius-bottomright: 4px; -webkit-border-bottom-right-radius: 5px; -webkit-border-bottom-left-radius: 5px;"><h3 style="margin: 10px 0 5px; font-size: 17px; font-weight: normal;">
Oracle XA datasource with oci driver
</h3>
<span style="margin-bottom: 10px;">
created by <a href="http://community.jboss.org/people/raizcor">raizcor raizcor</a> in <i>Datasource Configuration</i> - <a href="http://community.jboss.org/message/598046#598046">View the full discussion</a>
</span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">
<div class="jive-rendered-content"><p>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.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>I've resolved some problems but now I'm getting the following exception:</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>.</p><p>.</p><p>.</p><p>20:57:53,520 INFO  <a class="" href="http://community.jboss.org/message/598046#598046">Oracle XA datasource with oci driver</a> JNDI InitialContext properties:{}</p><p>20:57:54,017 WARN  <a class="" href="http://community.jboss.org/message/598046#598046">Oracle XA datasource with oci driver</a> 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]</p><p>oracle.jdbc.xa.OracleXAException</p><p>    at oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java:938)</p><p>    at oracle.jdbc.xa.client.OracleXAResource.start(OracleXAResource.java:244)</p><p>    at org.jboss.resource.adapter.jdbc.xa.XAManagedConnection.start(XAManagedConnection.java:213)</p><p>    at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.enlistResource(TransactionImple.java:799)</p><p>    at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.enlistResource(TransactionImple.java:510)</p><p>    at org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener$TransactionSynchronization.enlist(TxConnectionManager.java:908)</p><p>    at org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener.enlist(TxConnectionManager.java:662)</p><p>    at org.jboss.resource.connectionmanager.TxConnectionManager.managedConnectionReconnected(TxConnectionManager.java:403)</p><p>    at org.jboss.resource.connectionmanager.BaseConnectionManager2.reconnectManagedConnection(BaseConnectionManager2.java:625)</p><p>    at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:499)</p><p>    at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:941)</p><p>    at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:89)</p><p>    at org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:92)</p><p>    at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)</p><p>    at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)</p><p>    at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)</p><p>    at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1573)</p><p>    at org.hibernate.loader.Loader.doQuery(Loader.java:696)</p><p>    at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)</p><p>    at org.hibernate.loader.Loader.doList(Loader.java:2228)</p><p>    at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2125)</p><p>    at org.hibernate.loader.Loader.list(Loader.java:2120)</p><p>    at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:118)</p><p>    at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1596)</p><p>    at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:306)</p><p>.</p><p>.</p><p>.</p><p>20:57:54,024 ERROR <a class="" href="http://community.jboss.org/message/598046#598046">Oracle XA datasource with oci driver</a> java.lang.IllegalMonitorStateException</p><p>20:57:54,024 ERROR <a class="" href="http://community.jboss.org/message/598046#598046">Oracle XA datasource with oci driver</a>     at java.util.concurrent.locks.ReentrantLock$Sync.tryRelease(ReentrantLock.java:127)</p><p>20:57:54,025 ERROR <a class="" href="http://community.jboss.org/message/598046#598046">Oracle XA datasource with oci driver</a>     at java.util.concurrent.locks.AbstractQueuedSynchronizer.release(AbstractQueuedSynchronizer.java:1175)</p><p>20:57:54,025 ERROR <a class="" href="http://community.jboss.org/message/598046#598046">Oracle XA datasource with oci driver</a>     at java.util.concurrent.locks.ReentrantLock.unlock(ReentrantLock.java:431)</p><p>20:57:54,025 ERROR <a class="" href="http://community.jboss.org/message/598046#598046">Oracle XA datasource with oci driver</a>     at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.unlock(BaseWrapperManagedConnection.java:277)</p><p>20:57:54,025 ERROR <a class="" href="http://community.jboss.org/message/598046#598046">Oracle XA datasource with oci driver</a>     at org.jboss.resource.adapter.jdbc.xa.XAManagedConnection.start(XAManagedConnection.java:235)</p><p>20:57:54,025 ERROR <a class="" href="http://community.jboss.org/message/598046#598046">Oracle XA datasource with oci driver</a>     at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.enlistResource(TransactionImple.java:799)</p><p>20:57:54,025 ERROR <a class="" href="http://community.jboss.org/message/598046#598046">Oracle XA datasource with oci driver</a>     at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.enlistResource(TransactionImple.java:510)</p><p>20:57:54,025 ERROR <a class="" href="http://community.jboss.org/message/598046#598046">Oracle XA datasource with oci driver</a>     at org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener$TransactionSynchronization.enlist(TxConnectionManager.java:908)</p><p>20:57:54,025 ERROR <a class="" href="http://community.jboss.org/message/598046#598046">Oracle XA datasource with oci driver</a>     at org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener.enlist(TxConnectionManager.java:662)</p><p>20:57:54,025 ERROR <a class="" href="http://community.jboss.org/message/598046#598046">Oracle XA datasource with oci driver</a>     at org.jboss.resource.connectionmanager.TxConnectionManager.managedConnectionReconnected(TxConnectionManager.java:403)</p><p>20:57:54,025 ERROR <a class="" href="http://community.jboss.org/message/598046#598046">Oracle XA datasource with oci driver</a>     at org.jboss.resource.connectionmanager.BaseConnectionManager2.reconnectManagedConnection(BaseConnectionManager2.java:625)</p><p>20:57:54,025 ERROR <a class="" href="http://community.jboss.org/message/598046#598046">Oracle XA datasource with oci driver</a>     at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:499)</p><p>20:57:54,025 ERROR <a class="" href="http://community.jboss.org/message/598046#598046">Oracle XA datasource with oci driver</a>     at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:941)</p><p>20:57:54,025 ERROR <a class="" href="http://community.jboss.org/message/598046#598046">Oracle XA datasource with oci driver</a>     at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:89)</p><p>20:57:54,031 ERROR <a class="" href="http://community.jboss.org/message/598046#598046">Oracle XA datasource with oci driver</a>     at org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:92)</p><p>20:57:54,031 ERROR <a class="" href="http://community.jboss.org/message/598046#598046">Oracle XA datasource with oci driver</a>     at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)</p><p>20:57:54,031 ERROR <a class="" href="http://community.jboss.org/message/598046#598046">Oracle XA datasource with oci driver</a>     at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)</p><p>20:57:54,031 ERROR <a class="" href="http://community.jboss.org/message/598046#598046">Oracle XA datasource with oci driver</a>     at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)</p><p>20:57:54,031 ERROR <a class="" href="http://community.jboss.org/message/598046#598046">Oracle XA datasource with oci driver</a>     at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1573)</p><p>20:57:54,031 ERROR <a class="" href="http://community.jboss.org/message/598046#598046">Oracle XA datasource with oci driver</a>     at org.hibernate.loader.Loader.doQuery(Loader.java:696)</p><p>20:57:54,031 ERROR <a class="" href="http://community.jboss.org/message/598046#598046">Oracle XA datasource with oci driver</a>     at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)</p><p>20:57:54,031 ERROR <a class="" href="http://community.jboss.org/message/598046#598046">Oracle XA datasource with oci driver</a>     at org.hibernate.loader.Loader.doList(Loader.java:2228)</p><p>20:57:54,032 ERROR <a class="" href="http://community.jboss.org/message/598046#598046">Oracle XA datasource with oci driver</a>     at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2125)</p><p>20:57:54,032 ERROR <a class="" href="http://community.jboss.org/message/598046#598046">Oracle XA datasource with oci driver</a>     at org.hibernate.loader.Loader.list(Loader.java:2120)</p><p>20:57:54,032 ERROR <a class="" href="http://community.jboss.org/message/598046#598046">Oracle XA datasource with oci driver</a>     at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:118)</p><p>20:57:54,032 ERROR <a class="" href="http://community.jboss.org/message/598046#598046">Oracle XA datasource with oci driver</a>     at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1596)</p><p>20:57:54,032 ERROR <a class="" href="http://community.jboss.org/message/598046#598046">Oracle XA datasource with oci driver</a>     at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:306)</p><p>.</p><p>.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>20:57:54,129 WARN  <a class="" href="http://community.jboss.org/message/598046#598046">Oracle XA datasource with oci driver</a> SQL Error: 0, SQLState: null</p><p>20:57:54,129 ERROR <a class="" href="http://community.jboss.org/message/598046#598046">Oracle XA datasource with oci driver</a> 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 &lt; ac, BasicAction: a040d3d:96b5:4d9bc88b:6b status: ActionStatus.ABORT_ONLY &gt;); - 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 &lt; ac, BasicAction: a040d3d:96b5:4d9bc88b:6b status: ActionStatus.ABORT_ONLY &gt;))</p><p>20:57:54,135 WARN  <a class="" href="http://community.jboss.org/message/598046#598046">Oracle XA datasource with oci driver</a> SQL Error: 0, SQLState: null</p><p>20:57:54,135 ERROR <a class="" href="http://community.jboss.org/message/598046#598046">Oracle XA datasource with oci driver</a> Transaction is not active: tx=TransactionImple &lt; ac, BasicAction: a040d3d:96b5:4d9bc88b:6b status: ActionStatus.ABORT_ONLY &gt;; - nested throwable: (javax.resource.ResourceException: Transaction is not active: tx=TransactionImple &lt; ac, BasicAction: a040d3d:96b5:4d9bc88b:6b status: ActionStatus.ABORT_ONLY &gt;)</p><p>.</p><p>.</p><p>.</p><p>20:57:54,146 ERROR <a class="" href="http://community.jboss.org/message/598046#598046">Oracle XA datasource with oci driver</a> Caused by: org.hibernate.exception.GenericJDBCException: Cannot open connection</p><p>20:57:54,146 ERROR <a class="" href="http://community.jboss.org/message/598046#598046">Oracle XA datasource with oci driver</a>     at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:126)</p><p>20:57:54,146 ERROR <a class="" href="http://community.jboss.org/message/598046#598046">Oracle XA datasource with oci driver</a>     at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:114)</p><p>20:57:54,146 ERROR <a class="" href="http://community.jboss.org/message/598046#598046">Oracle XA datasource with oci driver</a>     at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)</p><p>20:57:54,146 ERROR <a class="" href="http://community.jboss.org/message/598046#598046">Oracle XA datasource with oci driver</a>     at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:52)</p><p>20:57:54,146 ERROR <a class="" href="http://community.jboss.org/message/598046#598046">Oracle XA datasource with oci driver</a>     at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:449)</p><p>20:57:54,146 ERROR <a class="" href="http://community.jboss.org/message/598046#598046">Oracle XA datasource with oci driver</a>     at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)</p><p>20:57:54,146 ERROR <a class="" href="http://community.jboss.org/message/598046#598046">Oracle XA datasource with oci driver</a>     at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)</p><p>20:57:54,146 ERROR <a class="" href="http://community.jboss.org/message/598046#598046">Oracle XA datasource with oci driver</a>     at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1573)</p><p>20:57:54,146 ERROR <a class="" href="http://community.jboss.org/message/598046#598046">Oracle XA datasource with oci driver</a>     at org.hibernate.loader.Loader.doQuery(Loader.java:696)</p><p>20:57:54,146 ERROR <a class="" href="http://community.jboss.org/message/598046#598046">Oracle XA datasource with oci driver</a>     at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)</p><p>20:57:54,146 ERROR <a class="" href="http://community.jboss.org/message/598046#598046">Oracle XA datasource with oci driver</a>     at org.hibernate.loader.Loader.doList(Loader.java:2228)</p><p>20:57:54,146 ERROR <a class="" href="http://community.jboss.org/message/598046#598046">Oracle XA datasource with oci driver</a>     at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2125)</p><p>20:57:54,146 ERROR <a class="" href="http://community.jboss.org/message/598046#598046">Oracle XA datasource with oci driver</a>     at org.hibernate.loader.Loader.list(Loader.java:2120)</p><p>20:57:54,146 ERROR <a class="" href="http://community.jboss.org/message/598046#598046">Oracle XA datasource with oci driver</a>     at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:118)</p><p>20:57:54,146 ERROR <a class="" href="http://community.jboss.org/message/598046#598046">Oracle XA datasource with oci driver</a>     at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1596)</p><p>20:57:54,146 ERROR <a class="" href="http://community.jboss.org/message/598046#598046">Oracle XA datasource with oci driver</a>     at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:306)</p><p>.</p><p>.</p><p>.</p><p>20:57:54,147 ERROR <a class="" href="http://community.jboss.org/message/598046#598046">Oracle XA datasource with oci driver</a> Caused by: org.jboss.util.NestedSQLException: Transaction is not active: tx=TransactionImple &lt; ac, BasicAction: a040d3d:96b5:4d9bc88b:6b status: ActionStatus.ABORT_ONLY &gt;; - nested throwable: (javax.resource.ResourceException: Transaction is not active: tx=TransactionImple &lt; ac, BasicAction: a040d3d:96b5:4d9bc88b:6b status: ActionStatus.ABORT_ONLY &gt;)</p><p>20:57:54,147 ERROR <a class="" href="http://community.jboss.org/message/598046#598046">Oracle XA datasource with oci driver</a>     at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:95)</p><p>20:57:54,147 ERROR <a class="" href="http://community.jboss.org/message/598046#598046">Oracle XA datasource with oci driver</a>     at org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:92)</p><p>20:57:54,147 ERROR <a class="" href="http://community.jboss.org/message/598046#598046">Oracle XA datasource with oci driver</a>     at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)</p><p>20:57:54,147 ERROR <a class="" href="http://community.jboss.org/message/598046#598046">Oracle XA datasource with oci driver</a>     ... 151 more</p><p>20:57:54,147 ERROR <a class="" href="http://community.jboss.org/message/598046#598046">Oracle XA datasource with oci driver</a> Caused by: javax.resource.ResourceException: Transaction is not active: tx=TransactionImple &lt; ac, BasicAction: a040d3d:96b5:4d9bc88b:6b status: ActionStatus.ABORT_ONLY &gt; </p><p>20:57:54,148 ERROR <a class="" href="http://community.jboss.org/message/598046#598046">Oracle XA datasource with oci driver</a>     at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:370)</p><p>20:57:54,148 ERROR <a class="" href="http://community.jboss.org/message/598046#598046">Oracle XA datasource with oci driver</a>     at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:496)</p><p>20:57:54,148 ERROR <a class="" href="http://community.jboss.org/message/598046#598046">Oracle XA datasource with oci driver</a>     at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:941)</p><p>20:57:54,148 ERROR <a class="" href="http://community.jboss.org/message/598046#598046">Oracle XA datasource with oci driver</a>     at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:89)</p><p>.</p><p>.</p><p>.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>What i've already done is add the <strong>oracle_env.sh</strong> script provided by the oracle installation which added the following environment variables:</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server</p><p>ORACLE_SID=XE</p><p>NLS_LANG=`$ORACLE_HOME/bin/nls_lang.sh`</p><p>PATH=$ORACLE_HOME/bin:$PATH</p><p>LD_LIBRARY_PATH=$ORACLE_HOME/lib</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>That resolved a previous problem where a native library cannot be found in the 'java.library.path'.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Another thing I've done is configure a <code><span class="codeinlineitalic">TNS service name in my tnsnames.ora file located in my home directory, which don't need before using the oci driver.</span></code></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><span class="codeinlineitalic">I'm working with:</span></p><p>Oracle 10g XE Release 10.2.0.1.0</p><p>JBoss AS 5.1.0.GA</p><p><span class="codeinlineitalic"><br/></span></p><p>Any help will be appreciated</p></div>
<div style="background-color: #f4f4f4; padding: 10px; margin-top: 20px;">
<p style="margin: 0;">Reply to this message by <a href="http://community.jboss.org/message/598046#598046">going to Community</a></p>
<p style="margin: 0;">Start a new discussion in Datasource Configuration at <a href="http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2077">Community</a></p>
</div></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>