File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "" Watch "" New topic

weyman tan

Joined: Dec 19, 2011
Posts: 3
Does any one can tell me why is thrown?

System out:
[1/3/12 6:01:15:336 CST] 0000006e WSRdbXaResour E DSRA0304E: XAException occurred. XAException contents and details are:
The XA Error is : -7
The XA Error message is : Resource manager is unavailable.
The Oracle Error code is : 17002
The Oracle Error message is: Internal XA Error
The cause is : null.
[1/3/12 6:01:15:345 CST] 0000006e WSRdbXaResour E DSRA0302E: XAException occurred. Error code is: XAER_RMFAIL (-7). Exception is: <null>
[1/3/12 6:01:15:349 CST] 0000006e ConnectionEve A J2CA0056I: The Connection Manager received a fatal connection error from the Resource Adaptor for
resource jdbc/pems01. The exception which was received is oracle.jdbc.xa.OracleXAException
[1/3/12 6:01:15:833 CST] 0000006e RegisteredRes E WTRN0078E: An attempt by the transaction manager to call start on a transactional resource has res
ulted in an error. The error code was XAER_RMFAIL. The exception stack trace follows: oracle.jdbc.xa.OracleXAException
at oracle.jdbc.xa.OracleXAResource.checkError(
at oracle.jdbc.xa.client.OracleXAResource.start(
at sun.reflect.GeneratedMethodAccessor52.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke( Code))
at java.lang.reflect.Method.invoke( Code))
at org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy$TransactionAwareInvocationHandler.invoke(TransactionAwareDataSourceProx
at $Proxy135.prepareStatement(Unknown Source)
at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForObject(
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(
at org.springframework.orm.ibatis.SqlMapClientTemplate$1.doInSqlMapClient(
at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(
at org.springframework.orm.ibatis.SqlMapClientTemplate.queryForObject(

Log4j output:
06:02:10,673 [Thread-2][ERROR DefaultErrorHandlerImpl.processError 22] OnlineBusinessDateWorker - Failed to doBatch RemoteException ERROR:java.rmi.ServerException: RemoteException occurred in server thread; nested exception is:
java.rmi.RemoteException: ; nested exception is:
org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [0];
--- The error occurred in resources/ss/ibatis/UserSQL.xml.
--- The error occurred while executing query.
--- Check the <sql statement>
--- Check the SQL Statement (preparation failed).
--- Cause: enlist: caught Exception; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:

It is sorta covered in the JavaRanch Style Guide.
It's not a secret anymore!