[hibernate-issues] [Hibernate-JIRA] Commented: (EJB-348) Problem with CasCadeType.ALL during persist when processing OneToMany hierarchy relationship

[George Daswani (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/EJB-348?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_29890 ] 

George Daswani commented on EJB-348:
------------------------------------

please cancel or disregard this submission as "NOT A BUG".

I double checked with OpenJPA and basically - I annotated the OneToMany side wrong (should have RTFM).

For bidirectional OneToMany relationships, the OneToMany side "SHOULD NOT" have the @JoinColumn attribute listed as the "mappedBy" attribute already signifies that it's bidirectional.

so basically from this

@OneToMany(cascade = { CascadeType.ALL }, fetch = FetchType.LAZY, mappedBy = "networkInterface")
@JoinColumn(name = "IP_ID")
public Set<IPAddress> getIPAddresses() 

to just this

@OneToMany(cascade = { CascadeType.ALL }, fetch = FetchType.LAZY, mappedBy = "networkInterface")
public Set<IPAddress> getIPAddresses() 

> Problem with CasCadeType.ALL during persist when processing OneToMany hierarchy relationship
> --------------------------------------------------------------------------------------------
>
>                 Key: EJB-348
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/EJB-348
>             Project: Hibernate Entity Manager
>          Issue Type: Bug
>          Components: EntityManager
>    Affects Versions: 3.3.2.GA
>         Environment: 3.2.2.GA , Microsoft SQL Server 2000 SP4, JTDS 1.2.2 Drive
>            Reporter: George Daswani
>         Attachments: TestProject.zip
>
>
> [Computer]
> private Set<NetworkInterface> networkInterfaces ;
> @OneToMany(cascade = { CascadeType.ALL }, fetch = FetchType.LAZY, mappedBy = "computer")
> @JoinColumn(name = "COMPUTER_ID")
> public Set<NetworkInterface> getNetworkInterfaces()
> --------------------- 
> [Network Interface]
> private Computer computer;
> private Set<IPAddress> ipAddresses;
> @ManyToOne(fetch = FetchType.EAGER)
> @JoinColumn(name = "CMP_ID", nullable = false)
> public Computer getComputer()
> @OneToMany(cascade = { CascadeType.ALL }, fetch = FetchType.LAZY, mappedBy = "networkInterface")
> @JoinColumn(name = "IP_ID")
> public Set<IPAddress> getIPAddresses()
> --------------------- 
> [IPAddress]
> private NetworkInterface networkInterface;
> @ManyToOne(fetch = FetchType.EAGER)
> @JoinColumn(name = "NI_ID", nullable = false)
> public NetworkInterface getNetworkInterface()
> ---------------------------------------------------------------------------------------------------
> Note: works just fine with TopLink Essentials.
> When two or more IP addresses are added to a network interface, Hibernate JPA errors out when persisting the "Computer".
> Example:
> Computer computer = new Computer();
> // ASSIGNED ID
> computer.setId("COMPUTER1");
> computer.setAssetTag("AC1");
> NetworkInterface networkInterface = new NetworkInterface();
> networkInterface.setMacAddress("00:00:00:00:00:00");
> computer.addNetworkInterface(networkInterface);
> IPAddress ipAddress1 = new IPAddress();
> ipAddress1.setIpAddress("192.168.1.1");
> networkInterface.addIpAddress(ipAddress1);
> IPAddress ipAddress2 = new IPAddress();
> ipAddress2.setIpAddress("192.168.1.2");
> networkInterface.addIpAddress(ipAddress2);
> entityManager.persist(computer);
> ---------------- ERROR -----------
> - INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'FK92788228A23'. The conflict occurred in database 'TestDB', table 'NI', column 'NI_ID'.
> - Could not synchronize database state with session
> org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
> Caused by: java.sql.BatchUpdateException: INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'FK92788228A23'. The conflict occurred in database 'TestDB', table 'NI', column 'NI_ID'.
> seems like some sort of wrong INSERTION order.
> I've attached the eclipse project with the - test case in "test/Test.java"

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira