Sorry, I thought iBATIS should support this behavior.
You can solve this problem easily by specify default value in Java class.
public class Example {
private String status;
...
public Example() {
this.status = "ready";
}
...
}
On Wed, Mar 18, 2009 at 3:06 PM, Alin Popa <alin.p...@gmail.com> wrote:
> 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
>
