I am using java String and oracle Varchar2 giuseppe
-----Messaggio originale----- Da: Giovanni Cuccu - CUP2000 [mailto:[EMAIL PROTECTED] Inviato: lunedì 19 febbraio 2007 17.31 A: user-java@ibatis.apache.org Oggetto: Re: R: R: handling null values it seems that the descrizione field has an incorrect type i.e. your sql is mapping the column descrizione to the wrong type. I can guess that descrizione is a varchar2 column, is the corresponding java property a String? is there any chance that you are mapping columns and java properties in different order? Giovanni > com.ibatis.common.jdbc.exception.NestedSQLException: > > --- The error occurred in Pratica.xml. > > --- The error occurred while applying a parameter map. > > --- Check the insertPraticaOracle-InlineParameterMap. > > --- Check the parameter mapping for the 'descrizione' property. > > --- Cause: java.sql.SQLException: Tipo di colonna non valido > > Caused by: java.sql.SQLException: Tipo di colonna non valido > > at > com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeUpdate(GeneralStatement.java:91) > > at > com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.insert(SqlMapExecutorDelegate.java:446) > > at > com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.insert(SqlMapSessionImpl.java:82) > > at > com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.insert(SqlMapClientImpl.java:60) > > at > it.pitagora.pratica.dao.ibatis.IBatisPraticaDAO.insertPratica(IBatisPraticaDAO.java:152) > > at > it.pitagora.test.TestCasePratica.testInsertPratica(TestCasePratica.java:127) > > at it.pitagora.test.TestCasePratica.main(TestCasePratica.java:161) > > Caused by: java.sql.SQLException: Tipo di colonna non valido > > at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) > > at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179) > > at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269) > > at > oracle.jdbc.driver.OracleStatement.get_internal_type(OracleStatement.java:6411) > > at > oracle.jdbc.driver.OraclePreparedStatement.setNull(OraclePreparedStatement.java:1358) > > at > it.pitagora.util.pool.db.CachedPreparedStatement.setNull(CachedPreparedStatement.java:102) > > at > com.ibatis.sqlmap.engine.mapping.parameter.BasicParameterMap.setParameter(BasicParameterMap.java:171) > > at > com.ibatis.sqlmap.engine.mapping.parameter.BasicParameterMap.setParameters(BasicParameterMap.java:125) > > at > com.ibatis.sqlmap.engine.execution.SqlExecutor.executeUpdate(SqlExecutor.java:76) > > at > com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteUpdate(GeneralStatement.java:200) > > at > com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeUpdate(GeneralStatement.java:78) > > ... 6 more > > > > -- Giovanni Cuccu CUP 2000 Spa Via del Borgo di S. Pietro, 90/c - 40126 Bologna e-mail: giovanni.cuccu _at_ cup2000.it
