<html> <head> <meta http-equiv="content-type" content="text/html; charset=ISO-2022-JP"> </head> <body bgcolor="#FFFFFF" text="#000000"> <div class="moz-text-plain" wrap="true" style="font-family: -moz-fixed; font-size: 16px;" lang="ja"> <pre wrap="">$B?\ED$H?=$7$^$9!#(B $B$*@$OC$K$J$C$F$*$j$^$9!#(B S2JDBC$B$rMxMQ$7$F$$$k$N$G$9$,!"0J2<$N%(%i!<$,H/@8$7$F$7$^$$$^$9!#(B $B%m%0=PNO$5$l$F$$$k(BSQL$B$r(BMySQL$B$G<B9T$9$k$H!"(B ERROR 1366 (HY000): Incorrect integer value: 'true' for column 'SYSTEM_FLG' at row 1 $B$H$J$k$?$a!"(Bboolean$B7?$KJ8;zNs$r@_Dj$7$h$&$H$7$F$$$k$N$,860x$H;W$o$l$k$N$G$9$,!"(B $B2r7h$9$k$K$O$I$N$h$&$J@_Dj$r$9$l$P$h$$$G$7$g$&$+!)(B --- $B%m%0(B --- DEBUG 2011-07-28 16:44:45,671 ["http-bio-8080"-exec-7] update user set ACCOUNT = 'admin', NAME = '$B%7%9%F%`4IM}<T(B', PASSWORD = 'password', MAIL_ADDRESS = '', SYSTEM_FLG = 'true', DEPARTMENT_ID = 0, CREATE_TIMESTAMP = '2011-07-08 00:03:23', UPDATE_TIMESTAMP = '2011-07-28 16:44:45.671000000', DELETE_TIMESTAMP = null, VERSION = VERSION + 1 where ID = 1 and VERSION = 0 DEBUG 2011-07-28 16:44:45,671 ["http-bio-8080"-exec-7] END jp.co.interaction_i.service.UserService#update(jp.co.interaction_i.entity.User@f94083) Throwable:org.seasar.framework.exception.SQLRuntimeException: [ESSR0072]SQL$B$GNc30(B(SQL=[update user set ACCOUNT = ?, NAME = ?, PASSWORD = ?, MAIL_ADDRESS = ?, SYSTEM_FLG = ?, DEPARTMENT_ID = ?, CREATE_TIMESTAMP = ?, UPDATE_TIMESTAMP = ?, DELETE_TIMESTAMP = ?, VERSION = VERSION + 1 where ID = ? and VERSION = ?], Message=[[ESSR0072]SQL$B$GNc30(B(SQL=[update user set ACCOUNT = ?, NAME = ?, PASSWORD = ?, MAIL_ADDRESS = ?, SYSTEM_FLG = ?, DEPARTMENT_ID = ?, CREATE_TIMESTAMP = ?, UPDATE_TIMESTAMP = ?, DELETE_TIMESTAMP = ?, VERSION = VERSION + 1 where ID = ? and VERSION = ?], Message=[1452], ErrorCode=23000, SQLState={3})$B$,H/@8$7$^$7$?(B : [SQL$B$GNc30(B(Message=[Cannot add or update a child row: a foreign key constraint fails (`sgpr001`.`user`, CONSTRAINT `user_FK1` FOREIGN KEY (`DEPARTMENT_ID`) REFERENCES `department` (`ID` ))], ErrorCode=1452, SQLState=23000)$B$,H/@8$7$^$7$?!#(B], [Cannot add or update a child row: a foreign key constraint fails (`sgpr001`.`user`, CONSTRAINT `user_FK1` FOREIGN KEY (`DEPARTMENT_ID`) REFERENCES `department` (`ID`))], ErrorCode=1452, SQLState=23000)$B$,H/@8$7$^$7$?(B DEBUG 2011-07-28 16:44:45,718 ["http-bio-8080"-exec-7] $B%H%i%s%6%/%7%g%s$r%m!<%k%P%C%/$7$^$7$?!#(Btx=[FormatId=4360, GlobalId=1311838291468/17, BranchId=] --- DDL --- create table user ( ID bigint not null auto_increment, ACCOUNT varchar(20) not null, NAME varchar(50), PASSWORD varchar(20) not null, MAIL_ADDRESS varchar(255), SYSTEM_FLG boolean default false, DEPARTMENT_ID bigint, CREATE_TIMESTAMP datetime, UPDATE_TIMESTAMP datetime, DELETE_TIMESTAMP datetime, VERSION bigint, constraint user_PK primary key(ID) ); --- $B%(%s%F%#%F%#(B($B0lIt(B) --- /** * $B%7%9%F%`%U%i%0(B */ @Column(columnDefinition="default false") public boolean systemFlg; --- jdbc.dicon --- <component name="xaDataSource" class="org.seasar.extension.dbcp.impl.XADataSourceImpl"> <property name="driverClassName"> "com.mysql.jdbc.Driver" </property> <property name="URL"> "jdbc:mysql://localhost:3306/proj001" </property> <property name="user">"projuser"</property> <property name="password">"projpass"</property> </component> --- $B4D6-(B --- jdk:1.6.0_24 Seasar:2.4.44 SaStruts:1.0.4-sp8 S2jdbc-gen:2.4.44 Eclipse:Indigo(build id:20110615-0604) Dolteng:0.41.0 Apatche-tomcat:7.0.16 MySQL:essential-5.1.57 </pre> </div> </body> </html>