Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

error while retrieving data from db2

Posted on 2011-03-21
1
718 Views
Last Modified: 2012-05-11
when i try to retrieve data from my database db2. i get the following error message


Error 500: com.ibm.db2.jcc.a.SqlException: [jcc][t4][10120][10898][3.52.90] Invalid operation: result set is closed. ERRORCODE=-4470, SQLSTATE=null
0
Comment
Question by:manikandan689
1 Comment
 
LVL 57

Accepted Solution

by:
Raja Jegan R earned 500 total points
ID: 35186721
Seems like you have BLOB datatype fetched in the resultset and Check the workaround /fix provided here:

https://www-304.ibm.com/support/docview.wss?uid=swg1JR29617
http://www.ibm.com/developerworks/forums/thread.jspa?messageID=14053553
0

Featured Post

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL0968C  The file system is full - while loading a DB2 table...What's up with this? 9 787
Wrong record extracting - DB2 SQL 10 172
DB2 V9.7 restore 5 45
Monitor SQL Insert 8 74
Recursive SQL in UDB/LUW (you can use 'recursive' and 'SQL' in the same sentence) A growing number of database queries lend themselves to recursive solutions.  It's not always easy to spot when recursion is called for, especially for people una…
Recursive SQL in UDB/LUW (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

861 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question