Win a copy of Svelte and Sapper in Action this week in the JavaScript forum!
  • 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
  • Ron McLeod
  • Paul Clapham
  • Bear Bibeault
  • Junilu Lacar
Sheriffs:
  • Jeanne Boyarsky
  • Tim Cooke
  • Henry Wong
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • salvin francis
  • Frits Walraven
Bartenders:
  • Scott Selikoff
  • Piet Souris
  • Carey Brown

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 https://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.
 
Did you just should on me? You should read this tiny ad:
Thread Boost feature
https://coderanch.com/t/674455/Thread-Boost-feature
    Bookmark Topic Watch Topic
  • New Topic