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
>

Reply via email to