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 >