ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Henry Lu <z...@umich.edu>
Subject Re: Error processing Null during Insert statement - Help
Date Thu, 26 May 2005 17:30:04 GMT
Change NUMBER to varchar will take care the business.

<parameterMap id="paramMap" class="ca.cihi.omhrs.Dummy" >
   <parameter property="id"  jdbcType="VARCHAR" nullValue="-999" />
   <parameter property="name" jdbcType="VARCHAR" nullValue="NO_ENTRY" />
</parameterMap>

-Henry

Jason Hall wrote:

>All the columns in table dummy are nullable in Oracle
>
>-----Original Message-----
>From: Daniel Henrique Ferreira e Silva [mailto:dhsilva@gmail.com]
>Sent: Thursday, May 26, 2005 1:22 PM
>To: ibatis-user-java@incubator.apache.org
>Subject: Re: Error processing Null during Insert statement - Help
>
>
>Hi Jason,
>
>Looking at the stack trace you posted, it's clear that the error
>you're getting comes from your DB.
>Look at your table Dummy structure. Does it allow the column id to be null?
>Also, what is your DB?
>
>Hope that helped.
>
>Cheers,
>Daniel Silva.
>
>
>On 5/26/05, Jason Hall <JHall@cihi.ca> wrote:
>  
>
>> 
>>
>>Hi, 
>>
>>I'm trying to force a null in a nullable column and i get an error. 
>>
>>Java code: 
>>Dummy d = new Dummy(); 
>>d.setId(-999); 
>>sqlMap.insert("Dummy.insertDummy",d); 
>> 
>> 
>>
>>Sql Map: 
>><?xml version="1.0" encoding="UTF-8" standalone="no"?> 
>><!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN"
>>"http://www.ibatis.com/dtd/sql-map-2.dtd"> 
>>
>><sqlMap namespace="Dummy"> 
>>
>><parameterMap id="paramMap" class="ca.cihi.omhrs.Dummy" > 
>>  <parameter property="id"  jdbcType="NUMBER" nullValue="-999" /> 
>>  <parameter property="name" jdbcType="VARCHAR" nullValue="NO_ENTRY" /> 
>></parameterMap> 
>>
>><insert id="insertDummy" parameterMap="paramMap"> 
>>
>>insert into Dummy(id,name) 
>>values(?,?) 
>></insert> 
>>
>><!-- 
>><insert id="insertDummy" parameterClass="ca.cihi.omhrs.Dummy"> 
>>
>>insert into Dummy(id,name) 
>>values(#id:NUMERIC:#,#name:VARCHAR:NO_ENTRY#) 
>></insert> 
>>--> 
>>
>></sqlMap> 
>>  
>> 
>> 
>> 
>>
>>I get the following error: 
>>
>>com.ibatis.common.jdbc.exception.NestedSQLException:   
>>--- The error occurred in
>>ca/cihi/omhrs/persistence/datamap/Dummy.xml.  
>>--- The error occurred while applying a parameter map.  
>>--- Check the Dummy.paramMap.  
>>--- Check the parameter mapping for the 'id' property.  
>>--- Cause: java.sql.SQLException: General error 
>>Caused by: java.sql.SQLException: General error 
>>        at
>>com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeUpdate(GeneralStatement.java:87)
>>        at
>>com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.insert(SqlMapExecutorDelegate.java:442)
>>        at
>>com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.insert(SqlMapSessionImpl.java:85)
>>        at
>>com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.insert(SqlMapClientImpl.java:57)
>>        at ca.cihi.omhrs.TestIbatis.main(TestIbatis.java:121) 
>>
>>Caused by: 
>>java.sql.SQLException: General error 
>>        at
>>sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6060)
>>        at
>>sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:6188) 
>>        at
>>sun.jdbc.odbc.JdbcOdbc.SQLBindInParameterNull(JdbcOdbc.java:922)
>>        at
>>sun.jdbc.odbc.JdbcOdbcPreparedStatement.setNull(JdbcOdbcPreparedStatement.java:359)
>>        at
>>com.ibatis.sqlmap.engine.mapping.parameter.BasicParameterMap.setParameter(BasicParameterMap.java:173)
>>        at
>>com.ibatis.sqlmap.engine.mapping.parameter.BasicParameterMap.setParameters(BasicParameterMap.java:125)
>>        at
>>com.ibatis.sqlmap.engine.execution.SqlExecutor.executeUpdate(SqlExecutor.java:80)
>>        at
>>com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteUpdate(GeneralStatement.java:196)
>>        at
>>com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeUpdate(GeneralStatement.java:74)
>>        at
>>com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.insert(SqlMapExecutorDelegate.java:442)
>>        at
>>com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.insert(SqlMapSessionImpl.java:85)
>>        at
>>com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.insert(SqlMapClientImpl.java:57)
>>        at ca.cihi.omhrs.TestIbatis.main(TestIbatis.java:121)
>>    
>>
>
>
>  
>

Mime
View raw message