Invalid statement - DB2 Database

jane

We are getting this error every other day during the ETL run. It seems
to be random. What is the best solution?

DB2 AIX 8.1.5.

COM.ibm.db2.jdbc.DB2Exception: [IBM][JDBC Driver] CLI0601E Invalid
statement handle or statement is closed. SQLSTATE=S1000

Thank You.
-Jane

Aug 15 '06 #1

Subscribe Reply

7427

Knut Stolze

jane wrote:

We are getting this error every other day during the ETL run. It seems
to be random. What is the best solution?

DB2 AIX 8.1.5.

COM.ibm.db2.jdbc.DB2Exception: [IBM][JDBC Driver] CLI0601E Invalid
statement handle or statement is closed. SQLSTATE=S1000

Usually, that's a problem in the application. Run a JDBC trace and see
what's going on at the communication level between the app and DB2. My
guess would be that you have not turned off auto-commit. Maybe you're
sharing connections and multiple threads interfere with each other...

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

Aug 15 '06 #2

vj_dba

hi,

If db2java.zip is prior to DB2 Version 7 FixPak 2:

COM.ibm.db2.jdbc.DB2Exception: [IBM][JDBC Driver]
CLI0601E Invalid statement handle or statement is closed.
SQLSTATE=S1000
If a mismatch occurs, the JDBC applet server logs one of the following
messages in the jdbcerr.log file:

have a look at the fixpack

cheers

Knut Stolze wrote:

jane wrote:

We are getting this error every other day during the ETL run. It seems
to be random. What is the best solution?

DB2 AIX 8.1.5.

COM.ibm.db2.jdbc.DB2Exception: [IBM][JDBC Driver] CLI0601E Invalid
statement handle or statement is closed. SQLSTATE=S1000

Usually, that's a problem in the application. Run a JDBC trace and see
what's going on at the communication level between the app and DB2. My
guess would be that you have not turned off auto-commit. Maybe you're
sharing connections and multiple threads interfere with each other...

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

Aug 17 '06 #3

Similar topics

Error... Invalid object name 'data1'.

by: rockie12 | last post by:

I have a db that has a table x in it called data1 I have a program that does to things, updates values in the data1 table and also inserts new rows into this table. The update existing values...

Microsoft SQL Server

Trigger calling INVALID SP - strange behaviour ?

by: Paul Reddin | last post by:

Hi, FYI & comment: We have triggers that call SPs. If the Stored Procedure is invalidated, e.g a dependent table is dropped. The SP is marked as invalid, but no error is thrown by the...

DB2 Database

Anybody know how I would code an error statement when a user inputs an invalid input.

by: jeff regoord | last post by:

A user inputs a float value. The scanf() function gets the value. However, I need to create an error handler with an if else statement saying invalid input if the input is not a number. Does...

C / C++

Invalid Cast Exception Calling Bsse Class Method

by: Nick Flandry | last post by:

I'm running into an Invalid Cast Exception on an ASP.NET application that runs fine in my development environment (Win2K server running IIS 5) and a test environment (also Win2K server running IIS...

ASP.NET

getElementById with invalid ID causes script to exit?

by: bcr07548 | last post by:

I am writing a web site that uses JavaScript to validate certain forms and I seem to be having some trouble. The site uses PHP and for one of the forms, depending on the situation, one of of the...

Javascript

SyntaxError: Invalid Syntax.

by: ronrsr | last post by:

no matter where I place this imported file,the statement after it in the main program gets a syntax error, regardless of the syntax. I think I may have changed something in this file, but I'm...

Python

PRINT debug messages and CURSOR in stored procedure confuses DTS; "Invalid Pointer"

by: Bill_DBA | last post by:

I have the following stored procedure that is called from the source of a transformation in a DTS package. The first parameter turns on PRINT debug messages. The second, when equals 1, turns on the...

Microsoft SQL Server

Subquery with invalid column name runs

by: Anne | last post by:

Hello! Here is the statement in question: --STATEMENT A SELECT * FROM dbo.myTable WHERE colX in (SELECT colX FROM dbo.sourceTable) The problem with Statement A is that 'colX' does not exist...

Microsoft SQL Server

Invalid object name

by: Curious | last post by:

I got an exception when executing the SQL statement in my code below. The error is "Invalid object name 'db_dynamic_trading.dbo.TrdRpt_broker_list'". I know for a fact that...

.NET Framework

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

C# / C Sharp

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...

Networking - Hardware / Configuration

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET