ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jason Hall" <JH...@cihi.ca>
Subject RE: Error processing Null during Insert statement - Help
Date Thu, 26 May 2005 17:39:15 GMT
Yes I'm using JDBC-ODBC driver. I'm using Oracle 9i. Will Oracle 10g driver work with Oracle
9i?

-----Original Message-----
From: Daniel Henrique Ferreira e Silva [mailto:dhsilva@gmail.com]
Sent: Thursday, May 26, 2005 1:34 PM
To: Jason Hall
Subject: Re: Error processing Null during Insert statement - Help


Hi Jason,

Looking deeper at your stack traces, i found something that i need to
get confirmation: are you using JDBC-ODBC bridge driver?

If positive, try replacing it with Oracle 10g driver.

Cheers,
Daniel Silva.

On 5/26/05, Jason Hall <JHall@cihi.ca> 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