July 2012 - hibernate-issues - Jboss List Archives

[Hibernate-JIRA] Created: (OGM-177) Make true associations be stored in the entity document in MongoDB

by Emmanuel Bernard (JIRA)

Make true associations be stored in the entity document in MongoDB ------------------------------------------------------------------ Key: OGM-177 URL: https://hibernate.onjira.com/browse/OGM-177 Project: Hibernate OGM Issue Type: New Feature Components: datastore Reporter: Emmanuel Bernard Priority: Minor -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 10 months

2
5
0 / 0

[Hibernate-JIRA] (HHH-7434) Locking a proxy in LockMode.WRITE doesn't increment @version attribute the first time

by Michaël Chagnon (JIRA)

11 years, 10 months

1
0
0 / 0

[Hibernate-JIRA] (HHH-7374) Support KEY, ENTRY and VALUE qualifiers in WHERE clause

by Raivis Kalinins (JIRA)

11 years, 10 months

1
0
0 / 0

[Hibernate-JIRA] Created: (HHH-5719) Applying projection to criteria with restricted subcriterias generates wrong SQL

by Victor Cherkassky (JIRA)

Applying projection to criteria with restricted subcriterias generates wrong SQL -------------------------------------------------------------------------------- Key: HHH-5719 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5719 Project: Hibernate Core Issue Type: Bug Components: query-criteria Affects Versions: 3.2.0.ga Environment: Hibernate 3.2.0 GA Reporter: Victor Cherkassky Priority: Minor Detailed issue description and solution is here http://facingtech.blogspot.com/2010_09_01_archive.html I will describe only the technical aspect of the issue here. Considuer the following model. There is an entity {{User}}, which is in relation with {{Workplace}}. While {{Workplace}} has an {{Activity}} (the purpose of this workplace). Each {{Activity}} has a collection of {{Description}} entities ({{Description}} entities are just the same {{Activity}} description translated into several languages, thus having locale property). Result of the query should look like this: ||User.name||Workplace.name||Activity.code||Description.text|| |John|Main office|R|Research| |Polly|Main office|R|Research| |Craig|Main office|R|Research| Here is the criteria for getting that result: {code} Criteria criteria = session.createCriteria(User.class); criteria.createAlias("workplace.activity.descriptions", "descriptionsAlias", Criteria.INNER_JOIN); criteria.add(Restrictions.eq("descriptionsAlias.locale", "en_US")); criteria.list(); {code} It works just fine. Produces the table shown above and generates SQL like this: {code} select this_.id as id18_3_, this_.name as name18_3_, this_.workplaceId as workplac3_18_3_, workplace3_.id as id111_0_, workplace3_.activityId as activityId111_0_, workplace3_.name as name111_0_, activity4_.id as id114_1_, activity4_.code as code114_1_, descriptio1_.id as id24_2_, descriptio1_.locale as locale24_2_, descriptio1_.text as text24_2_ from user this_ left outer join workplace workplace3_ on this_.workplaceId=workplace3_.id left outer join activity activity4_ on workplace3_.activityId=activity4_.id inner join description descriptio1_ on activity4_.id=descriptio1_.activityId where descriptio1_.locale=? {code} While if you want paging, you should make a rowcount projection first, so your query will look like this: {code} Criteria criteria = this.sessionFactory.getCurrentSession().createCriteria(User.class);}} criteria.createAlias("workplace.activity.descriptions", "descriptionsAlias", criteria.INNER_JOIN); criteria.add(Restrictions.eq("descriptionsAlias.locale", "en_US")); criteria.setProjection(Projections.rowCount()); Integer rowCount = (Integer) criteria.uniqueResult(); {code} And you expect Hibernate to produce this SQL: {code} select count(*) as y0_ from user this_ left outer join workplace workplace3_ on this_.workplaceId=workplace3_.id left outer join activity activity4_ on workplace3_.activityId=activity4_.id inner join description descriptio1_ on activity4_.id=descriptio1_.activityId where descriptio1_.locale=? {code} But the SQL produced is this: {code} select count(*) as y0_ from user this_ where descriptio1_.locale=? {code} I suppose that this is a bug, because you expect one behavior, while you get another. I don't think, that this is a big deal, but when you experience such an issue, it is time consuming to get it fixed. Here is a workaround (or fix) of the issue. You should always assign aliases to all associated "links" of the "entities chain" of the path to an entity you want to restrict if you use projections. In other words, if you have anything in where clause and you are using projections, you should assign aliases to all associations between root entity and the entity, fields of which are used in where clause. This criteria {code} Criteria criteria = this.sessionFactory.getCurrentSession().createCriteria(User.class); criteria.createAlias("workplace", "workplaceAlias"); criteria.createAlias("workplaceAlias.activity", "activityAlias"); criteria.createAlias("activityAlias.descriptions", "descriptionsAlias", Criteria.INNER_JOIN); criteria.add(Restrictions.eq("descriptionsAlias.locale", "en_US")); criteria.setProjection(Projections.rowCount()); Integer rowCount = (Integer) criteria.uniqueResult(); {code} Produces the right result {code} select count(*) as y0_ from user this_ inner join workplace workplacea1_ on this_.workplaceId=workplacea1_.id inner join activity activityal2_ on workplacea1_.activityId=activityal2_.id inner join description descriptio3_ on activityal2_.id=descriptio3_.activityId where descriptio3_.locale=? {code} -- 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 years, 10 months

3
2
0 / 0

[Hibernate-JIRA] Created: (OGM-117) OGM Persistence provider fails build EMF due to missing DataSource

by Michal Linhard (JIRA)

OGM Persistence provider fails build EMF due to missing DataSource ------------------------------------------------------------------ Key: OGM-117 URL: https://hibernate.onjira.com/browse/OGM-117 Project: Hibernate OGM Issue Type: Bug Components: core Affects Versions: 3.0-next Reporter: Michal Linhard Attachments: server.log I'm trying to switch JBoss AS7 quickstart example Kitchensink (https://github.com/jbossas/quickstart/tree/master/kitchensink) to use Hibernate OGM. This is my modified example code: https://github.com/mlinhard/quickstart/commit/b027f7476bbb007e0477122d767... I'm using JBoss AS 7.1.0.Final. And Hibernate OGM 3.0.0-SNAPSHOT built from sources (https://github.com/hibernate/hibernate-ogm), last commit e6381d04b3d1a35b5c12aba40454124c20693ad5 When I set up the needed modules in AS7 (see readme.md) and deploy the example using mvn jboss-as:deploy. I get an exception: see server.log -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 10 months

3
5
0 / 0

[Hibernate-JIRA] Created: (OGM-132) Support MongoDB as datastore (Guillaume Scheibel)

by Emmanuel Bernard (JIRA)

Support MongoDB as datastore (Guillaume Scheibel) ------------------------------------------------- Key: OGM-132 URL: https://hibernate.onjira.com/browse/OGM-132 Project: Hibernate OGM Issue Type: New Feature Reporter: Emmanuel Bernard -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 10 months

3
4
0 / 0

[Hibernate-JIRA] Created: (OGM-112) ConcurrentModificationException while loading associations under load

by Sanne Grinovero (JIRA)

ConcurrentModificationException while loading associations under load --------------------------------------------------------------------- Key: OGM-112 URL: http://opensource.atlassian.com/projects/hibernate/browse/OGM-112 Project: Hibernate OGM Issue Type: Bug Reporter: Sanne Grinovero {quote}class: class java.util.ConcurrentModificationException cause: null java.util.ConcurrentModificationException at java.util.HashMap$HashIterator.nextEntry(HashMap.java:793) at java.util.HashMap$KeyIterator.next(HashMap.java:828) at java.util.AbstractCollection.addAll(AbstractCollection.java:305) at org.hibernate.ogm.datastore.spi.Association.getKeys(Association.java:132) at org.hibernate.ogm.loader.OgmLoader.getResultSet(OgmLoader.java:417) at org.hibernate.ogm.loader.OgmLoader.doQuery(OgmLoader.java:248) at org.hibernate.ogm.loader.OgmLoader.doQueryAndInitializeNonLazyCollections(OgmLoader.java:215) at org.hibernate.ogm.loader.OgmLoader.loadCollection(OgmLoader.java:185) at org.hibernate.ogm.loader.OgmBasicCollectionLoader.initialize(OgmBasicCollectionLoader.java:42) at org.hibernate.persister.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:622) at org.hibernate.event.internal.DefaultInitializeCollectionEventListener.onInitializeCollection(DefaultInitializeCollectionEventListener.java:82) at org.hibernate.internal.SessionImpl.initializeCollection(SessionImpl.java:1606) at org.hibernate.collection.internal.AbstractPersistentCollection.initialize(AbstractPersistentCollection.java:379) at org.hibernate.collection.internal.AbstractPersistentCollection.read(AbstractPersistentCollection.java:112) at org.hibernate.collection.internal.PersistentSet.iterator(PersistentSet.java:180){quote} -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 10 months

2
1
0 / 0

[Hibernate-JIRA] Created: (OGM-178) Provide RowKey metadata in AssociationKey and fix various bugs in RowKey columns for associations

by Emmanuel Bernard (JIRA)

Provide RowKey metadata in AssociationKey and fix various bugs in RowKey columns for associations ------------------------------------------------------------------------------------------------- Key: OGM-178 URL: https://hibernate.onjira.com/browse/OGM-178 Project: Hibernate OGM Issue Type: Improvement Components: core Reporter: Emmanuel Bernard Assignee: Emmanuel Bernard Fix For: 4.0-next -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 10 months

1
1
0 / 0

[Hibernate-JIRA] (HHH-7433) change jandex/fastxml to compile scope in metamodel branch

by Strong Liu (JIRA)

11 years, 10 months

1
2
0 / 0

[Hibernate-JIRA] Created: (HHH-4915) <list-index> base attribute ignored on insert for a bidirectional association (one-to-many)

by Olivier Lafontaine (JIRA)

<list-index> base attribute ignored on insert for a bidirectional association (one-to-many) ------------------------------------------------------------------------------------------- Key: HHH-4915 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4915 Project: Hibernate Core Issue Type: Bug Components: core Affects Versions: 3.5.0-CR-1, 3.3.2 Environment: Hibernate 3.3.2GA and 3.5.0-CR-1 Oracle Database Reporter: Olivier Lafontaine Attachments: hibernate-poc-jira.zip My mapping looks like the following: {code:xml} <hibernate-mapping> <class name="Parent">  <list name="children" table="CHILD" cascade="all-delete-orphan"> <key column="ID_PARENT" not-null="true" /> <list-index base="1"> <column name="IDX" check="IDX > 0" /> </list-index> <one-to-many class="Child" /> </list> </class> <class name="Child">  <many-to-one name="parent" class="Parent" column="ID_PARENT" not-null="true" insert="false" update="false" /> </class> </hibernate-mapping> {code} As you can see from the mapping, we have a parent entity ({{Parent}}) referring child entities ({{Child}} using the {{children}} accessor). The index column ({{ORDER}}) is not an attribute in the child entity, so I referred to the second use case in section _6.3.3. Bidirectional associations with indexed collections_ of the reference guide to do my mapping. Everything works except for the index base, it is always 0 based on insert. I've tried both Hibernate 3.3.2GA and the latest development version (3.5.0-CR-1), the issue can be reproduced in both. I've joined a test case to reproduce the problem. While working on it, I realized there are updates after the inserts setting the correct index. However, we cannot change the database schema and there's a constraint on the index column enforcing a value > 0. So this issue is really important for us. I could manually handle the index values, but it would be so much easier to let Hibernate do it. I've traced the problem and it seems that {{StatefulPersistenceContext#getIndexInParent(..)}} does not considers the index base. Why are updates necessary after the inserts? It looks to me like Hibernate could correctly set the index parameter on the insert statements. -- 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 years, 10 months

2
2
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

hibernate-issues July 2012