I am trying to port an Application from SunOne App server to WebsphereApplicationServer 6.0.0.1. I am facing a critical problem
i.e., I am calling a method from one
EJB Session Bean say ASession to another Session Bean say BSession which returns a object called QResults Object.This QResults Object consists 4 properties They are
1. Connection Object reference
2. Statement[]- Array of Statement Interface
3. QueryOption(it is int)
4. ResultSet[] - Array of ResultSet Interface
Before returning from the called BSession method the values of the QResults Object are as follows
1. Connection - WSJdbcConnection
a) connImpl - OracleConnection
b) cm - ConnectionManager
c) autoCommit - false
d) mcf - WSManagedConnectionFactoryImpl
e) state - 0
2. Statement[0] - WSJdbcStatement
a) childWrapper - WSJdbcResultSet
b) parentWrapper - WSJdbcConnection
c) stmtImp - OracleStatement
d) state - 0
3. QueryOption - 1
4. ResultSet[0] - WSJdbcResultSet
a) childWrapper - null
b) parentWrapper - WSJdbcStatement
c) pmi - J2CModule
d) rsetImpl - OracleResultSetImpl
e) state - 0
=>
means the connection, statement and resultSet are active After returing to the calling (A)SessionBean method the values of the QResults are
1. Connection - WSJdbcConnection
a) connImpl - null
b) cm - null
c) autoCommit - false
d) mcf - WSManagedConnectionFacotryImpl
e) state - 1
2. Statement[0] - WSJdbcStatement
a) childWrapper - null
b) parentWrapper - null
c) stmtImp - null
d) state - 2
3. QueryOption - 1
4. ResultSet[0] - WSJdbcResultSet
a) childWrapper - null
b) parentWrapper - null
c) rsetImpl - null
d) state -2
=>
means the values of the connection, statement, resultset are visible but the values of the respective connection, statement, resultset are missing. (These all values I am able to see through Remote Debugging). The state value represents the state of the respective objects and state 2 means it is closed.
My concern is even though the two EJB's are in the same JVM the values are not returning to the called method.This part of the code is
working fine in other App Servers, I am looking the EJB's local EJB's only. The stack trace I am getting is :-
[12/31/04 15:42:10:859 IST] 0000003c SystemErr R com.stc.eindex.matching.MatchingException: Failed to retrieve candidate(s) from database. com.ibm.websphere.ce.cm.ObjectClosedException: DSRA9110E: ResultSet is closed.
Caused by: com.stc.eindex.matching.MatchingException: Failed to retrieve candidate(s) from database. com.ibm.websphere.ce.cm.ObjectClosedException: DSRA9110E: ResultSet is closed.
Caused by: com.ibm.websphere.ce.cm.ObjectClosedException: DSRA9110E: ResultSet is closed.
at com.ibm.ws.rsadapter.jdbc.WSJdbcResultSet.runtimeXIfNotClosed(WSJdbcResultSet.java:2642)
at com.ibm.ws.rsadapter.jdbc.WSJdbcResultSet.next(WSJdbcResultSet.java:2429)
at com.stc.eindex.ejb.query.QueryResults.assemble(QueryResults.java:129)
... 31 more
If any
Websphere Juru helps me I will be very very thankful to him and I am sorry for my poor english grammer.
Thanks in advance
