aspose file tools*
The moose likes EJB and other Java EE Technologies and the fly likes Ejb Finder(ejb-ql) Transaction TimesOut Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Java » EJB and other Java EE Technologies
Bookmark "Ejb Finder(ejb-ql) Transaction TimesOut " Watch "Ejb Finder(ejb-ql) Transaction TimesOut " New topic
Author

Ejb Finder(ejb-ql) Transaction TimesOut

S More
Greenhorn

Joined: Oct 11, 2012
Posts: 1
Hi,
We have been facing an issue, where a simple ejb-ql query runs out of transaction time, if same(WL generated SQL version of ejb-ql) is run from SQL command prompt, it takes very less time than the configured JTA time(execute less than 5% time of JTA).

Erros: Few time the error thrown is:
javax.ejb.FinderException: Exception in 'finderMethodName' while using result set: 'weblogic.jdbc.wrapper.ResultSet_oracle_jdbc_driver_OracleResultSetImpl@9c18f'
java.sql.SQLException: Unexpected exception while enlisting XAConnection java.sql.SQLException: Transaction rolled back: Transaction timed out after 301 seconds

Note - JTA is configured to 300 seconds

Most of the time the error thrown is:
javax.ejb.FinderException: Exception in 'finderMethodName' while using result set: 'weblogic.jdbc.wrapper.ResultSet_oracle_jdbc_driver_OracleResultSetImpl@a5af'
java.sql.SQLException: Result set already closed

Environment: WL9.2, Oracle10g.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Ejb Finder(ejb-ql) Transaction TimesOut