You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-java@ibatis.apache.org by Jason Hall <JH...@cihi.ca> on 2005/05/26 19:12:41 UTC
Error processing Null during Insert statement - Help
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)
Re: Error processing Null during Insert statement - Help
Posted by Daniel Henrique Ferreira e Silva <dh...@gmail.com>.
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 <JH...@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)
Re: Error processing Null during Insert statement - Help
Posted by Brandon Goodin <br...@gmail.com>.
Wow, you replied to a 2+ year old email. First off, Daniel will not be able
to reply. He was killed in an automobile accident in 2005.
On to your question... What does spring have to do with the thread of
conversation that you replied to? You can just pass a null in to the
database. If you need to type your null you can specify it in a resultMap.
Please read the ibatis documentation.
Brandon Goodin
On 6/25/07, Sunil Jigyasu <sj...@texity.com> wrote:
>
>
> Daniel,
>
> How do you tell Spring what the driver is expected to do if it encounters
> a
> null in the input?
>
> Sunil Jigyasu
>
>
> Henry Lu-2 wrote:
> >
> > The data type cast is needed only null values are passed to JDBC driver.
> > Because in the Spring, you got to tell what the driver expect to do if a
> > null value set to input. And Spring tries to use same code for different
> > DB drivers, there is no way to use diffrent data type with null values
> > for all kinds of DB drivers.
> >
> > -Henry
> >
> > Daniel Henrique Ferreira e Silva wrote:
> >
> >>Henry,
> >>
> >>Yes, they are usually smart enough for casting to the appropriate
> >>type. But it's not good to rely on this every time you need to do
> >>something like Jason is. Type casts can make harder to figure out some
> >>errors.
> >>
> >>Jason, let me know if using Oracle's driver worked for you.
> >>
> >>Cheers,
> >>Daniel Silva.
> >>
> >>
> >>
> >>On 5/26/05, Henry Lu <zh...@umich.edu> wrote:
> >>
> >>
> >>>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 <JH...@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)
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>
> >>>>
> >>>>
> >>>>
> >>
> >>
> >>
> >>
> >
> >
>
> --
> View this message in context:
> http://www.nabble.com/Error-processing-Null-during-Insert-statement---Help-tf31170.html#a11299616
> Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
>
>
Re: Error processing Null during Insert statement - Help
Posted by Sunil Jigyasu <sj...@texity.com>.
Daniel,
How do you tell Spring what the driver is expected to do if it encounters a
null in the input?
Sunil Jigyasu
Henry Lu-2 wrote:
>
> The data type cast is needed only null values are passed to JDBC driver.
> Because in the Spring, you got to tell what the driver expect to do if a
> null value set to input. And Spring tries to use same code for different
> DB drivers, there is no way to use diffrent data type with null values
> for all kinds of DB drivers.
>
> -Henry
>
> Daniel Henrique Ferreira e Silva wrote:
>
>>Henry,
>>
>>Yes, they are usually smart enough for casting to the appropriate
>>type. But it's not good to rely on this every time you need to do
>>something like Jason is. Type casts can make harder to figure out some
>>errors.
>>
>>Jason, let me know if using Oracle's driver worked for you.
>>
>>Cheers,
>>Daniel Silva.
>>
>>
>>
>>On 5/26/05, Henry Lu <zh...@umich.edu> wrote:
>>
>>
>>>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 <JH...@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)
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>>
>>>>
>>
>>
>>
>>
>
>
--
View this message in context: http://www.nabble.com/Error-processing-Null-during-Insert-statement---Help-tf31170.html#a11299616
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.