[Hibernate-JIRA] Created: (HHH-5529) Bulk delete on Entity with @ElementCollection ignores the @CollectionTable
5:35 p.m.
Bulk delete on Entity with @ElementCollection ignores the @CollectionTable
--------------------------------------------------------------------------
Key: HHH-5529
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5529
Project: Hibernate Core
Issue Type: Bug
Components: entity-manager
Affects Versions: 3.6.0.Beta4, 3.6.0.Beta3, 3.5.5, 3.6.0.Beta2, 3.6.0.Beta1, 3.5.4,
3.5.3, 3.5.2, 3.5.1, 3.5.0-Final, 3.5.0-CR-2, 3.5.0-CR-1, 3.5.0-Beta-4, 3.5.0-Beta-3,
3.5.0-Beta-2, 3.5.0.Beta-1
Environment: Hibernate 3.5.x, all database, all platforms.
Reporter: Pascal Thivent
Attachments: HHH-XXX.tar.gz
I have an entity with a collection of basic elements mapped with @ElementCollection:
{code}
@Entity
public class Foo {
@Id @GeneratedValue
private Long id;
@ElementCollection
@Column(name = "bar_column")
@CollectionTable(name = "Bar")
private Set<String> bars = new HashSet<String>();
public Long getId() { return id; }
public void setId(Long id) { this.id = id; }
public Set<String> getBars() { return bars; }
public void setBars(Set<String> bars) { this.bars = bars; }
}
{code}
A bulk delete on this entity fails due to constraint violation on the collection table
(Hibernate ignores the collection table).
I don't think that the following cascading restriction from the JPA 2.0 specification
applies:
{quote}
h3. 4.10 Bulk Update and Delete Operations
...
A delete operation only applies to entities of the specified class and its subclasses. It
does not cascade to related entities.
{quote}
In other words, Hibernate should handle the collection table as we have no way to bulk
delete the basic elements from the collection table.
I have attached a test case allowing to reproduce the issue.
--
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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
5:43 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-5529) Bulk delete on Entity with @ElementCollection ignores the @CollectionTable
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-5529?page=c...
]
Pascal Thivent commented on HHH-5529:
-------------------------------------
Sorry, didn't notice someone created the same issue a bit earlier. Will attach my test
case on the existing issue. This one is 100% a dupe and can be closed.
Bulk delete on Entity with @ElementCollection ignores the
@CollectionTable
--------------------------------------------------------------------------
Key: HHH-5529
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5529
Project: Hibernate Core
Issue Type: Bug
Components: entity-manager
Affects Versions: 3.5.0.Beta-1, 3.5.0-Beta-2, 3.5.0-Beta-3, 3.5.0-Beta-4, 3.5.0-CR-1,
3.5.0-CR-2, 3.5.0-Final, 3.5.1, 3.5.2, 3.5.3, 3.5.4, 3.6.0.Beta1, 3.6.0.Beta2, 3.5.5,
3.6.0.Beta3, 3.6.0.Beta4
Environment: Hibernate 3.5.x, all database, all platforms.
Reporter: Pascal Thivent
Attachments: HHH-XXX.tar.gz
I have an entity with a collection of basic elements mapped with @ElementCollection:
{code}
@Entity
public class Foo {
@Id @GeneratedValue
private Long id;
@ElementCollection
@Column(name = "bar_column")
@CollectionTable(name = "Bar")
private Set<String> bars = new HashSet<String>();
public Long getId() { return id; }
public void setId(Long id) { this.id = id; }
public Set<String> getBars() { return bars; }
public void setBars(Set<String> bars) { this.bars = bars; }
}
{code}
A bulk delete on this entity fails due to constraint violation on the collection table
(Hibernate ignores the collection table).
I don't think that the following cascading restriction from the JPA 2.0 specification
applies:
{quote}
h3. 4.10 Bulk Update and Delete Operations
...
A delete operation only applies to entities of the specified class and its subclasses. It
does not cascade to related entities.
{quote}
In other words, Hibernate should handle the collection table as we have no way to bulk
delete the basic elements from the collection table.
I have attached a test case allowing to reproduce the issue.
--
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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
5:45 p.m.
New subject: [Hibernate-JIRA] Issue Comment Edited: (HHH-5529) Bulk delete on Entity with @ElementCollection ignores the @CollectionTable
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-5529?page=c...
]
Pascal Thivent edited comment on HHH-5529 at 9/2/10 5:43 PM:
-------------------------------------------------------------
Sorry, didn't notice someone created the same issue a bit earlier. Will attach my test
case on the existing issue. This one duplicates it.
was (Author: pthivent):
Sorry, didn't notice someone created the same issue a bit earlier. Will attach my
test case on the existing issue. This one is 100% a dupe and can be closed.
Bulk delete on Entity with @ElementCollection ignores the
@CollectionTable
--------------------------------------------------------------------------
Key: HHH-5529
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5529
Project: Hibernate Core
Issue Type: Bug
Components: entity-manager
Affects Versions: 3.5.0.Beta-1, 3.5.0-Beta-2, 3.5.0-Beta-3, 3.5.0-Beta-4, 3.5.0-CR-1,
3.5.0-CR-2, 3.5.0-Final, 3.5.1, 3.5.2, 3.5.3, 3.5.4, 3.6.0.Beta1, 3.6.0.Beta2, 3.5.5,
3.6.0.Beta3, 3.6.0.Beta4
Environment: Hibernate 3.5.x, all database, all platforms.
Reporter: Pascal Thivent
Attachments: HHH-XXX.tar.gz
I have an entity with a collection of basic elements mapped with @ElementCollection:
{code}
@Entity
public class Foo {
@Id @GeneratedValue
private Long id;
@ElementCollection
@Column(name = "bar_column")
@CollectionTable(name = "Bar")
private Set<String> bars = new HashSet<String>();
public Long getId() { return id; }
public void setId(Long id) { this.id = id; }
public Set<String> getBars() { return bars; }
public void setBars(Set<String> bars) { this.bars = bars; }
}
{code}
A bulk delete on this entity fails due to constraint violation on the collection table
(Hibernate ignores the collection table).
I don't think that the following cascading restriction from the JPA 2.0 specification
applies:
{quote}
h3. 4.10 Bulk Update and Delete Operations
...
A delete operation only applies to entities of the specified class and its subclasses. It
does not cascade to related entities.
{quote}
In other words, Hibernate should handle the collection table as we have no way to bulk
delete the basic elements from the collection table.
I have attached a test case allowing to reproduce the issue.
--
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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
10:06 p.m.
New subject: [Hibernate-JIRA] Updated: (HHH-5529) Bulk delete on Entity with @ElementCollection ignores the @CollectionTable
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-5529?page=c...
]
Steve Ebersole updated HHH-5529:
--------------------------------
Affects Version/s: (was: 3.6.0.Beta3)
(was: 3.6.0.Beta2)
(was: 3.5.4)
(was: 3.5.3)
(was: 3.5.2)
(was: 3.5.0-Final)
(was: 3.5.1)
(was: 3.5.0-CR-1)
(was: 3.5.0-Beta-4)
(was: 3.5.0-CR-2)
(was: 3.5.0-Beta-3)
(was: 3.5.0-Beta-2)
(was: 3.6.0.Beta1)
(was: 3.5.0.Beta-1)
3.3.2
Issue Type: New Feature (was: Bug)
I really dont get how people extract "bug" from something that is explicitly
documented to not happen that way.
Bulk delete on Entity with @ElementCollection ignores the
@CollectionTable
--------------------------------------------------------------------------
Key: HHH-5529
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5529
Project: Hibernate Core
Issue Type: New Feature
Components: entity-manager
Affects Versions: 3.3.2, 3.5.5, 3.6.0.Beta4
Environment: Hibernate 3.5.x, all database, all platforms.
Reporter: Pascal Thivent
Attachments: HHH-XXX.tar.gz
I have an entity with a collection of basic elements mapped with @ElementCollection:
{code}
@Entity
public class Foo {
@Id @GeneratedValue
private Long id;
@ElementCollection
@Column(name = "bar_column")
@CollectionTable(name = "Bar")
private Set<String> bars = new HashSet<String>();
public Long getId() { return id; }
public void setId(Long id) { this.id = id; }
public Set<String> getBars() { return bars; }
public void setBars(Set<String> bars) { this.bars = bars; }
}
{code}
A bulk delete on this entity fails due to constraint violation on the collection table
(Hibernate ignores the collection table).
I don't think that the following cascading restriction from the JPA 2.0 specification
applies:
{quote}
h3. 4.10 Bulk Update and Delete Operations
...
A delete operation only applies to entities of the specified class and its subclasses. It
does not cascade to related entities.
{quote}
In other words, Hibernate should handle the collection table as we have no way to bulk
delete the basic elements from the collection table.
I have attached a test case allowing to reproduce the issue.
--
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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
10:56 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-5529) Bulk delete on Entity with @ElementCollection ignores the @CollectionTable
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-5529?page=c...
]
Pascal Thivent commented on HHH-5529:
-------------------------------------
Steve, the spec is about cascading to related entities, isn't it? I can understand
that, that's fine, and this can be handled "manually" (bugs aside). But
please, explain me how to deal with a collection table for which there is no entity. Are
you saying that it is just not possible to use a bulk delete in such case? This would be a
very particular interpretation of the spec, and a very restrictive one. I find that
it's a legitimate use case and the spec doesn't forbid it, does it?
Bulk delete on Entity with @ElementCollection ignores the
@CollectionTable
--------------------------------------------------------------------------
Key: HHH-5529
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5529
Project: Hibernate Core
Issue Type: New Feature
Components: entity-manager
Affects Versions: 3.3.2, 3.5.5, 3.6.0.Beta4
Environment: Hibernate 3.5.x, all database, all platforms.
Reporter: Pascal Thivent
Attachments: HHH-XXX.tar.gz
I have an entity with a collection of basic elements mapped with @ElementCollection:
{code}
@Entity
public class Foo {
@Id @GeneratedValue
private Long id;
@ElementCollection
@Column(name = "bar_column")
@CollectionTable(name = "Bar")
private Set<String> bars = new HashSet<String>();
public Long getId() { return id; }
public void setId(Long id) { this.id = id; }
public Set<String> getBars() { return bars; }
public void setBars(Set<String> bars) { this.bars = bars; }
}
{code}
A bulk delete on this entity fails due to constraint violation on the collection table
(Hibernate ignores the collection table).
I don't think that the following cascading restriction from the JPA 2.0 specification
applies:
{quote}
h3. 4.10 Bulk Update and Delete Operations
...
A delete operation only applies to entities of the specified class and its subclasses. It
does not cascade to related entities.
{quote}
In other words, Hibernate should handle the collection table as we have no way to bulk
delete the basic elements from the collection table.
I have attached a test case allowing to reproduce the issue.
--
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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 p.m.
New subject: [Hibernate-JIRA] Issue Comment Edited: (HHH-5529) Bulk delete on Entity with @ElementCollection ignores the @CollectionTable
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-5529?page=c...
]
Pascal Thivent edited comment on HHH-5529 at 9/2/10 11:00 PM:
--------------------------------------------------------------
Well, the spec simply doesn't forbid this use case (a collection of items isn't a
collection of entity) so I just thought not supporting it could be qualified as a bug.
Apologies for not using "New Feature".
was (Author: pthivent):
Steve, the spec is about cascading to related entities, isn't it? I can understand
that, that's fine, and this can be handled "manually" (bugs aside). But
please, explain me how to deal with a collection table for which there is no entity. Are
you saying that it is just not possible to use a bulk delete in such case? This would be a
very particular interpretation of the spec, and a very restrictive one. I find that
it's a legitimate use case and the spec doesn't forbid it, does it?
Bulk delete on Entity with @ElementCollection ignores the
@CollectionTable
--------------------------------------------------------------------------
Key: HHH-5529
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5529
Project: Hibernate Core
Issue Type: New Feature
Components: entity-manager
Affects Versions: 3.3.2, 3.5.5, 3.6.0.Beta4
Environment: Hibernate 3.5.x, all database, all platforms.
Reporter: Pascal Thivent
Attachments: HHH-XXX.tar.gz
I have an entity with a collection of basic elements mapped with @ElementCollection:
{code}
@Entity
public class Foo {
@Id @GeneratedValue
private Long id;
@ElementCollection
@Column(name = "bar_column")
@CollectionTable(name = "Bar")
private Set<String> bars = new HashSet<String>();
public Long getId() { return id; }
public void setId(Long id) { this.id = id; }
public Set<String> getBars() { return bars; }
public void setBars(Set<String> bars) { this.bars = bars; }
}
{code}
A bulk delete on this entity fails due to constraint violation on the collection table
(Hibernate ignores the collection table).
I don't think that the following cascading restriction from the JPA 2.0 specification
applies:
{quote}
h3. 4.10 Bulk Update and Delete Operations
...
A delete operation only applies to entities of the specified class and its subclasses. It
does not cascade to related entities.
{quote}
In other words, Hibernate should handle the collection table as we have no way to bulk
delete the basic elements from the collection table.
I have attached a test case allowing to reproduce the issue.
--
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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
11:02 p.m.
New subject: [Hibernate-JIRA] Issue Comment Edited: (HHH-5529) Bulk delete on Entity with @ElementCollection ignores the @CollectionTable
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-5529?page=c...
]
Pascal Thivent edited comment on HHH-5529 at 9/2/10 11:01 PM:
--------------------------------------------------------------
Well, the spec simply doesn't forbid this use case (a collection of items isn't a
collection of entity) so I just thought that not supporting this use case could be
qualified as a "Bug". Apologies for not using "New Feature".
was (Author: pthivent):
Well, the spec simply doesn't forbid this use case (a collection of items
isn't a collection of entity) so I just thought not supporting it could be qualified
as a bug. Apologies for not using "New Feature".
Bulk delete on Entity with @ElementCollection ignores the
@CollectionTable
--------------------------------------------------------------------------
Key: HHH-5529
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5529
Project: Hibernate Core
Issue Type: New Feature
Components: entity-manager
Affects Versions: 3.3.2, 3.5.5, 3.6.0.Beta4
Environment: Hibernate 3.5.x, all database, all platforms.
Reporter: Pascal Thivent
Attachments: HHH-XXX.tar.gz
I have an entity with a collection of basic elements mapped with @ElementCollection:
{code}
@Entity
public class Foo {
@Id @GeneratedValue
private Long id;
@ElementCollection
@Column(name = "bar_column")
@CollectionTable(name = "Bar")
private Set<String> bars = new HashSet<String>();
public Long getId() { return id; }
public void setId(Long id) { this.id = id; }
public Set<String> getBars() { return bars; }
public void setBars(Set<String> bars) { this.bars = bars; }
}
{code}
A bulk delete on this entity fails due to constraint violation on the collection table
(Hibernate ignores the collection table).
I don't think that the following cascading restriction from the JPA 2.0 specification
applies:
{quote}
h3. 4.10 Bulk Update and Delete Operations
...
A delete operation only applies to entities of the specified class and its subclasses. It
does not cascade to related entities.
{quote}
In other words, Hibernate should handle the collection table as we have no way to bulk
delete the basic elements from the collection table.
I have attached a test case allowing to reproduce the issue.
--
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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
11:04 p.m.
New subject: [Hibernate-JIRA] Issue Comment Edited: (HHH-5529) Bulk delete on Entity with @ElementCollection ignores the @CollectionTable
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-5529?page=c...
]
Pascal Thivent edited comment on HHH-5529 at 9/2/10 11:04 PM:
--------------------------------------------------------------
Well, the JPA 2.0 spec simply doesn't forbid this use case (a collection of items
isn't a collection of entity), so support is implied and I just thought that
qualifying the problem as a "Bug" was appropriate. Apologies for not using
"New Feature".
was (Author: pthivent):
Well, the spec simply doesn't forbid this use case (a collection of items
isn't a collection of entity) so I just thought that not supporting this use case
could be qualified as a "Bug". Apologies for not using "New Feature".
Bulk delete on Entity with @ElementCollection ignores the
@CollectionTable
--------------------------------------------------------------------------
Key: HHH-5529
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5529
Project: Hibernate Core
Issue Type: New Feature
Components: entity-manager
Affects Versions: 3.3.2, 3.5.5, 3.6.0.Beta4
Environment: Hibernate 3.5.x, all database, all platforms.
Reporter: Pascal Thivent
Attachments: HHH-XXX.tar.gz
I have an entity with a collection of basic elements mapped with @ElementCollection:
{code}
@Entity
public class Foo {
@Id @GeneratedValue
private Long id;
@ElementCollection
@Column(name = "bar_column")
@CollectionTable(name = "Bar")
private Set<String> bars = new HashSet<String>();
public Long getId() { return id; }
public void setId(Long id) { this.id = id; }
public Set<String> getBars() { return bars; }
public void setBars(Set<String> bars) { this.bars = bars; }
}
{code}
A bulk delete on this entity fails due to constraint violation on the collection table
(Hibernate ignores the collection table).
I don't think that the following cascading restriction from the JPA 2.0 specification
applies:
{quote}
h3. 4.10 Bulk Update and Delete Operations
...
A delete operation only applies to entities of the specified class and its subclasses. It
does not cascade to related entities.
{quote}
In other words, Hibernate should handle the collection table as we have no way to bulk
delete the basic elements from the collection table.
I have attached a test case allowing to reproduce the issue.
--
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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
11:22 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-5529) Bulk delete on Entity with @ElementCollection ignores the @CollectionTable
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-5529?page=c...
]
James Wong commented on HHH-5529:
---------------------------------
Just for clarification. Does this mean when using hibernate, the only way to delete
objects that use an @ElementCollection annotation must be deleted one by one. ie by doing
a query and then individually deleting each object?
Bulk delete on Entity with @ElementCollection ignores the
@CollectionTable
--------------------------------------------------------------------------
Key: HHH-5529
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5529
Project: Hibernate Core
Issue Type: New Feature
Components: entity-manager
Affects Versions: 3.3.2, 3.5.5, 3.6.0.Beta4
Environment: Hibernate 3.5.x, all database, all platforms.
Reporter: Pascal Thivent
Attachments: HHH-XXX.tar.gz
I have an entity with a collection of basic elements mapped with @ElementCollection:
{code}
@Entity
public class Foo {
@Id @GeneratedValue
private Long id;
@ElementCollection
@Column(name = "bar_column")
@CollectionTable(name = "Bar")
private Set<String> bars = new HashSet<String>();
public Long getId() { return id; }
public void setId(Long id) { this.id = id; }
public Set<String> getBars() { return bars; }
public void setBars(Set<String> bars) { this.bars = bars; }
}
{code}
A bulk delete on this entity fails due to constraint violation on the collection table
(Hibernate ignores the collection table).
I don't think that the following cascading restriction from the JPA 2.0 specification
applies:
{quote}
h3. 4.10 Bulk Update and Delete Operations
...
A delete operation only applies to entities of the specified class and its subclasses. It
does not cascade to related entities.
{quote}
In other words, Hibernate should handle the collection table as we have no way to bulk
delete the basic elements from the collection table.
I have attached a test case allowing to reproduce the issue.
--
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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
6:15 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-5529) Bulk delete on Entity with @ElementCollection ignores the @CollectionTable
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-5529?page=c...
]
Steve Ebersole commented on HHH-5529:
-------------------------------------
Specs by nature are inclusive of what they support, the set of features they do not
support being much larger.
And regardless I am talking about the Hibernate documentation, which explicitly states
this will not happen.
The same question holds for the association table for many-to-many associations.
James, no. You could also (a) clean up the collection table yourself or (b) use cascading
foreign keys in the schema.
Bulk delete on Entity with @ElementCollection ignores the
@CollectionTable
--------------------------------------------------------------------------
Key: HHH-5529
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5529
Project: Hibernate Core
Issue Type: New Feature
Components: entity-manager
Affects Versions: 3.3.2, 3.5.5, 3.6.0.Beta4
Environment: Hibernate 3.5.x, all database, all platforms.
Reporter: Pascal Thivent
Attachments: HHH-XXX.tar.gz
I have an entity with a collection of basic elements mapped with @ElementCollection:
{code}
@Entity
public class Foo {
@Id @GeneratedValue
private Long id;
@ElementCollection
@Column(name = "bar_column")
@CollectionTable(name = "Bar")
private Set<String> bars = new HashSet<String>();
public Long getId() { return id; }
public void setId(Long id) { this.id = id; }
public Set<String> getBars() { return bars; }
public void setBars(Set<String> bars) { this.bars = bars; }
}
{code}
A bulk delete on this entity fails due to constraint violation on the collection table
(Hibernate ignores the collection table).
I don't think that the following cascading restriction from the JPA 2.0 specification
applies:
{quote}
h3. 4.10 Bulk Update and Delete Operations
...
A delete operation only applies to entities of the specified class and its subclasses. It
does not cascade to related entities.
{quote}
In other words, Hibernate should handle the collection table as we have no way to bulk
delete the basic elements from the collection table.
I have attached a test case allowing to reproduce the issue.
--
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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
9:45 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-5529) Bulk delete on Entity with @ElementCollection ignores the @CollectionTable
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-5529?page=c...
]
Ling Lin commented on HHH-5529:
-------------------------------
I am having this exact same problem! Is there a work around? I cant work out a way to
solve this problem without manually pulling out each object from the database and removing
each object from the element collection!
Bulk delete on Entity with @ElementCollection ignores the
@CollectionTable
--------------------------------------------------------------------------
Key: HHH-5529
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5529
Project: Hibernate Core
Issue Type: New Feature
Components: entity-manager
Affects Versions: 3.3.2, 3.5.5, 3.6.0.Beta4
Environment: Hibernate 3.5.x, all database, all platforms.
Reporter: Pascal Thivent
Attachments: HHH-XXX.tar.gz
I have an entity with a collection of basic elements mapped with @ElementCollection:
{code}
@Entity
public class Foo {
@Id @GeneratedValue
private Long id;
@ElementCollection
@Column(name = "bar_column")
@CollectionTable(name = "Bar")
private Set<String> bars = new HashSet<String>();
public Long getId() { return id; }
public void setId(Long id) { this.id = id; }
public Set<String> getBars() { return bars; }
public void setBars(Set<String> bars) { this.bars = bars; }
}
{code}
A bulk delete on this entity fails due to constraint violation on the collection table
(Hibernate ignores the collection table).
I don't think that the following cascading restriction from the JPA 2.0 specification
applies:
{quote}
h3. 4.10 Bulk Update and Delete Operations
...
A delete operation only applies to entities of the specified class and its subclasses. It
does not cascade to related entities.
{quote}
In other words, Hibernate should handle the collection table as we have no way to bulk
delete the basic elements from the collection table.
I have attached a test case allowing to reproduce the issue.
--
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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
5:44 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-5529) Bulk delete on Entity with @ElementCollection ignores the @CollectionTable
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-5529?page=c...
]
James Howe commented on HHH-5529:
---------------------------------
As the JPA wikibook explains : "There is no cascade option on an ElementCollection,
the target objects are always persisted, merged, removed with their parent."
Embeddable entities and Basic types should have the same lifetime as their owner,
effectively all operations should cascade.
Bulk delete on Entity with @ElementCollection ignores the
@CollectionTable
--------------------------------------------------------------------------
Key: HHH-5529
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5529
Project: Hibernate Core
Issue Type: New Feature
Components: entity-manager
Affects Versions: 3.3.2, 3.5.5, 3.6.0.Beta4
Environment: Hibernate 3.5.x, all database, all platforms.
Reporter: Pascal Thivent
Attachments: HHH-XXX.tar.gz
I have an entity with a collection of basic elements mapped with @ElementCollection:
{code}
@Entity
public class Foo {
@Id @GeneratedValue
private Long id;
@ElementCollection
@Column(name = "bar_column")
@CollectionTable(name = "Bar")
private Set<String> bars = new HashSet<String>();
public Long getId() { return id; }
public void setId(Long id) { this.id = id; }
public Set<String> getBars() { return bars; }
public void setBars(Set<String> bars) { this.bars = bars; }
}
{code}
A bulk delete on this entity fails due to constraint violation on the collection table
(Hibernate ignores the collection table).
I don't think that the following cascading restriction from the JPA 2.0 specification
applies:
{quote}
h3. 4.10 Bulk Update and Delete Operations
...
A delete operation only applies to entities of the specified class and its subclasses. It
does not cascade to related entities.
{quote}
In other words, Hibernate should handle the collection table as we have no way to bulk
delete the basic elements from the collection table.
I have attached a test case allowing to reproduce the issue.
--
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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
5045
days inactive
5182
days old
hibernate-issues@lists.jboss.org
11 comments
5 participants
participants (5)
-
James Howe (JIRA) -
James Wong (JIRA)
-
Ling Lin (JIRA)
-
Pascal Thivent (JIRA)
-
Steve Ebersole (JIRA)