473,401 Members | 2,146 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,401 software developers and data experts.

[DB2] SQLWarning chain holds value that is not a SQLWarning

I try to insert a record into db2 using spring,while error occurred.
the error is as follows:
-----------------------------------------------------------------
Exception in thread "main" java.lang.Error: SQLWarning chain holds value that is not a SQLWarning
at java.sql.SQLWarning.getNextWarning(Unknown Source)
at org.springframework.jdbc.core.JdbcTemplate.handleW arnings(JdbcTemplate.java:1112)
at org.springframework.jdbc.core.JdbcTemplate.execute (JdbcTemplate.java:539)
at org.springframework.jdbc.core.JdbcTemplate.update( JdbcTemplate.java:739)
at org.springframework.jdbc.core.JdbcTemplate.update( JdbcTemplate.java:797)
at org.springframework.jdbc.core.JdbcTemplate.update( JdbcTemplate.java:805)
at com.ibm.pw.pps.migratorimpl.CSVToDB2Migrator.execu teInsert(CSVToDB2Migrator.java:184)
at com.ibm.pw.pps.migratorimpl.CSVToDB2Migrator.migra te(CSVToDB2Migrator.java:126)
at com.ibm.pw.pps.CSVMigrationManager.migrate(CSVMigr ationManager.java:458)
at com.ibm.pw.pps.CSVMigrationManager.migrate(CSVMigr ationManager.java:340)
at com.ibm.pw.pps.CSVMigrationUtility.main(CSVMigrati onUtility.java:178)
-----------------------------------------------------------------


and this is my code piece which throws the error:
-----------------------------------------------------------------
DataSource dataSource = getDataSourceFactory().getDataSource();
JdbcTemplate jdbcTempate = new JdbcTemplate(dataSource);
jdbcTempate.update(sql.toString(), params.toArray());
-----------------------------------------------------------------
I use spring.
the strange thing is that in spite of error, record is successfully inserted .

Any one has encounted this problem before or has any idea about this?
Thanks
Apr 14 '10 #1
0 2193

Sign in to post your reply or Sign up for a free account.

Similar topics

8
by: Adam Greifer | last post by:
Hi! I'm a newbie at DB2 but have 13 years of SQL Server. I need to convert over 100 SQL Server procs to DB2. I haven't had much luck with the IBM Integration Toolkit and want to avoid ER/win...
7
by: Rhino | last post by:
I am using DB2 V7.2.7 on Windows XP and I would like to write Ant 1.6.1 scripts that do some of my program preparation. For the benefit of those not familiar with Ant, it is an open source...
3
by: Odd Bjørn Andersen | last post by:
When our application tries to send a parameter of the type adDBTimeStamp to DB2 we an error message saying SQLSTATE 22007 An invalid datetime format was detected; that is, an invalid string...
0
by: Dmitry Tolpeko | last post by:
Hello, Could anybody please explain me why DB2 z/OS 8.1 fails on the simple procedure below: Error: DSNHSMS2 LINE 12 COL 6 NESTED COMPOUND STATEMENTS NOT ALLOWED It failes on DECLARE...
0
by: JohnO | last post by:
Thanks to Serge and MarkB for recent tips and suggestions. Ive rolled together a few stored procedures to assist with creating audit triggers automagically. Hope someone finds this as useful as...
2
by: heming_g | last post by:
drop procedure sp_DelTable_CommitCount@ CREATE PROCEDURE sp_DelTable_CommitCount(IN as_TableName VARCHAR(128) , IN as_Condition VARCHAR(1024) , IN abi_CommitCount BIGINT) LANGUAGE SQL...
5
by: news.cyberlink.ch | last post by:
Hi, We have a DB2 version 7 fixpack 14 installed on Windows 200 at a customer site that is crashing at regular intervals.Everything was working fine for over many years, now since about one...
1
by: jmaria | last post by:
Hello Sorry, I don't find a specific forum for DB2, please help me with this. The cursor don't open :-(, I don't know why, any ideas? I want to update the colum "co_peticion" from table...
0
chandu031
by: chandu031 | last post by:
Hi ppl, I am new to this community and am quite overwhelmed by the kind of discussions happening here. I thought I might get a solution here, so am posting my problem here : I wanted to know if...
0
by: Frank Swarbrick | last post by:
Does anyone have any idea what the following file might be, and why it gets created? C:\Documents and Settings\FJSwarbrick\Application Data\IBM\DB2\db2tools\.databean.jdbclob It appears to be...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
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,...
0
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...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
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...
0
agi2029
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,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.