my dog learned polymorphism*
The moose likes JDBC 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 Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "java.sql.SQLException: [SQL0901]" Watch "java.sql.SQLException: [SQL0901]" New topic
Author

java.sql.SQLException: [SQL0901]

Hiroshi Tominaga
Greenhorn

Joined: Apr 21, 2005
Posts: 29
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,


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

Joined: May 26, 2003
Posts: 30057
    
149

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

If so, just reconnect.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Hiroshi Tominaga
Greenhorn

Joined: Apr 21, 2005
Posts: 29
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: java.sql.SQLException: [SQL0901]
 
Similar Threads
websphere server starting error
Problem using array in WebSphere web service
need help..
MQException: what is the meaning of this exception?
ws ant task requirement