ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kengkaj Sathianpantarit <kengka...@gmail.com>
Subject Re: mysql default value
Date Wed, 18 Mar 2009 08:14:40 GMT
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.popa@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
> <kengkaj.s@gmail.com> wrote:
> > Use null value replacement feature, read user manual.
> >
> > Kengkaj
> >
> > On Tue, Mar 17, 2009 at 10:37 PM, Alin Popa <alin.popa@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
>

Mime
View raw message