Thanks Kengkaj, But from what I read it seems that nullValue is used to substitute value with a database NULL. The thing is that I'm not allowed to use null since field is "NOT NULL".
On Wed, Mar 18, 2009 at 6:00 AM, Kengkaj Sathianpantarit <kengka...@gmail.com> wrote: > Use null value replacement feature, read user manual. > > Kengkaj > > On Tue, Mar 17, 2009 at 10:37 PM, Alin Popa <alin.p...@gmail.com> wrote: >> >> Hi, >> >> I have the following db table (MySQL): >> >> CREATE TABLE `examples`( >> `id` SERIAL PRIMARY KEY, >> `name` VARCHAR(255), >> `status` VARCHAR(20) NOT NULL DEFAULT 'ready', >> `description` TEXT >> ) ENGINE=innodb DEFAULT CHARSET utf8 DEFAULT COLLATE utf8_bin; >> >> >> Using ibatis sql-map I'm doing this: >> >> <insert id="insertExample" parameterClass="com.test.Example"> >> INSERT INTO vjobs(name, status, description) VALUES >> (#name#,#status#,#description#) >> </insert> >> >> When inserting an example object, without having "status" field set, I >> got Column 'status' cannot be null; but the DEFAULT is 'ready'. >> >> How can this be managed using ibatis ? >> It is possible ? >> >> >> Thanks. >> >> Alin > > -- Best Regards, Alin
