Hallo to everybody,
Could anybody help me please
I develop my application on J2EE RI Server. My application works with 4 Oracle databases. So I need for it to declare 4 XADataSources. I use the new driver from Oracle(ojdbc14.jar package). I have declare a XADataSource in resource.config file which looks like:
jdbcXADataSource.5.name=jdbc/EstatDB
jdbcXADataSource.5.classname=oracle.jdbc.xa.client .OracleXADataSource
jdbcXADataSource.5.dbpassword=pass
jdbcXADataSource.5.dbuser=user
jdbcXADataSource.5.prop.URL=jdbc\:oracle\:thin\:@1 29.247.127.3\:1526\:estat
I get exeption using dataSource.getConnection(user, pass). I've tried both application control of dataSource and container controll from dataSource. :(
But each time when trying to get a connection from this datasource I get this exception:
Oracle.jdbc.xa.OracleXAException
At oracle.jdbc.xaOracleXAResource.checkError(OracleXA Resource.java:1157)
At oracle.jdbc.xa.client.OracleXAResource.start(Oracl eXAResource.java:295)
At.com.sun.jtx.jtaTransactionState.startAssociatio n(TransactionState.java:232)
javax.transaction.SystemException
at com.sun.jts.jta.TransactionImpl.enlistResource(Tra nsactionImpl.java:157)
at com.sun.enterprise.distributedtx.J2EETransaction.e nlistResource(J2EETransaction.java:252)
at com.sun.enterprise.distributedtx.J2EETransactionMa nagerImpl.enlistResource(J2EETransactionManagerImp l.java:131)
at com.sun.enterprise.distributedtx.J2EETransactionMa nagerOpt.enlistResource(J2EETransactionManagerOpt. java:87)
at com.sun.enterprise.resource.PoolManagerImpl.regist erResource(PoolManagerImpl.java:147)
at com.sun.enterprise.resource.PoolManagerImpl.getRes ource(PoolManagerImpl.java:128)
at com.sun.enterprise.resource.JdbcDataSource.interna lGetConnection(JdbcDataSource.java:137)
at com.sun.enterprise.resource.JdbcDataSource.getConn ection(JdbcDataSource.java:111)
at comp.databrowser.dao.GenericDataBrowserDAO.getConn ection(Unknown Source)
I have absolutely no idea what I’m making wrong. I would be really very very graceful for any hint given me.
Greetz
Nadja Kesel