Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Getting error while testing the Stored procedure

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
sivasaras

New User


Joined: 29 Sep 2007
Posts: 90
Location: chenna/i-

PostPosted: Wed Sep 18, 2013 9:35 pm    Post subject: Getting error while testing the Stored procedure
Reply with quote

Hi,

our application is having java and mainframes as back end.

we are testing our changes and from the screen while selecting it is throwing db2 error in the backend

Invalid operation: statement is closed. ERRORCODE=-4470, SQLSTATE=null

Can u please tell me how to solve this >

Thanks
siva
Back to top
View user's profile Send private message

Akatsukami

Global Moderator


Joined: 03 Oct 2009
Posts: 1788
Location: Bloomington, IL

PostPosted: Wed Sep 18, 2013 10:00 pm    Post subject:
Reply with quote

This sounds like a JDBC error where multiple threads are trying to use the same connection object. You may be better off seeking assistance on a board dealing with RDBMS other than just z/OS DB2.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts SQL Code 302 while executing stored ... Ashishpanpaliya DB2 8 Wed Aug 01, 2018 7:54 pm
No new posts sql code 331 while calling Stored Pro... Ashishpanpaliya DB2 5 Wed Aug 01, 2018 7:06 pm
No new posts Add delay in External stored procedure smenjoge DB2 1 Thu Jul 19, 2018 1:21 am
No new posts Error while initiation CICS program f... Ashishpanpaliya CICS 3 Mon Jul 16, 2018 5:12 pm
No new posts ERROR - NO ESD ENTRIES, EXECUTION IMP... Ashishpanpaliya COBOL Programming 6 Thu Jun 21, 2018 8:57 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us