You'll need to specify the JDBC type for the nullable column like this:
<insert id="myInsert"> insert into mytable (id, name) values (#id#, #name:VARCHAR#) </insert> Jeff Butler On 12/11/06, Niharika Mateti <[EMAIL PROTECTED]> wrote:
I am getting the following error whenever I try to insert a null or update a null value in a table. [IBM][SQLServer JDBC Driver]The specified SQL type is not supported by this driver The ibatis version that I am using is 2.1.7. The database is sql server 2000 The driver is websphere embedded connect jdbc driver - The driver that comes with Websphere 6.0 Has anyone else encounter this problem? Is there a way to solve this. Thanks, Niharika
