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 <asilaz...@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. > >