ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alin Popa <alin.p...@gmail.com>
Subject Re: mysql default value
Date Wed, 18 Mar 2009 08:06:04 GMT
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