File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes java.sql.SQLException: [SQL0901] Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "java.sql.SQLException: [SQL0901]" Watch "java.sql.SQLException: [SQL0901]" New topic

java.sql.SQLException: [SQL0901]

Hiroshi Tominaga

Joined: Apr 21, 2005
Posts: 29
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:
But i need the answer to solve the problem.

SCJP 1.4, <br />IBM Certified System Administrator Websphere Application Server 5.0, IBM Certified DB2 UDB Database Associate
Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 32819

Is it a true stale connection (the connection is open for a long time) ?

If so, just reconnect.

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
Hiroshi Tominaga

Joined: Apr 21, 2005
Posts: 29
Its not a stale connection least not the common stale connection, i start the server, execute the call and get the exception.
i cant find the solution yet
I agree. Here's the link:
subject: java.sql.SQLException: [SQL0901]
It's not a secret anymore!