error code [-7402]; rowcast(): create_castfuncstate: arg corrupted cast list

Posted in 2008

slawek_k — Thu, 5 Jun 2008 12:25:23 -0700 (PDT) — source: Usenet: comp.databases.informix

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)