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:43:20 GMT
You know, ORACLE/SQL Server are smart enough to do the data conversion 
for most data types.

-Henry

Jason Hall wrote:

>This works, but doesn't makes sense why since my column is a NUMBER data type.
>
>Does JDBC-ODBC driver be the problem on Oracle 9i?
>
>-----Original Message-----
>From: Henry Lu [mailto:zhlu@umich.edu]
>Sent: Thursday, May 26, 2005 1:30 PM
>To: ibatis-user-java@incubator.apache.org
>Subject: Re: Error processing Null during Insert statement - Help
>
>
>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