Win a copy of Transfer Learning for Natural Language Processing (MEAP) this week in the Artificial Intelligence and Machine Learning 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
  • Tim Cooke
  • Paul Clapham
  • Devaka Cooray
  • Bear Bibeault
Sheriffs:
  • Junilu Lacar
  • Knute Snortum
  • Liutauras Vilda
Saloon Keepers:
  • Ron McLeod
  • Stephan van Hulst
  • Tim Moores
  • Tim Holloway
  • Piet Souris
Bartenders:
  • salvin francis
  • Carey Brown
  • Frits Walraven

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.
 
The longest recorded flight time of a chicken is 13 seconds. But that was done without this tiny ad:
the value of filler advertising in 2020
https://coderanch.com/t/730886/filler-advertising
    Bookmark Topic Watch Topic
  • New Topic