ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Brian Bruns <brian.br...@gmail.com>
Subject Re: ibatis - Sybase String problem
Date Tue, 17 Mar 2009 12:55:01 GMT
You need to explicitly give it the type, so if AD was an int:

INSERT INTO
                HEDEF_TANIMLARI (OID, VERSION, AD)
                VALUES (#oid#, #version#, #ad:INT#)

I've not seen Sybase require this, but DB2 needs the type for null
values.  In general it's a good idea for portability.  MySQL is a
little loose with what it accepts, for better or worse.

Brian

2009/3/17 ilkayaktas <asilazmaz@gmail.com>:
>
> Hi everyone,
> i got a problem in ibatis. I have an insert sql in xml file like :
>
> <insert id="insert"
> parameterClass="tr.com.cs.peb.hedef.model.HedefTanimlariOM">
>                INSERT INTO
>                HEDEF_TANIMLARI (OID, VERSION, AD)
>                VALUES (#oid#, #version#, #ad#)
> </insert>
>
> class HedefTanimlariOM{
>     String oid;
>     String version;
>     String ad;
> }
>
> when i send parameter which oid and version are valid but ad is null, sybase
> send an error 'JZ0SM: Unsupported SQL type 0'. When i look into the log file
> i see:
> INSERT INTO   HEDEF_TANIMLARI (OID, VERSION, AD) VALUES(?,?,?)
> Parameters: [12b2czfsedqv9e00, 0, null]
> Types: [java.lang.String, java.lang.String, null]
>
> last parameter's type seems null. Mysql deosn't throw any exception but
> sybase does. How can i fix it?
> --
> View this message in context: http://www.nabble.com/ibatis---Sybase-String-problem-tp22554502p22554502.html
> Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
>
>

Mime
View raw message