• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Liutauras Vilda
  • Jeanne Boyarsky
  • Devaka Cooray
  • Paul Clapham
Sheriffs:
  • Tim Cooke
  • Knute Snortum
  • Bear Bibeault
Saloon Keepers:
  • Ron McLeod
  • Tim Moores
  • Stephan van Hulst
  • Piet Souris
  • Ganesh Patekar
Bartenders:
  • Frits Walraven
  • Carey Brown
  • Tim Holloway

Help Regarding WSJdbcResultSet

 
Greenhorn
Posts: 15
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Greenhorn
Posts: 10
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Chandrakanth,
I am also seeing similar issue. See my post http://www.coderanch.com/t/553602/JDBC/java/ResultSet-getting-closed .
Are you able to figure out what's going on and how we can address it. Any help will be highly appreciated.

Thanks in Advance.
 
Don't get me started about those stupid light bulbs.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!