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:[EMAIL PROTECTED] 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 <[EMAIL PROTECTED]> wrote: > All the columns in table dummy are nullable in Oracle > > -----Original Message----- > From: Daniel Henrique Ferreira e Silva [mailto:[EMAIL PROTECTED] > 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 <[EMAIL PROTECTED]> 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) >
