java - Hibernate :Cannot add or update a child row: a foreign key constraint fails -

-

i have issue :

cannot add or update child row: foreign key constraint fails (bytecodete.company_links, constraint fk_company_links_1 foreign key (id) references company (iduser) on delete cascade on update cascade)

but don't understand happens, post tables here:

//user table drop table if exists `bytecodete`.`user`; create table  `bytecodete`.`user` (   `id` int(11) not null auto_increment,   `email` varchar(255) not null,   `password` varchar(255) not null,   `type` tinyint(1) unsigned not null,   primary key (`id`),   unique key `email` (`email`) )  //company table  drop table if exists `bytecodete`.`company`; create table  `bytecodete`.`company` (   `iduser` int(11) not null,   `fantasyname` varchar(55) not null,   `corporatename` varchar(55) not null,   `cnpj` varchar(14) not null,   primary key (`iduser`),   unique key `cnpj` (`cnpj`),   constraint `company_ibfk_1` foreign key (`iduser`) references `user` (`id`)    on delete cascade on update cascade )  // company_links table   drop table if exists `bytecodete`.`company_links`;   create table  `bytecodete`.`company_links` (   `id` int(11) not null default '0',   `idcompany` int(10) unsigned not null,    `servicename` varchar(45) not null,    `link` varchar(45) not null,    primary key (`id`) using btree,    constraint `fk_company_links_1` foreign key (`id`) references `company` (`iduser`)     on delete cascade on update cascade    )

i know exception gives when try insert in table there's foreign key , don't have setup value key. isn't case, here output:

11:47:30,809  info sessionfactoryobjectfactory:82 - not binding factory jndi, no jndi name configured hibernate:      insert              bytecodete.user         (email, password, type)      values         (?, ?, ?) 11:47:30,948 trace stringtype:133 - binding 'valter.bcc@gmail.com' parameter: 1 11:47:30,949 trace stringtype:133 - binding 'u25ym/dol5k=' parameter: 2 11:47:30,950 trace integertype:133 - binding '2' parameter: 3 hibernate:      insert              bytecodete.company         (cnpj, corporatename, fantasyname, iduser)      values         (?, ?, ?, ?) 11:47:31,214 trace stringtype:133 - binding '98806728000100' parameter: 1 11:47:31,215 trace stringtype:133 - binding 'semana da computação e tecnologia' parameter: 2 11:47:31,215 trace stringtype:133 - binding 'secot' parameter: 3 11:47:31,216 trace integertype:133 - binding '37' parameter: 4 idcompany=37 hibernate:      select         company_.iduser,         company_.cnpj cnpj9_,         company_.corporatename corporat3_9_,         company_.fantasyname fantasyn4_9_              bytecodete.company company_              company_.iduser=? 11:47:31,300 trace integertype:133 - binding '37' parameter: 1 11:47:31,316 trace stringtype:172 - returning '98806728000100' column: cnpj9_ 11:47:31,316 trace stringtype:172 - returning 'semana da computação e tecnologia' column: corporat3_9_ 11:47:31,351 trace stringtype:172 - returning 'secot' column: fantasyn4_9_ hibernate:      insert              bytecodete.company_links         (idcompany, link, servicename, id)      values         (?, ?, ?, ?) 11:47:31,353 trace integertype:133 - binding '37' parameter: 1 11:47:31,354 trace stringtype:133 - binding 'http://www.flickr.com/services/api/' parameter: 2 11:47:31,354 trace stringtype:133 - binding 'flickr' parameter: 3 11:47:31,355 trace integertype:133 - binding '0' parameter: 4 11:47:31,433  warn jdbcexceptionreporter:77 - sql error: 1452, sqlstate: 23000 11:47:31,452 error jdbcexceptionreporter:78 - cannot add or update child row: foreign key constraint fails (`bytecodete`.`company_links`, constraint `fk_company_links_1` foreign key (`id`) references `company` (`iduser`) on delete cascade on update cascade)

sorry guys bothering you, need this, don't know what's happen.

best regards, valter henrique.

we'd need see code more, based on insert statements, looks maybe foreign key company_links company wrong. insert company_links has 37 idcompany, , 0 id. foreign key set on id, not idcompany, 37 should set on id, or foreign should changed idcompany.


Comments

Post a Comment

Popular posts from this blog

php - What is the difference between $_SERVER['PATH_INFO'] and $_SERVER['ORIG_PATH_INFO']? -

-
what’s difference between $_server['path_info'] , $_server['orig_path_info'] ? how use them? when run print_r($_server) , path_info , orig_path_info not present in array. why not? how can enable them? i have read php manual on them, still don’t understand them. the path_info variable present if invoke php script this: http://www.example.com/phpinfo.php/hello_there it's /hello_there part after .php script. if don't invoke url that, there won't $_server["path_info"] environment variable. the porig_ prefix uncommon. path_info standard cgi-environment variable, , should never prefixed. did read that? (there issues around php3/php4 if invoked php interpreter via cgi-bin/ - hardly has such setups today.) for reference: http://www.ietf.org/rfc/rfc3875
Read more

fortran - Function return type mismatch -

-
i'm attempting recode old c++ program in fortran make use of lapack (i'm aware c++ have lapack++, i'm having lot of trouble installing it, gave up). i didn't have problems compilation, when had variables declared real . when started coding section of program required lapack, found parameters passed dsyev need double precision . tried change double precision (including changing hard coded numbers double precision counterparts, i.e. 0.0 -> 0.0d0) when try compile, following error of functions , subroutines i've written: error: return type mismatch of function <function> @ (1) (real(4)/real(8)) i'm not sure coming from, in program has been changed double precision. for example, i've declared following: double precision :: alpha(3),d(3),zeta1,zeta2 double precision :: a1(3),a2(3),d1(3),d2(3) double precision :: pi pi = 3.14159265359d0 alpha = (/0.109818d0, 0.405771d0, 2.22766d0/) d = (/0.444635d0, 0.535328d0, 0.154329d0 /) 10 i=1,3 ...
Read more

queue - mq_receive: message too long -

-
i implementing communication between 2 processes using queue. problem when call function mq_receive, error: message long. i have done following: struct mq_attr attr; long size = attr.mq_msgsize; .... // initializing queue "/gateway" int rc = mq_receive(gateway, buffer, size, &prio); if print size value, size=1, while when print same size program (got same mechanism), not long integer ( -1217186280 )... how can solve error?....so while size = 1, believe it's right "message long" why 1? p.s. have tried put : int rc = mq_receive(gateway, buffer, sizeof(buffer), &prio); but no result. it seems need read docs more carefully. when call mq_receive should pass size of destination buffer. this size must greater mq_msgsize attribute of queue . in addition, seems have error in queue attributes initialisation makes proper mq_receive call impossible. here standard message queue session: fill mq_attr struct ( doc ): struct mq_a...
Read more