Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

java.sql.SQLException: [SQL0901]

 
Hiroshi Tominaga
Greenhorn
Posts: 29
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
I get the following error statement when i try to call a stored procedure on DB2 for iSeries:

StaleConnecti A CONM7007I:
Mapping the following SQLException, with ErrorCode -901 and SQLState
58004, to a StaleConnectionException: java.sql.SQLException: [SQL0901]
SQL system error.

I call the procedure from my development environment, here are the specs:
- WSAD 5.1
- TestEnvironment Server 5.0
- DataSource version 5 - this is required because i use J2EE 1.3 specification, i cant use an older spec.
- JT400 (7/20/2004 - 4,003Kb...i dont know the version or release of this)


Please if anyone know what can i do feel free to post suggestions.
I found this link on the web: http://www-128.ibm.com/developerworks/forums/dw_thread.jsp?message=13743832&cat=19&thread=91012&treeDisplayType=threadmode1&forum=292#13743832
But i need the answer to solve the problem.
Thanks,
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34837
369
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hiroshi,
Is it a true stale connection (the connection is open for a long time) ?

If so, just reconnect.
 
Hiroshi Tominaga
Greenhorn
Posts: 29
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
Its not a stale connection problem....at least not the common stale connection, i start the server, execute the call and get the exception.
i cant find the solution yet
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic