RE: Inserting null value in ibatis

2009-03-26 Thread Rahul Saluja
by yourself in the code . Regards Rahul From: Sekar, Sowmya [mailto:sse...@ucsd.edu] Sent: Wednesday, March 25, 2009 10:27 PM To: user-java@ibatis.apache.org Subject: Inserting null value in ibatis Hi, I am trying to insert null value for a column and it throws

Inserting null value in ibatis

2009-03-25 Thread Sekar, Sowmya
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:

Re: Inserting null value in ibatis

2009-03-25 Thread Nicholoz Koka Kiknadze
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