Jdbcexceptionreporter Sql Error 1452 Sqlstate 23000

here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Hibernate:Cannot add or update a child row: a foreign key constraint fails up vote 0 down vote favorite this error gives me when i try to insert (save) an user using hibernate: //SQL DROP TABLE IF EXISTS `bytecodete`.`account_confirmation`; CREATE TABLE `bytecodete`.`account_confirmation` ( `id` int(11) NOT NULL AUTO_INCREMENT, `email` varchar(255) NOT NULL, PRIMARY KEY (`id`) USING BTREE, KEY `FK_account_confirmation_1` (`email`), CONSTRAINT `FK_account_confirmation_1` FOREIGN KEY (`email`) REFERENCES `user` (`email`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1; // HIBERNATE @Entity @Table(name = "account_confirmation", catalog = "bytecodete") public class AccountConfirmation implements java.io.Serializable { private Integer id; private User user; public AccountConfirmation() { } public AccountConfirmation(User user) { this.user = user; } @Id @GeneratedValue(strategy = IDENTITY) @Column(name = "id", unique = true, nullable = false) public Integer getId() { return this.id; } public void setId(Integer id) { this.id = id; } @ManyToOne(fetch = FetchType.LAZY) @JoinColumn(name = "email", nullable = false) public User getUser() { return this.user; } public void setUser(User user) { this.user = user; } } I first insert the object 'user' in the database then i try to insert this user in this table 'account_confirmation', but isn't possible.. i really don't understand why this happens. Any idea ? EDIT: // LOG4J Hibernate: insert into bytecodete.user (email, password, type) values (?, ?, ?) Hibernate: insert into bytecodete.person (birthDate, cpf, gender, idFacebook, name, tokenFacebook, idUser) values (?, ?, ?, ?, ?, ?, ?) Hibernate: insert into bytecodete.account_confirmation (email) values (?) 18:45:40,745

here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or http://stackoverflow.com/questions/5600602/hibernatecannot-add-or-update-a-child-row-a-foreign-key-constraint-fails update a child row: a foreign key constraint fails up vote 6 down vote favorite 1 I am trying to insert values into my comments table and I am getting a error. Its saying that I can not add or update child row and I have no idea what that means. My schema looks something like this: -- -- Baza danych: `koxu1996_test` -- -- -------------------------------------------------------- -- -- http://stackoverflow.com/questions/17648179/sqlstate23000-integrity-constraint-violation-1452-cannot-add-or-update-a-chi Struktura tabeli dla tabeli `user` -- CREATE TABLE IF NOT EXISTS `user` ( `id` int(8) NOT NULL AUTO_INCREMENT, `username` varchar(32) COLLATE utf8_bin NOT NULL, `password` varchar(64) COLLATE utf8_bin NOT NULL, `password_real` char(32) COLLATE utf8_bin NOT NULL, `email` varchar(32) COLLATE utf8_bin NOT NULL, `code` char(8) COLLATE utf8_bin NOT NULL, `activated` enum('0','1') COLLATE utf8_bin NOT NULL DEFAULT '0', `activation_key` char(32) COLLATE utf8_bin NOT NULL, `reset_key` varchar(32) COLLATE utf8_bin NOT NULL, `name` varchar(32) COLLATE utf8_bin NOT NULL, `street` varchar(32) COLLATE utf8_bin NOT NULL, `house_number` varchar(32) COLLATE utf8_bin NOT NULL, `apartment_number` varchar(32) COLLATE utf8_bin NOT NULL, `city` varchar(32) COLLATE utf8_bin NOT NULL, `zip_code` varchar(32) COLLATE utf8_bin NOT NULL, `phone_number` varchar(16) COLLATE utf8_bin NOT NULL, `country` int(8) NOT NULL, `province` int(8) NOT NULL, `pesel` varchar(32) COLLATE utf8_bin NOT NULL, `register_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `authorised_time` datetime NOT NULL, `edit_time` datetime NOT NULL, `saldo` decimal(9,2) NOT NULL, `referer_id` int(8) NOT NULL, `level` int(8) NOT NULL, PRIMARY KEY (`id`), KEY `country` (`country`), KEY `province` (`province`), KEY `referer_id` (`referer_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=83 ; and the mysql statement I am trying to do looks something like this: INSERT INTO `user` (`password`, `code`, `activation_key`, `reset_key`, `register_time`, `edit_time`, `saldo`, `referer_id`, `level`) VALUES (:yp0, :yp1, :yp2,

Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.

not work correctly without it enabled. Please turn JavaScript back on and reload this page. All Places > Seam > Seam 2 > Discussions Please enter a title. You can not post a blank message. Please type your message and try again. 4 Replies Latest reply on Nov 22, 2008 12:41 AM by Raghunath Nandy Need Help on JPA,Seam mutiple entity persistance Raghunath Nandy Nov 21, 2008 9:12 AM Hi I'm working on MySQL,Seam 2.1 with 2 entities course and branch.. (course and branch tables got Auto incremental ids)Im using JPA,Hibernate with seam.I have a form where i can submit details of a course and multiple branches.` entityManager.persist(course); for (Branch branch : branchs) { if(branch.getTitle()!=null&&!"".equals(branch.getTitle())) { branch.setCourse(course); entityManager.persist(branch); } }But here i'm getting sql error 3:30:54,812 INFO =RegCourse= RegCourse.regCourse() action called with: 13:30:54,812 INFO [STDOUT] Hibernate: insert into engweb1.course (duration, title, id) values (?, ?, ?)13:30:54,828 INFO [STDOUT] Hibernate: insert into engweb1.branch (title, Course_id, acro, id) values (?, ?, ?, ?)13:30:54,828 WARN =JDBCExceptionReporter= SQL Error: 1452, SQLState: 2300013:30:54,828 ERROR =JDBCExceptionReporter= Duplicate key or integrity constraint violation message from server: "Cannot add or update a child row: a foreign key constraint fails (`engweb1/branch`, CONSTRAINT `fk_Branch_Course` FOREIGN KEY (`Course_id`) REFERENCES `course` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION)"13:30:54,828 ERROR [AbstractFlushingEventListener] Could not synchronize database state with sessionorg.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.jdbc 317Views Tags: none (add) This content has been marked as final. Show 4 replies 1. Re: Need Help on JPA,Seam mutiple entity persistance Raghunath Nandy Nov 21, 2008 11:37 AM (in response to Raghunath Nandy) As per my analysis , jpa is performing jdbc batch update, here it's trying to persist branches (which are linked to course) , but course is still not updated in db so it's not able to sync with db in the middle of transaction.Is there any way to split cont