In the manual we read: The *jdbcType* element is used to specify the JDBC type of the parameter. The value must be one of the types listed in java.sql.Types (VARCHAR, INTEGER, etc.) Generally the *jdbcType* element is needed if there is a possibility that the value could be NULL, or to specify the use of DATE or TIME fields (as opposed to TIMESTAMP fields).
So please read the manual ;) and use #propertyName:jdbcType# On Wed, Mar 25, 2009 at 12:56 PM, Sekar, Sowmya <sse...@ucsd.edu> wrote: > Hi, > > I am trying to insert null value for a column and it throws the following > exception > > > > Cause: java.sql.SQLException: JZ006: Caught IOException: > java.io.IOException: JZ0SL: Unsupported SQL type 0. > > Caused by: java.sql.SQLException: JZ006: Caught IOException: > java.io.IOException: JZ0SL: Unsupported SQL type 0. *! > > > > Does ibatis allow insertion of null values? > > > > Thanks, > > > > *Sowmya Sekar* > > >
