error code [-7402]; rowcast(): create_castfuncstate: arg corrupted cast list
- From: slawek_k <slawek.kordecki@xxxxxxxxxxx>
- Date: Thu, 5 Jun 2008 12:25:23 -0700 (PDT)
Hello,
my server is IBM Informix Dynamic Server Version 9.40.UC6
and
JDBC Driver : 3.00.JC3
I use Rich Client Platform and connect to database server over JBoss
with Spring framework as WebServer.
With Spring's class BatchSqlUpdate i try to update one or more records
in the database. If it is one record to update then program work fine
else i get error -7402:
error code [-7402]; rowcast(): create_castfuncstate: arg corrupted
cast list;
Hier the essentially part of error stack :
2008-06-05 19:26:17,214 DEBUG
[org.springframework.jdbc.datasource.DataSourceUtils] Registering
transaction synchronization for JDBC Connection
2008-06-05 19:26:17,223 DEBUG
[org.springframework.transaction.support.TransactionSynchronizationManager]
Bound value
[org.springframework.jdbc.datasource.ConnectionHolder@2ddb85] for key
[org.springframework.jdbc.datasource.DriverManagerDataSource@ed2d75]
to thread [http-144.99.111.152-8080-4]
2008-06-05 19:26:17,225 DEBUG
[org.springframework.transaction.support.TransactionSynchronizationManager]
Retrieved value
[org.springframework.jdbc.datasource.ConnectionHolder@2ddb85] for key
[org.springframework.jdbc.datasource.DriverManagerDataSource@ed2d75]
bound to thread [http-144.99.111.152-8080-4]
2008-06-05 19:26:17,227 DEBUG
[org.springframework.jdbc.support.JdbcUtils] JDBC driver supports
batch updates
....
.....
Triggering afterCompletion synchronization
2008-06-05 19:26:17,281 DEBUG
[org.springframework.transaction.support.TransactionSynchronizationManager]
Clearing transaction synchronization
2008-06-05 19:26:17,282 ERROR [STDERR]
sGetStammdaten:updateStammdaten:statement
failed :PreparedStatementCallback; uncategorized SQLException for SQL
[update t_kundenstamm set( ks_kunde, ks_adresse,
ks_koresp_adresse,ks_rechn_adresse,ks_bankverbindung,ks_ansprechpartner,
ks_eingangsdatum, ks_dbuser, ks_status, ks_infotext, ks_einzugserm ) =
(ROW(?,?,?,?,?)::person,ROW(?,?,?,?,?,?,?,?,?)::adresse,ROW(?,?,?,?,?,?,?,?,?)::adresse,ROW(?,?,?,?,?,?,?,?,?)::adresse,ROW(?,?,?,?,?,?)::bankverbindung,ROW(?,?,?,?,?)::person,CURRENT,?,?,?,?)
WHERE ks_kdnr=? AND ks_anwendung = ?]; SQL state [IX000]; error code
[-7402]; rowcast(): create_castfuncstate: arg corrupted cast list;
nested exception is java.sql.BatchUpdateException: rowcast():
create_castfuncstate: arg corrupted cast list
2008-06-05 19:26:17,283 ERROR [STDERR] PreparedStatementCallback;
uncategorized SQLException for SQL [update t_kundenstamm
set( ks_kunde, ks_adresse,
ks_koresp_adresse,ks_rechn_adresse,ks_bankverbindung,ks_ansprechpartner,
ks_eingangsdatum, ks_dbuser, ks_status, ks_infotext, ks_einzugserm ) =
(ROW(?,?,?,?,?)::person,ROW(?,?,?,?,?,?,?,?,?)::adresse,ROW(?,?,?,?,?,?,?,?,?)::adresse,ROW(?,?,?,?,?,?,?,?,?)::adresse,ROW(?,?,?,?,?,?)::bankverbindung,ROW(?,?,?,?,?)::person,CURRENT,?,?,?,?)
WHERE ks_kdnr=? AND ks_anwendung = ?]; SQL state [IX000]; error code
[-7402]; rowcast(): create_castfuncstate: arg corrupted cast list;
nested exception is java.sql.BatchUpdateException: rowcast():
create_castfuncstate: arg corrupted cast list
2008-06-05 19:26:17,283 DEBUG
[org.springframework.web.servlet.DispatcherServlet] Cleared thread-
bound request context:
org.apache.catalina.connector.RequestFacade@fdbc27
2008-06-05 19:26:17,283 DEBUG
[org.springframework.web.servlet.DispatcherServlet] Could not complete
request
org.springframework.jdbc.UncategorizedSQLException:
PreparedStatementCallback; uncategorized SQLException for SQL [update
t_kundenstamm set( ks_kunde, ks_adresse,
ks_koresp_adresse,ks_rechn_adresse,ks_bankverbindung,ks_ansprechpartner,
ks_eingangsdatum, ks_dbuser, ks_status, ks_infotext, ks_einzugserm ) =
(ROW(?,?,?,?,?)::person,ROW(?,?,?,?,?,?,?,?,?)::adresse,ROW(?,?,?,?,?,?,?,?,?)::adresse,ROW(?,?,?,?,?,?,?,?,?)::adresse,ROW(?,?,?,?,?,?)::bankverbindung,ROW(?,?,?,?,?)::person,CURRENT,?,?,?,?)
WHERE ks_kdnr=? AND ks_anwendung = ?]; SQL state [IX000]; error code
[-7402]; rowcast(): create_castfuncstate: arg corrupted cast list;
nested exception is java.sql.BatchUpdateException: rowcast():
create_castfuncstate: arg corrupted cast list
Caused by:
java.sql.BatchUpdateException: rowcast(): create_castfuncstate: arg
corrupted cast list
at
com.informix.jdbc.IfxPreparedStatement.executeBatch(IfxPreparedStatement.java:
3134)
at org.springframework.jdbc.core.JdbcTemplate
$4.doInPreparedStatement(JdbcTemplate.java:825)
at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:
527)
at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:
556)
at
org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:
808)
at
org.springframework.jdbc.object.BatchSqlUpdate.flush(BatchSqlUpdate.java:
183)
at
ch.bza.elzahl.server.sGetStammdaten.updateStammdaten(sGetStammdaten.java:
1313)
.
- Prev by Date: RE: How to find the current database server name with SQL?
- Next by Date: Re: INSERT TRIGGER
- Previous by thread: How to find the current database server name with SQL?
- Next by thread: IDS Information Center OpenSearch plugin for Firefox and IE
- Index(es):
Relevant Pages
|
