Yeah - it works in terms of being able to create the connection - but there
are probs when using the connection from a bean when we use
oracle.jdbc.xa.client.OracleXADataSource - so we wanted to use minerva for
now until it was resovled.
BTW - here is the error when using oracle.jdbc.xa.client.OracleXADataSource
. This happens when calling an entity bean. It only started after going to
Oracle 8.1.7 on Linux - was OK with 8.1.6 on Linux:
[Member] java.sql.SQLException: ORA-06550: line 1, column 14:
PLS-00201: identifier 'JAVA_XA.XA_START' must be declared
ORA-06550: line 1, column 8:
PL/SQL: Statement ignored
[Member] at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:1
14)
[Member] at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
[Member] at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:542)
[Member] at
oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1311)
[Member] at
oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.
java:738)
[Member] at
oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStat
ement.java:1313)
[Member] at
oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleState
ment.java:1232)
[Member] at
oracle.jdbc.driver.OracleStatement.doExecuteWithBatch(OracleS
tatement.java:1353)
[Member] at
oracle.jdbc.driver.OracleStatement.doExecute(OracleStatement.
java:1760)
[Member] at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(Oracl
eStatement.java:1805)
[Member] at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(Orac
lePreparedStatement.java:322)
[Member] at
oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePrep
aredStatement.java:366)
[Member] at
oracle.jdbc.xa.client.OracleXAResource.start(OracleXAResource
.java:102)
[Member] at
org.jboss.tm.TxCapsule.startResource(TxCapsule.java:1097)
[Member] at
org.jboss.tm.TxCapsule.enlistResource(TxCapsule.java:624)
[Member] at
org.jboss.tm.TransactionImpl.enlistResource(TransactionImpl.j
ava:111)
[Member] at
org.opentools.minerva.jdbc.xa.XAConnectionFactory.prepareObje
ct(XAConnectionFactory.java:269)
[Member] at
org.opentools.minerva.pool.ObjectPool.getObject(ObjectPool.ja
va:548)
[Member] at
org.opentools.minerva.pool.ObjectPool.getObject(ObjectPool.ja
va:521)
[Member] at
org.opentools.minerva.jdbc.xa.XAPoolDataSource.getConnection(
XAPoolDataSource.java:165)
[Member] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.getConnection(JDB
CCommand.java:674)
[Member] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.jdbcExecute(JDBCC
ommand.java:151)
[Member] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCFinderCommand.execute(JDB
CFinderCommand.java:60)
[Member] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCFindEntitiesCommand.execu
te(JDBCFindEntitiesCommand.java:145)
[Member] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCFindEntityCommand.execute
(JDBCFindEntityCommand.java:64)
[Member] at
org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.findEntity(
JAWSPersistenceManager.java:130)
[Member] at
org.jboss.ejb.plugins.CMPPersistenceManager.findEntity(CMPPer
sistenceManager.java:257)
[Member] at
org.jboss.ejb.EntityContainer.find(EntityContainer.java:419)
[Member] at java.lang.reflect.Method.invoke(Native Method)
[Member] at
org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome
(EntityContainer.java:639)
[Member] at
org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invoke
Home(EntitySynchronizationInterceptor.java:160)
[Member] at
org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(En
tityInstanceInterceptor.java:87)
[Member] at
org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxIntercept
orCMT.java:135)
[Member] at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(Tx
InterceptorCMT.java:264)
[Member] at
org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxIntercept
orCMT.java:86)
[Member] at
org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(Security
Interceptor.java:119)
[Member] at
org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogIntercepto
r.java:106)
[Member] at
org.jboss.ejb.EntityContainer.invokeHome(EntityContainer.java
:316)
[Member] at
org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invoke
Home(JRMPContainerInvoker.java:358)
[Member] at
org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invoke
Home(JRMPContainerInvoker.java:412)
[Member] at
org.jboss.ejb.plugins.jrmp.interfaces.HomeProxy.invoke(HomePr
oxy.java:198)
[Member] at $Proxy3.findByEmailAddress(Unknown Source)
[Member] at
com.newnetco.tradeim.hwd.servlets.AddUserServlet.handleReques
t(AddUserServlet.java:139)
[Member] at
com.newnetco.tradeim.hwd.servlets.TradeIMServlet.handleReques
t(TradeIMServlet.java:81)
[Member] at
org.apache.velocity.servlet.VelocityServlet.doRequest(Velocit
yServlet.java:320)
[Member] at
org.apache.velocity.servlet.VelocityServlet.doPost(VelocitySe
rvlet.java:290)
[Member] at
javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
[Member] at
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
[Member] at
org.apache.tomcat.core.ServletWrapper.doService(ServletWrappe
r.java:404)
[Member] at org.apache.tomcat.core.Handler.service(Handler.java:286)
[Member] at
org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.
java:372)
[Member] at
org.apache.tomcat.core.ContextManager.internalService(Context
Manager.java:797)
[Member] at
org.apache.tomcat.core.ContextManager.service(ContextManager.
java:743)
[Member] at
org.apache.tomcat.service.http.HttpConnectionHandler.processC
onnection(HttpConnectionHandler.java:210)
[Member] at
org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoi
nt.java:416)
[Member] at
org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadP
ool.java:498)
[Member] at java.lang.Thread.run(Thread.java:484)
[Member] XAException: tx=XidImpl [FormatId=257, GlobalId=LEX2K//0,
BranchQual=]
errorCode=XAER_RMERR
[Member] oracle.jdbc.xa.OracleXAException
[Member] at
oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.j
ava:467)
[Member] at
oracle.jdbc.xa.client.OracleXAResource.start(OracleXAResource
.java:122)
[Member] at
org.jboss.tm.TxCapsule.startResource(TxCapsule.java:1097)
[Member] at
org.jboss.tm.TxCapsule.enlistResource(TxCapsule.java:624)
[Member] at
org.jboss.tm.TransactionImpl.enlistResource(TransactionImpl.j
ava:111)
[Member] at
org.opentools.minerva.jdbc.xa.XAConnectionFactory.prepareObje
ct(XAConnectionFactory.java:269)
[Member] at
org.opentools.minerva.pool.ObjectPool.getObject(ObjectPool.ja
va:548)
[Member] at
org.opentools.minerva.pool.ObjectPool.getObject(ObjectPool.ja
va:521)
[Member] at
org.opentools.minerva.jdbc.xa.XAPoolDataSource.getConnection(
XAPoolDataSource.java:165)
[Member] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.getConnection(JDB
CCommand.java:674)
[Member] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.jdbcExecute(JDBCC
ommand.java:151)
[Member] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCFinderCommand.execute(JDB
CFinderCommand.java:60)
[Member] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCFindEntitiesCommand.execu
te(JDBCFindEntitiesCommand.java:145)
[Member] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCFindEntityCommand.execute
(JDBCFindEntityCommand.java:64)
[Member] at
org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.findEntity(
JAWSPersistenceManager.java:130)
[Member] at
org.jboss.ejb.plugins.CMPPersistenceManager.findEntity(CMPPer
sistenceManager.java:257)
[Member] at
org.jboss.ejb.EntityContainer.find(EntityContainer.java:419)
[Member] at java.lang.reflect.Method.invoke(Native Method)
[Member] at
org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome
(EntityContainer.java:639)
[Member] at
org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invoke
Home(EntitySynchronizationInterceptor.java:160)
[Member] at
org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(En
tityInstanceInterceptor.java:87)
[Member] at
org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxIntercept
orCMT.java:135)
[Member] at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(Tx
InterceptorCMT.java:264)
[Member] at
org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxIntercept
orCMT.java:86)
[Member] at
org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(Security
Interceptor.java:119)
[Member] at
org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogIntercepto
r.java:106)
[Member] at
org.jboss.ejb.EntityContainer.invokeHome(EntityContainer.java
:316)
[Member] at
org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invoke
Home(JRMPContainerInvoker.java:358)
[Member] at
org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invoke
Home(JRMPContainerInvoker.java:412)
[Member] at
org.jboss.ejb.plugins.jrmp.interfaces.HomeProxy.invoke(HomePr
oxy.java:198)
[Member] at $Proxy3.findByEmailAddress(Unknown Source)
[Member] at
com.newnetco.tradeim.hwd.servlets.AddUserServlet.handleReques
t(AddUserServlet.java:139)
[Member] at
com.newnetco.tradeim.hwd.servlets.TradeIMServlet.handleReques
t(TradeIMServlet.java:81)
[Member] at
org.apache.velocity.servlet.VelocityServlet.doRequest(Velocit
yServlet.java:320)
[Member] at
org.apache.velocity.servlet.VelocityServlet.doPost(VelocitySe
rvlet.java:290)
[Member] at
javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
[Member] at
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
[Member] at
org.apache.tomcat.core.ServletWrapper.doService(ServletWrappe
r.java:404)
[Member] at org.apache.tomcat.core.Handler.service(Handler.java:286)
[Member] at
org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.
java:372)
[Member] at
org.apache.tomcat.core.ContextManager.internalService(Context
Manager.java:797)
[Member] at
org.apache.tomcat.core.ContextManager.service(ContextManager.
java:743)
[Member] at
org.apache.tomcat.service.http.HttpConnectionHandler.processC
onnection(HttpConnectionHandler.java:210)
[Member] at
org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoi
nt.java:416)
[Member] at
org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadP
ool.java:498)
[Member] at java.lang.Thread.run(Thread.java:484)
[Member] java.sql.SQLException: ORA-06550: line 1, column 14:
PLS-00201: identifier 'JAVA_XA.XA_END' must be declared
ORA-06550: line 1, column 8:
PL/SQL: Statement ignored
[Member] at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:1
14)
[Member] at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
[Member] at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:542)
[Member] at
oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1311)
[Member] at
oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.
java:738)
[Member] at
oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStat
ement.java:1313)
[Member] at
oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleState
ment.java:1232)
[Member] at
oracle.jdbc.driver.OracleStatement.doExecuteWithBatch(OracleS
tatement.java:1353)
[Member] at
oracle.jdbc.driver.OracleStatement.doExecute(OracleStatement.
java:1760)
[Member] at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(Oracl
eStatement.java:1805)
[Member] at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(Orac
lePreparedStatement.java:322)
[Member] at
oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePrep
aredStatement.java:366)
[Member] at
oracle.jdbc.xa.client.OracleXAResource.end(OracleXAResource.j
ava:175)
[Member] at org.jboss.tm.TxCapsule.endResource(TxCapsule.java:1139)
[Member] at
org.jboss.tm.TxCapsule.delistResource(TxCapsule.java:533)
[Member] at
org.jboss.tm.TransactionImpl.delistResource(TransactionImpl.j
ava:99)
[Member] at
org.opentools.minerva.jdbc.xa.XAConnectionFactory$2.closeConn
ection(XAConnectionFactory.java:97)
[Member] at
org.opentools.minerva.jdbc.xa.XAConnectionFactory$2.connectio
nClosed(XAConnectionFactory.java:82)
[Member] at
oracle.jdbc.pool.OraclePooledConnection.callListener(OraclePo
oledConnection.java:240)
[Member] at
oracle.jdbc.pool.OraclePooledConnection.logicalClose(OraclePo
oledConnection.java:214)
[Member] at
oracle.jdbc.driver.OracleConnection.logicalClose(OracleConnec
tion.java:1587)
[Member] at
oracle.jdbc.driver.OracleConnection.close(OracleConnection.ja
va:542)
[Member] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.jdbcExecute(JDBCC
ommand.java:179)
[Member] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCFinderCommand.execute(JDB
CFinderCommand.java:60)
[Member] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCFindEntitiesCommand.execu
te(JDBCFindEntitiesCommand.java:145)
[Member] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCFindEntityCommand.execute
(JDBCFindEntityCommand.java:64)
[Member] at
org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.findEntity(
JAWSPersistenceManager.java:130)
[Member] at
org.jboss.ejb.plugins.CMPPersistenceManager.findEntity(CMPPer
sistenceManager.java:257)
[Member] at
org.jboss.ejb.EntityContainer.find(EntityContainer.java:419)
[Member] at java.lang.reflect.Method.invoke(Native Method)
[Member] at
org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome
(EntityContainer.java:639)
[Member] at
org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invoke
Home(EntitySynchronizationInterceptor.java:160)
[Member] at
org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(En
tityInstanceInterceptor.java:87)
[Member] at
org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxIntercept
orCMT.java:135)
[Member] at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(Tx
InterceptorCMT.java:264)
[Member] at
org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxIntercept
orCMT.java:86)
[Member] at
org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(Security
Interceptor.java:119)
[Member] at
org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogIntercepto
r.java:106)
[Member] at
org.jboss.ejb.EntityContainer.invokeHome(EntityContainer.java
:316)
[Member] at
org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invoke
Home(JRMPContainerInvoker.java:358)
[Member] at
org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invoke
Home(JRMPContainerInvoker.java:412)
[Member] at
org.jboss.ejb.plugins.jrmp.interfaces.HomeProxy.invoke(HomePr
oxy.java:198)
[Member] at $Proxy3.findByEmailAddress(Unknown Source)
[Member] at
com.newnetco.tradeim.hwd.servlets.AddUserServlet.handleReques
t(AddUserServlet.java:139)
[Member] at
com.newnetco.tradeim.hwd.servlets.TradeIMServlet.handleReques
t(TradeIMServlet.java:81)
[Member] at
org.apache.velocity.servlet.VelocityServlet.doRequest(Velocit
yServlet.java:320)
[Member] at
org.apache.velocity.servlet.VelocityServlet.doPost(VelocitySe
rvlet.java:290)
[Member] at
javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
[Member] at
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
[Member] at
org.apache.tomcat.core.ServletWrapper.doService(ServletWrappe
r.java:404)
[Member] at org.apache.tomcat.core.Handler.service(Handler.java:286)
[Member] at
org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.
java:372)
[Member] at
org.apache.tomcat.core.ContextManager.internalService(Context
Manager.java:797)
[Member] at
org.apache.tomcat.core.ContextManager.service(ContextManager.
java:743)
[Member] at
org.apache.tomcat.service.http.HttpConnectionHandler.processC
onnection(HttpConnectionHandler.java:210)
[Member] at
org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoi
nt.java:416)
[Member] at
org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadP
ool.java:498)
[Member] at java.lang.Thread.run(Thread.java:484)
[Member] XAException: tx=XidImpl [FormatId=257, GlobalId=LEX2K//0,
BranchQual=]
errorCode=XAER_RMERR
[Member] oracle.jdbc.xa.OracleXAException
[Member] at
oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.j
ava:467)
[Member] at
oracle.jdbc.xa.client.OracleXAResource.end(OracleXAResource.j
ava:194)
[Member] at org.jboss.tm.TxCapsule.endResource(TxCapsule.java:1139)
[Member] at
org.jboss.tm.TxCapsule.delistResource(TxCapsule.java:533)
[Member] at
org.jboss.tm.TransactionImpl.delistResource(TransactionImpl.j
ava:99)
[Member] at
org.opentools.minerva.jdbc.xa.XAConnectionFactory$2.closeConn
ection(XAConnectionFactory.java:97)
[Member] at
org.opentools.minerva.jdbc.xa.XAConnectionFactory$2.connectio
nClosed(XAConnectionFactory.java:82)
[Member] at
oracle.jdbc.pool.OraclePooledConnection.callListener(OraclePo
oledConnection.java:240)
[Member] at
oracle.jdbc.pool.OraclePooledConnection.logicalClose(OraclePo
oledConnection.java:214)
[Member] at
oracle.jdbc.driver.OracleConnection.logicalClose(OracleConnec
tion.java:1587)
[Member] at
oracle.jdbc.driver.OracleConnection.close(OracleConnection.ja
va:542)
[Member] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.jdbcExecute(JDBCC
ommand.java:179)
[Member] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCFinderCommand.execute(JDB
CFinderCommand.java:60)
[Member] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCFindEntitiesCommand.execu
te(JDBCFindEntitiesCommand.java:145)
[Member] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCFindEntityCommand.execute
(JDBCFindEntityCommand.java:64)
[Member] at
org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.findEntity(
JAWSPersistenceManager.java:130)
[Member] at
org.jboss.ejb.plugins.CMPPersistenceManager.findEntity(CMPPer
sistenceManager.java:257)
[Member] at
org.jboss.ejb.EntityContainer.find(EntityContainer.java:419)
[Member] at java.lang.reflect.Method.invoke(Native Method)
[Member] at
org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome
(EntityContainer.java:639)
[Member] at
org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invoke
Home(EntitySynchronizationInterceptor.java:160)
[Member] at
org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(En
tityInstanceInterceptor.java:87)
[Member] at
org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxIntercept
orCMT.java:135)
[Member] at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(Tx
InterceptorCMT.java:264)
[Member] at
org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxIntercept
orCMT.java:86)
[Member] at
org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(Security
Interceptor.java:119)
[Member] at
org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogIntercepto
r.java:106)
[Member] at
org.jboss.ejb.EntityContainer.invokeHome(EntityContainer.java
:316)
[Member] at
org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invoke
Home(JRMPContainerInvoker.java:358)
[Member] at
org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invoke
Home(JRMPContainerInvoker.java:412)
[Member] at
org.jboss.ejb.plugins.jrmp.interfaces.HomeProxy.invoke(HomePr
oxy.java:198)
[Member] at $Proxy3.findByEmailAddress(Unknown Source)
[Member] at
com.newnetco.tradeim.hwd.servlets.AddUserServlet.handleReques
t(AddUserServlet.java:139)
[Member] at
com.newnetco.tradeim.hwd.servlets.TradeIMServlet.handleReques
t(TradeIMServlet.java:81)
[Member] at
org.apache.velocity.servlet.VelocityServlet.doRequest(Velocit
yServlet.java:320)
[Member] at
org.apache.velocity.servlet.VelocityServlet.doPost(VelocitySe
rvlet.java:290)
[Member] at
javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
[Member] at
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
[Member] at
org.apache.tomcat.core.ServletWrapper.doService(ServletWrappe
r.java:404)
[Member] at org.apache.tomcat.core.Handler.service(Handler.java:286)
[Member] at
org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.
java:372)
[Member] at
org.apache.tomcat.core.ContextManager.internalService(Context
Manager.java:797)
[Member] at
org.apache.tomcat.core.ContextManager.service(ContextManager.
java:743)
[Member] at
org.apache.tomcat.service.http.HttpConnectionHandler.processC
onnection(HttpConnectionHandler.java:210)
[Member] at
org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoi
nt.java:416)
[Member] at
org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadP
ool.java:498)
[Member] at java.lang.Thread.run(Thread.java:484)
[Member] java.sql.SQLException: ORA-06550: line 1, column 14:
PLS-00201: identifier 'JAVA_XA.XA_ROLLBACK' must be declared
ORA-06550: line 1, column 8:
PL/SQL: Statement ignored
[Member] at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:1
14)
[Member] at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
[Member] at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:542)
[Member] at
oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1311)
[Member] at
oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.
java:738)
[Member] at
oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStat
ement.java:1313)
[Member] at
oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleState
ment.java:1232)
[Member] at
oracle.jdbc.driver.OracleStatement.doExecuteWithBatch(OracleS
tatement.java:1353)
[Member] at
oracle.jdbc.driver.OracleStatement.doExecute(OracleStatement.
java:1760)
[Member] at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(Oracl
eStatement.java:1805)
[Member] at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(Orac
lePreparedStatement.java:322)
[Member] at
oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePrep
aredStatement.java:366)
[Member] at
oracle.jdbc.xa.client.OracleXAResource.rollback(OracleXAResou
rce.java:416)
[Member] at
org.jboss.tm.TxCapsule.rollbackResources(TxCapsule.java:1552)
[Member] at org.jboss.tm.TxCapsule.rollback(TxCapsule.java:408)
[Member] at
org.jboss.tm.TransactionImpl.rollback(TransactionImpl.java:88
)
[Member] at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(Tx
InterceptorCMT.java:308)
[Member] at
org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxIntercept
orCMT.java:86)
[Member] at
org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(Security
Interceptor.java:119)
[Member] at
org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogIntercepto
r.java:106)
[Member] at
org.jboss.ejb.EntityContainer.invokeHome(EntityContainer.java
:316)
[Member] at
org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invoke
Home(JRMPContainerInvoker.java:358)
[Member] at
org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invoke
Home(JRMPContainerInvoker.java:412)
[Member] at
org.jboss.ejb.plugins.jrmp.interfaces.HomeProxy.invoke(HomePr
oxy.java:198)
[Member] at $Proxy3.findByEmailAddress(Unknown Source)
[Member] at
com.newnetco.tradeim.hwd.servlets.AddUserServlet.handleReques
t(AddUserServlet.java:139)
[Member] at
com.newnetco.tradeim.hwd.servlets.TradeIMServlet.handleReques
t(TradeIMServlet.java:81)
[Member] at
org.apache.velocity.servlet.VelocityServlet.doRequest(Velocit
yServlet.java:320)
[Member] at
org.apache.velocity.servlet.VelocityServlet.doPost(VelocitySe
rvlet.java:290)
[Member] at
javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
[Member] at
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
[Member] at
org.apache.tomcat.core.ServletWrapper.doService(ServletWrappe
r.java:404)
[Member] at org.apache.tomcat.core.Handler.service(Handler.java:286)
[Member] at
org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.
java:372)
[Member] at
org.apache.tomcat.core.ContextManager.internalService(Context
Manager.java:797)
[Member] at
org.apache.tomcat.core.ContextManager.service(ContextManager.
java:743)
[Member] at
org.apache.tomcat.service.http.HttpConnectionHandler.processC
onnection(HttpConnectionHandler.java:210)
[Member] at
org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoi
nt.java:416)
[Member] at
org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadP
ool.java:498)
[Member] at java.lang.Thread.run(Thread.java:484)
Shahar Solomianik
<[EMAIL PROTECTED] To: 'JBoss-User'
<[EMAIL PROTECTED]>
om> cc:
Sent by: Subject: RE: [jBoss-User]
Using minerva Drivers with JBoss 2.1
<[EMAIL PROTECTED]
-dogs.com>
03/15/2001 01:09 PM
Please respond to
"JBoss-User"
but if you use only one pool with oracle.jdbc.xa.client.OracleXADataSource
(without minerva) , does it work ?
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of [EMAIL PROTECTED]
Sent: Thursday, March 15, 2001 7:35 PM
To: [EMAIL PROTECTED]
Subject: [jBoss-User] Using minerva Drivers with JBoss 2.1
We have a problem using the oracle.jdbc.xa.client.OracleXADataSource
drivers with Oracle 8.1.7 on Linux (that's another issue) so we have been
using the minerva drivers with JBoss 2.0 without a problem.
I Loaded up JBoss 2.1 and with the following in the jcml file:
<mbean code="org.jboss.jdbc.XADataSourceLoader" name
="DefaultDomain:service=XADataSource,name=TradeDB">
<attribute name="PoolName">TradeDB</attribute>
<attribute name
="DataSourceClass">org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImpl</a
ttribute>
<attribute name="URL">jdbc:oracle:thin:@IP:1521:TRADE</attribute>
<attribute name="JDBCUser">something</attribute>
<attribute name="Password">something</attribute>
</mbean>
I get an error when starting up JBoss (see error at end of this message).
The stratnge thing is that if I creat another connection pool using
oracle.jdbc.xa.client.OracleXADataSource to connect to the same db right
before I create the one using
org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImpl then both
connections work.
In other words the following works:
<mbean code="org.jboss.jdbc.XADataSourceLoader" name
="DefaultDomain:service=XADataSource,name=TestStupidConnection">
<attribute name="PoolName">TestStupidConnection</attribute>
<attribute name
="DataSourceClass">oracle.jdbc.xa.client.OracleXADataSource</attribute>
<attribute name="URL">jdbc:oracle:thin:
@10.1.181.1:1521:TRADEIM</attribute>
<attribute name="JDBCUser">housewares</attribute>
<attribute name="Password">housewares</attribute>
</mbean>
<mbean code="org.jboss.jdbc.XADataSourceLoader" name
="DefaultDomain:service=XADataSource,name=TradeDB">
<attribute name="PoolName">TradeDB</attribute>
<attribute name
="DataSourceClass">org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImpl</a
ttribute>
<attribute name="URL">jdbc:oracle:thin:@IP:1521:TRADE</attribute>
<attribute name="JDBCUser">something</attribute>
<attribute name="Password">something</attribute>
</mbean>
If I remove the TestStupidConnection block the TradeDB one will fail.
Error on startup:
[TradeIMDB] XA Connection pool TradeIMDB bound to java:/TradeIMDB
[TradeIMDB] Stopped
[TradeIMDB] java.lang.NullPointerException
[TradeIMDB] at
org.opentools.minerva.jdbc.xa.XAPoolDataSource.getConnection(
XAPoolDataSource.java:165)
[TradeIMDB] at
org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLo
ader.java:330)
[TradeIMDB] at
org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.
java:93)
[TradeIMDB] at java.lang.reflect.Method.invoke(Native Method)
[TradeIMDB] at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl
.java:1628)
[TradeIMDB] at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl
.java:1523)
[TradeIMDB] at
org.jboss.util.ServiceControl.start(ServiceControl.java:97)
[TradeIMDB] at java.lang.reflect.Method.invoke(Native Method)
[TradeIMDB] at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl
.java:1628)
[TradeIMDB] at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl
.java:1523)
[TradeIMDB] at org.jboss.Main.<init>(Main.java:190)
[TradeIMDB] at org.jboss.Main$1.run(Main.java:94)
[TradeIMDB] at java.security.AccessController.doPrivileged(Native
Method)
[TradeIMDB] at org.jboss.Main.main(Main.java:90)
[Service Control] Could not start
DefaultDomain:service=XADataSource,name=TradeI
MDB
[Service Control] java.lang.NullPointerException
[Service Control] at
org.opentools.minerva.jdbc.xa.XAPoolDataSource.getCon
nection(XAPoolDataSource.java:165)
[Service Control] at
org.jboss.jdbc.XADataSourceLoader.startService(XAData
SourceLoader.java:330)
[Service Control] at
org.jboss.util.ServiceMBeanSupport.start(ServiceMBean
Support.java:93)
[Service Control] at java.lang.reflect.Method.invoke(Native Method)
[Service Control] at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanSe
rverImpl.java:1628)
[Service Control] at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanSe
rverImpl.java:1523)
[Service Control] at
org.jboss.util.ServiceControl.start(ServiceControl.ja
va:97)
[Service Control] at java.lang.reflect.Method.invoke(Native Method)
[Service Control] at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanSe
rverImpl.java:1628)
[Service Control] at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanSe
rverImpl.java:1523)
[Service Control] at org.jboss.Main.<init>(Main.java:190)
[Service Control] at org.jboss.Main$1.run(Main.java:94)
[Service Control] at
java.security.AccessController.doPrivileged(Native Me
thod)
[Service Control] at org.jboss.Main.main(Main.java:90)
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
