ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jeff Butler" <jeffgbut...@gmail.com>
Subject Re: Error with Websphere embedded driver
Date Tue, 12 Dec 2006 00:16:49 GMT
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 <mniharika@gmail.com> 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
>

Mime
View raw message