ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nicholoz Koka Kiknadze <kikna...@gmail.com>
Subject Re: mysql default value
Date Wed, 18 Mar 2009 08:51:41 GMT
> Why don't you just exclude this field in the <insert>?

<insert id="insertExampleWithDefaults" parameterClass="com.test.Example">
 INSERT INTO vjobs(name, description) VALUES
(#name#,#description#)
</insert>

GL



IMO because sometimes one need to insert NULL values too. So why don't you
add another insert statement to your xml that will omit the status field?

On Wed, Mar 18, 2009 at 4:19 AM, Kengkaj Sathianpantarit <
kengkaj.s@gmail.com> wrote:

> However, I think that default value is good in the case that we don't need
> to specify value in INSERT command.
> Why don't you just exclude this field in the <insert>?
>
> For <update>, I think that we should specify value explicitly in the model,
> error from database is correct behavior in case the field has null value
> (actually this is the reason why we set NOT NULL constraint).
>
> Kengkaj
>
>
>
> 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