May 2010 - hibernate-issues - Jboss List Archives

[Hibernate-JIRA] Created: (HHH-4079) Fail-fast a build using JDK6

by Andrew Lee Rubinger (JIRA)

Fail-fast a build using JDK6 ---------------------------- Key: HHH-4079 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4079 Project: Hibernate Core Issue Type: Improvement Environment: JDK6 Reporter: Andrew Lee Rubinger Attachments: HHH-4079.patch Emmanuel tells me that JDK5 is a requirement for building Hibernate Core. If JDK6 is an invalid choice, this patch will tell developers. -- 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

13 years, 3 months

2
2
0 / 0

[Hibernate-JIRA] Created: (HHH-3367) Add support to OpenEdge RDMS (Progress 10) in DialectFactory

by Glaucio Scheibel (JIRA)

Add support to OpenEdge RDMS (Progress 10) in DialectFactory ------------------------------------------------------------ Key: HHH-3367 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3367 Project: Hibernate3 Issue Type: Patch Components: core Affects Versions: 3.2.6 Reporter: Glaucio Scheibel Attachments: DialectFactory.java, DialectFactory.patch This patch adds OpenEdge (formely Progress Database) support to DialectFactory class. -- 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

13 years, 3 months

2
1
0 / 0

[Hibernate-JIRA] Created: (HHH-2654) Ingres dialect patch to support bit_length

by Chris Bredesen (JIRA)

Ingres dialect patch to support bit_length ------------------------------------------ Key: HHH-2654 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2654 Project: Hibernate3 Issue Type: Patch Components: core Reporter: Chris Bredesen Assignee: Steve Ebersole Priority: Minor Attachments: IngresDialect.diff This patch from Daniel fixes the Ingres dialect to support bit_length. -- 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

13 years, 3 months

3
2
0 / 0

[Hibernate-JIRA] Created: (HV-296) Apply constraints on the elements of an Iterable instance

by Hardy Ferentschik (JIRA)

Apply constraints on the elements of an Iterable instance --------------------------------------------------------- Key: HV-296 URL: http://opensource.atlassian.com/projects/hibernate/browse/HV-296 Project: Hibernate Validator Issue Type: New Feature Components: engine Affects Versions: 4.0.2.GA Reporter: Hardy Ferentschik Assignee: Hardy Ferentschik See BVAL-202 -- 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

13 years, 3 months

1
8
0 / 0

[Hibernate-JIRA] Created: (HHH-4874) Embedded Objects get set to null if all its members are null

by Srinath (JIRA)

Embedded Objects get set to null if all its members are null ------------------------------------------------------------ Key: HHH-4874 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4874 Project: Hibernate Core Issue Type: Bug Components: annotations Reporter: Srinath Embedded Objects get set to null if all its members are null.i am facing this problem when i am having @Embeddable properties are null.even i creating instance in Parent class no-argument constructor.is there any other way to overcome from this issue? Thanks -- 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

13 years, 3 months

4
3
0 / 0

[Hibernate-JIRA] Created: (HHH-3733) Introduce an annotation to disable ad-hoc null semantic of Hibernate components

by Vladimir Kovalyuk (JIRA)

Introduce an annotation to disable ad-hoc null semantic of Hibernate components ------------------------------------------------------------------------------- Key: HHH-3733 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3733 Project: Hibernate Core Issue Type: Improvement Components: core Reporter: Vladimir Kovalyuk see http://forums.hibernate.org/viewtopic.php?t=993972 For the model @Entity public class Person { private Address name = new Address(); ... @Embedded Address getAddress() {} } @Embeddable public class Address { public String getCity() {} public String getStreet() {} } the following xhtml excerpt causes NPE constantly when editing a person which address properties hasn't been filled in yet <h:inputText value="#{person.address.city}" /> I suggest introducing an annotation @Static which could be applied to Address class and lead to disabling null ad-hoc semantic on its instances. For some environments such as user interface this may be considered as the default behavior. I suggest introducing an Hibernate configuration parameter which would switch off the semantic. I would propose to consider embeddable classes as static mixins from OO design, not as just limited entities without identity. This point of view explains that embedded instance is a part of entity so it's lifecycle is the same as the entity's lifecycle. Thus constant presence of embeddable instance (property is never null) is the default behavior. Thus configuration parameter is "must have", not the thing which is "nice to have". >From the other hand null ad-hoc semantic is like dynamic mixins. So it would be nice to have a @Dynamic annotation to force this semantic for some components. -- 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

13 years, 3 months

4
6
0 / 0

[Hibernate-JIRA] Created: (HHH-2308) Adjusting the Outer Join Predicate using Criteria Query

by Ben Grant (JIRA)

Adjusting the Outer Join Predicate using Criteria Query ------------------------------------------------------- Key: HHH-2308 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2308 Project: Hibernate3 Type: New Feature Components: query-criteria Versions: 3.2.1 Environment: Linux Using MS SQLServer Reporter: Ben Grant I have two tables Table A ||Col_1||Col_2|| |London| UK | |Liverpool| UK | | New York | USA | Table B ||Col_1||Col_2|| Col_3|| | UK | Europe | 0 | USA | Americas | 1 Using the Criteria class, Restriction Class and FetchMode, Hibernate manages to create a query that looks like this select distinct top 2000 this_.Col_1 as y0_, TableB3_.Col2 as y1_ from TableA this_ left outer join TableB TableB3_ on this_.Col_2= TableB3_.Col_1 where TableB3_.Col_3=1 When really i need the query to be like this select distinct top 2000 this_.Col_1 as y0_, TableB3_.Col2 as y1_ from TableA this_ left outer join TableB TableB3_ on this_.Col_2= TableB3_.Col_1 AND TableB3_.Col_3=1 currently their isn't any know way for hibernate to adjust or apply filters within the join clause. -- 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

13 years, 3 months

12
27
0 / 0

[Hibernate-JIRA] Created: (HHH-5040) SQLQuery fails with auto-discovery of result set metadata and aliased columns

by Chris Wilson (JIRA)

SQLQuery fails with auto-discovery of result set metadata and aliased columns ----------------------------------------------------------------------------- Key: HHH-5040 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5040 Project: Hibernate Core Issue Type: Bug Components: core Affects Versions: 3.3.2 Environment: 3.3.2 GA, MySQL Connector/J 5.0. Reporter: Chris Wilson Attachments: HibernateSqlQueryAliasTest.java Hibernate assumes that the column name returned by ResultSetMetaData#getColumnName(int) is the name it can use to extract the data from the ResultSet. However, if the SQLQuery uses column aliases, then this will fail here: {code|title=Stack Trace} org.hibernate.exception.SQLGrammarException: could not execute query at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:90) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) at org.hibernate.loader.Loader.doList(Loader.java:2235) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2129) at org.hibernate.loader.Loader.list(Loader.java:2124) at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:312) at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1723) at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:165) at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:175) at org.wfp.rita.test.hibernate.HibernateSqlQueryAliasTest.testFailingWithAliases(HibernateSqlQueryAliasTest.java:45) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.wfp.rita.test.base.HibernateTestBase.runTestMethod(HibernateTestBase.java:204) at org.wfp.rita.test.base.HibernateTestBase.runTest(HibernateTestBase.java:117) at junit.framework.TestCase.runBare(TestCase.java:130) at junit.framework.TestResult$1.protect(TestResult.java:106) at junit.framework.TestResult.runProtected(TestResult.java:124) at junit.framework.TestResult.run(TestResult.java:109) at junit.framework.TestCase.run(TestCase.java:120) at junit.framework.TestSuite.runTest(TestSuite.java:230) at junit.framework.TestSuite.run(TestSuite.java:225) at org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestReference.run(JUnit3TestReference.java:130) at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197) Caused by: java.sql.SQLException: Column 'id' not found. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1075) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:929) at com.mysql.jdbc.ResultSetImpl.findColumn(ResultSetImpl.java:1145) at com.mysql.jdbc.ResultSetImpl.getInt(ResultSetImpl.java:2814) at org.hibernate.type.IntegerType.get(IntegerType.java:51) at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:184) at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:210) at org.hibernate.loader.custom.CustomLoader$ScalarResultColumnProcessor.extract(CustomLoader.java:497) at org.hibernate.loader.custom.CustomLoader$ResultRowProcessor.buildResultRow(CustomLoader.java:443) at org.hibernate.loader.custom.CustomLoader.getResultColumnOrRow(CustomLoader.java:340) at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:629) at org.hibernate.loader.Loader.doQuery(Loader.java:724) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259) at org.hibernate.loader.Loader.doList(Loader.java:2232) ... 26 more {code} Hibernate appears to support auto-discovery of result set columns, notwithstanding bug [HHH-436|http://opensource.atlassian.com/projects/hibernate/browse/HHH-436] which was closed as fixed. No QueryException is thrown if the returns of the query have not been defined. Instead, SQLQueryImpl.verifyParameters() sets SQLQueryImpl.autodiscovertypes, which ends up in QueryParameters.autodiscovertypes, which CustomLoader.doQuery() passes to CustomLoader.getResultSet(), which then calls CustomLoader.autoDiscoverTypes(), which calls ScalarResultColumnProcessor.performDiscovery(). performDiscovery() calls ResultSetMetaData#getColumnName() to retrieve each column name from the result set, which ends up in CustomLoader.ResultRowProcessor, where ScalarResultColumnProcessor.extract() tries to use it to extract data from the result set. Because the name doesn't match the actual alias used in the result set, this fails with the exception given above. [JDBC 4.0 Specification|http://jcp.org/aboutJava/communityprocess/final/jsr221/inde...] does not specify whether ResultSetMetaData.getColumnName() should return the name of the underlying column, or the name of the alias. It seems bizarre to me that it returns a value that cannot be passed to ResultSet.getObject(String). However, both MySQL and H2 take the position that we should call ResultSetMetaData.getColumnLabel() instead to get the name that can be used on the ResultSet: * [MySQL bug 21379|http://bugs.mysql.com/bug.php?id=21379] * [MySQL bug 21596|http://bugs.mysql.com/bug.php?id=21596] * [H2 mailing list discussion|http://www.mail-archive.com/h2-database@googlegroups.com/msg00...] The fix would appear to be modifying ScalarResultColumnProcessor.performDiscovery() (or CustomLoader.Metadata.getColumnName()) so that it calls getColumnLabel() instead of getColumnName(). The workaround is to explicitly specify column aliases with SQLQuery.addScalar(). Test case attached. -- 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

13 years, 3 months

5
4
0 / 0

[Hibernate-JIRA] Created: (HSEARCH-383) Hibernate Search does not respect the @AccessType annotation in respect to @Id fields.

by Steven Knock (JIRA)

Hibernate Search does not respect the @AccessType annotation in respect to @Id fields. -------------------------------------------------------------------------------------- Key: HSEARCH-383 URL: http://opensource.atlassian.com/projects/hibernate/browse/HSEARCH-383 Project: Hibernate Search Issue Type: Bug Components: engine Affects Versions: 3.1.1.GA, 3.1.0.GA Environment: Hibernate 3.3.1.GA Reporter: Steven Knock Priority: Minor Attachments: TestAccessTypeProblem.java This occurs when indexing an Entity annotated as @IndexedEmbedded if the object that it is @ContainedIn is a proxy object that has not yet been loaded and if the @AccessType of the @Id of the proxy object has been overriden from field to property. This is because Hibernate Search does not respect the @AccessType annotation, and so attempts to read the id of the parent object directly from the member variable, which is not initialised in the proxy and so returns 0 in the attached test case. The problem is in: org.hibernate.search.engine.DocumentBuilderIndexedEntity.checkDocumentId(). This results in a record in the Lucene index that has no reference to the containing instance. So, while the number of results is returned correctly, any attempt to actually retrieve the results and convert them into Hibernate objects fails. -- 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

13 years, 3 months

3
2
0 / 0

[Hibernate-JIRA] Created: (HSEARCH-402) Provide a ReaderProvider to cap the number of index reopenings to a fixed rate

by Sanne Grinovero (JIRA)

Provide a ReaderProvider to cap the number of index reopenings to a fixed rate ------------------------------------------------------------------------------ Key: HSEARCH-402 URL: http://opensource.atlassian.com/projects/hibernate/browse/HSEARCH-402 Project: Hibernate Search Issue Type: New Feature Reporter: Sanne Grinovero Assignee: Sanne Grinovero Fix For: 3.2.0 It's often unneeded to recheck for an index update at very high frequency, which ends up to be a bottleneck in high-throughput applications for an unneded guarantee of having latest version of index. Setting a configurable period, let's say 5 seconds, will make this ReaderProvider reopen an IndexReader once each 5 seconds. This can be done in background, removing the delay of checks from the call to openReader(); and enabling index warmup in future (Lucene 2.9 feature) in background. When reopening in background the ratio will be fixed, i.e. the index will be reopened even if there's no request for a new IR. This impl should manage the timer, but otherwise delegate to another implementation of ReaderProvider (defaulting to current default: SharingBufferReaderProvider) to optionally chain and provide the benefits of the other implementation. -- 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

13 years, 3 months

2
6
0 / 0

[Hibernate-JIRA] Created: (HSEARCH-436) Expose a metadata API

by Hardy Ferentschik (JIRA)

Expose a metadata API --------------------- Key: HSEARCH-436 URL: http://opensource.atlassian.com/projects/hibernate/browse/HSEARCH-436 Project: Hibernate Search Issue Type: New Feature Components: engine, mapping Affects Versions: 3.2.0.Beta1 Reporter: Hardy Ferentschik Assignee: Hardy Ferentschik Fix For: 3.3.0 SearchFactory should expose some metadata API which allows to query information about the configuration. This includes things like * list of indexed classes * indexed fields per class/index * ... -- 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

13 years, 3 months

3
2
0 / 0

[Hibernate-JIRA] Created: (HHH-2844) Limit and 'For Update' do not work on Oracle

by Michael Kopp (JIRA)

Limit and 'For Update' do not work on Oracle -------------------------------------------- Key: HHH-2844 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2844 Project: Hibernate3 Issue Type: Bug Components: query-sql Affects Versions: 3.2.2 Reporter: Michael Kopp Limits on oracle lead too: select * from (select x.y as xy_1 from table x) where rownum <= 5 when doing a for update that leads too select * from (select x.y as xy_1 from table x) where rownum <= 5 for update of x.y The problem is that the x.y is invalid and not found within the temporary view and leads to an oracle error. what would be valid is the name of the view column xy_1, meaning select * from (select x.y as xy_1 from table x) where rownum <= 5 for update of xy_1 Actually this should be valid in all cases when doing a alias for update lock. My Solution thus was to override the following in my own Oracle Dialect public String applyLocksToSql(final String sql, final Map aliasedLockModes, final Map keyColumnNames) { final String s = new ForUpdateFragment(this, aliasedLockModes, keyColumnNames) { @Override public ForUpdateFragment addTableAlias(final String alias) { // search for alias in sql final int i = sql.indexOf(alias); // check if the found string is followed by an ' as ' and thus has a column alias if (i != -1 && sql.length() > (i + alias.length() + 4) && sql.substring(i + alias.length(), i + alias.length() + 4).equals( " as ")) { // use the column alias return super.addTableAlias(sql.substring(i + alias.length() + 4, sql.indexOf(',',i + alias.length() + 4))); } return super.addTableAlias(alias); } }.toFragmentString(); return sql + s; -- 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

13 years, 3 months

4
6
0 / 0

[Hibernate-JIRA] Created: (HBX-939) Composite IDs and many-to-many relationships

by Markus Kramer (JIRA)

Composite IDs and many-to-many relationships -------------------------------------------- Key: HBX-939 URL: http://opensource.atlassian.com/projects/hibernate/browse/HBX-939 Project: Hibernate Tools Issue Type: Bug Affects Versions: 3.2beta9 Environment: Hibrnate 3.2.1, Postgresql 8.1.8 Reporter: Markus Kramer Attachments: B.hbm.xml, testdb.sql The detection of many-to-many relationships doesn't work correctly if the primary key of one of the involved tables consists of more than one field. An example: One of two tables (table 'A') of a many-to-many relationship has a primary key consisting of two attributes (id1 and id2). The generated B.hbm.xml for the table 'B' contains this: <set name="as" inverse="true" table="a_b"> <key> <column name="b_id" not-null="true" /> </key> <many-to-many entity-name="test.A"> <column name="a_id1" not-null="true" /> </many-to-many> </set> But there should be another entry for the referenced primary key: <column name="a_id2" not-null="true" /> The SQL code for the used tables and the complete B.hbm.xml are attached. -- 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

13 years, 3 months

2
1
0 / 0

[Hibernate-JIRA] Created: (HSEARCH-444) Search fails to start when core uses XML mappings making use of entity-name attribute

by Sanne Grinovero (JIRA)

Search fails to start when core uses XML mappings making use of entity-name attribute ------------------------------------------------------------------------------------- Key: HSEARCH-444 URL: http://opensource.atlassian.com/projects/hibernate/browse/HSEARCH-444 Project: Hibernate Search Issue Type: Bug Components: mapping Affects Versions: 3.1.0.GA Reporter: Sanne Grinovero Assignee: Emmanuel Bernard Fix For: 3.2.0.Beta2 As described on forums: https://forum.hibernate.org/viewtopic.php?f=9&t=993687 classes mapped using XML on hibernate core, like classes starting with: <class name="com.mydomain.myapp.AnswerImpl" table="answer" entity-name="Answer"> cause: Caused by: java.lang.NullPointerException at org.hibernate.search.cfg.SearchConfigurationFromHibernateCore.getClassMapping(SearchConfigurationFromHibernateCore.java:31) at org.hibernate.search.store.DirectoryProviderFactory.getDirectoryProviderName(DirectoryProviderFactory.java:226) at org.hibernate.search.store.DirectoryProviderFactory.createDirectoryProviders(DirectoryProviderFactory.java:53) at org.hibernate.search.impl.SearchFactoryImpl.initDocumentBuilders(SearchFactoryImpl.java:404) at org.hibernate.search.impl.SearchFactoryImpl.<init>(SearchFactoryImpl.java:119) at org.hibernate.search.event.ContextHolder.getOrBuildSearchFactory(ContextHolder.java:30) at org.hibernate.search.event.FullTextIndexEventListener.initialize(FullTextIndexEventListener.java:59) at org.hibernate.event.EventListeners$1.processListener(EventListeners.java:198) at org.hibernate.event.EventListeners.processListeners(EventListeners.java:181) at org.hibernate.event.EventListeners.initializeListeners(EventListeners.java:194) ... 16 more This was reported on 3.1.0.GA but I guess it affects all releases. There's a "test WAR" in the forums, going to ask for a testcase. -- 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

13 years, 3 months

5
8
0 / 0

[Hibernate-JIRA] Created: (HHH-2058) puhs SessionImplementor.getInterceptor up into Session

by Max Rydahl Andersen (JIRA)

puhs SessionImplementor.getInterceptor up into Session ------------------------------------------------------ Key: HHH-2058 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2058 Project: Hibernate3 Type: Improvement Components: core Reporter: Max Rydahl Andersen Being able to get the actual interceptor used for a certain Session is beneficial. any reason why it is not exposed on Session ? -- 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

13 years, 3 months

2
1
0 / 0

[Hibernate-JIRA] Created: (HHH-3129) Null Role in PersitentCollection during a onCollectionRecreate() in an Interceptor

by Jose CHILLAN (JIRA)

Null Role in PersitentCollection during a onCollectionRecreate() in an Interceptor ---------------------------------------------------------------------------------- Key: HHH-3129 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3129 Project: Hibernate3 Issue Type: Bug Components: core Affects Versions: 3.2.6 Environment: Any Reporter: Jose CHILLAN When the "onCollectionRecreate" is invoked on an Interceptor, the getRole() method returns null. After investigation, the problem is located in the class CollectionEntry in one of its constructors and is easily solved using the patch : public CollectionEntry(CollectionPersister persister, PersistentCollection collection) { // new collections that get found + wrapped // during flush shouldn't be ignored ignore = false; collection.clearDirty(); //a newly wrapped collection is NOT dirty (or we get unnecessary version updates) snapshot = persister.isMutable() ? collection.getSnapshot(persister) : null; // -- ADDED LINE HERE -- role = persister.getRole(); collection.setSnapshot(loadedKey, role, snapshot); } Thanks -- 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

13 years, 3 months

6
8
0 / 0

[Hibernate-JIRA] Created: (HHH-2847) THIS_"."NAME": invalid identifier when using createCriteria with addOrder

by Ashish Tiwari (JIRA)

THIS_"."NAME": invalid identifier when using createCriteria with addOrder ------------------------------------------------------------------------- Key: HHH-2847 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2847 Project: Hibernate3 Issue Type: Bug Components: query-criteria Affects Versions: 3.0.5 Environment: Oracle - 10.2.0 Reporter: Ashish Tiwari We are using hibernate 3.0.5 and once a while I see following error getting generated due to incorrect SQL generated by hibernate: Hibernate: select systembean0_.SYSTEMID as SYSTEMID12_0_, systembean0_.Version as Version12_0_, systembean0_.NAME as NAME12_0_, systembean0_.TYPE as TYPE12_0_, systembean0_.DESCRIPTION as DESCRIPT5_12_0_ from SDSYSTEM systembean0_ order by this_.NAME asc - SQL Error: 904, SQLState: 42000 - ORA-00904: "THIS_"."NAME": invalid identifier This normally works but occasionally we run into the issue mentioned above. I do not see alias "this_" in the sql query and I think that causes the error to happen. Issue is caused by alias not used consistently. In normal case the generated SQL looks like following: Hibernate: select this_.SYSTEMID as SYSTEMID7_0_, this_.Version as Version7_0_, this_.NAME as NAME7_0_, this_.TYPE as TYPE7_0_, this_.DESCRIPTION as DESCRIPT5_7_0_ from SDSYSTEM this_ order by this_.NAME asc I am not sure what causes this problem. Has anyone else see similar problem earlier? I appreciate any help with this. Below is other information: Hibernate version: 3.0.5 Mapping documents: <?xml version="1.0"?> <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"> <hibernate-mapping> <class name="com.avaya.coreservice.admin.toolkit.common.system.SystemBean" table="SDSYSTEM"> <id name="uniqueId" type="java.lang.String"> <column name="SYSTEMID" length="50" not-null="true"/> <generator class="uuid"/> </id> <version name="version" column="Version" /> <property name="name" type="java.lang.String"> <column name="NAME" length="512" not-null="true"/> </property> <property name="type" type="java.lang.String"> <column name="TYPE" length="50" not-null="false"/> </property> <property name="description" type="java.lang.String"> <column name="DESCRIPTION" length="1024" not-null="false"/> </property> <set name="resourceBeanSet"> <key> <column name="SYSTEMID" length="50" not-null="false"/> </key> <one-to-many class="com.avaya.coreservice.admin.toolkit.common.resource.ResourceBean"/> </set> <set name="siteBeanSet" order-by="name asc"> <key> <column name="SYSTEMID" length="50" not-null="false"/> </key> <one-to-many class="com.avaya.coreservice.admin.toolkit.common.site.SiteBean"/> </set> </class> </hibernate-mapping> Code between sessionFactory.openSession() and session.close(): HibernateUtil.getSession().createCriteria(SystemBean.class) .addOrder(Order.asc("name")).list(); Full stack trace of any exception that occurs: N/A Name and version of the database you are using: Oracle - 10.2.0 The generated SQL (show_sql=true): select systembean0_.SYSTEMID as SYSTEMID12_0_, systembean0_.Version as Version12_0_, systembean0_.NAME as NAME12_0_, systembean0_.TYPE as TYPE12_0_, systembean0_.DESCRIPTION as DESCRIPT5_12_0_ from SDSYSTEM systembean0_ order by this_.NAME asc I appreciate any help with this. Thanks, -- 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

13 years, 4 months

7
10
0 / 0

[Hibernate-JIRA] Created: (HHH-3345) "select new" + "join fetch" = "owner of the fetched association was not present in the select list"

by Anthony Ogier (JIRA)

"select new" + "join fetch" = "owner of the fetched association was not present in the select list" --------------------------------------------------------------------------------------------------- Key: HHH-3345 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3345 Project: Hibernate3 Issue Type: Bug Affects Versions: 3.2.4.sp1 Reporter: Anthony Ogier I want to create a List<B>, each B containing an entity with "A" type, and I also want for each A to force fetching of its "C" property. public class B { private A a; public B(A a) { this.a = a; } } @Entity public class A { @ManyToOne @JoinColumn private C c; // +get/setter ... } @Entity public class C { @Column private String d; // +get/setter ... // +@OneToMany } Here is the HQL : select new B(a) from A a left join fetch a.c I have that message : org.hibernate.QueryException: query specified join fetching, but the owner of the fetched association was not present in the select list When invoking only "from A a left join fetch a.c", all is good and I have ma List<A> with its "C" properties fetched. I think there is a little bug here ... or did I forget something ? -- 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

13 years, 4 months

4
3
0 / 0

[Hibernate-JIRA] Created: (HHH-4897) onFlushDirty not called if only modification was to a collection of elements

by Rob West (JIRA)

onFlushDirty not called if only modification was to a collection of elements ---------------------------------------------------------------------------- Key: HHH-4897 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4897 Project: Hibernate Core Issue Type: Bug Components: core Affects Versions: 3.3.2, 3.3.1 Reporter: Rob West Attachments: InterceptorTest.jar We are not seeing onFlushDirty get called if the only modification to a Hibernate-mapped entity is to a collection of elements (e.g. a Set<String> that maps to entries in a related table). It appears that for purposes of calling onFlushDirty, a collection property of an entity can only be considered dirty if that entity is versioned (it may still not be dirty, but it cannot be dirty unless the entity is versioned). For purposes of actually executing SQL, the collection property is properly considered to be dirty based on a call to PersistentCollection.isDirty(), but this prevents an interceptor from acting on the modifications. I've attached a jar file that contains (source) modifications to the InterceptorTest to add an additional test case highlighting this, along with modifications to User.java and User.hbm.xml to add an additional collection of elements property. The assertNotNull on line 66 (the check of last updated) fails for me locally with the latest hibernate source downloaded from hibernate.org, which appears to be 3.3.2. We currently use 3.3.1 in production. My original forum post is at https://forum.hibernate.org/viewtopic.php?f=1&t=1002411, which contains some additional debugging information while I was figuring out what was going on. As a note: I left the priority here the default. This is a pretty serious issue for us though, as one of the key things we do with interceptors is auditing of changes, and this means that sometimes certain properties do not get audited. We haven't been able to identify any straightforward workaround to implement that is not either fairly invasive or leaves us open to introducing other equally or more serious bugs in our code. Suggestions welcome. -- 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

13 years, 4 months

2
1
0 / 0

[Hibernate-JIRA] Created: (EJB-458) Typo

by Gerard Weatherby (JIRA)

Typo ---- Key: EJB-458 URL: http://opensource.atlassian.com/projects/hibernate/browse/EJB-458 Project: Hibernate Entity Manager Issue Type: Bug Components: Documentation Reporter: Gerard Weatherby http://docs.jboss.org/hibernate/stable/core/reference/en/html/tutorial.ht... "declared" incorrectly spelled ("decalred") -- 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

13 years, 4 months

2
2
0 / 0

[Hibernate-JIRA] Created: (ANN-537) Support @Comment or column attribute on @Table and @Column

by Max Rydahl Andersen (JIRA)

Support @Comment or column attribute on @Table and @Column ---------------------------------------------------------- Key: ANN-537 URL: http://opensource.atlassian.com/projects/hibernate/browse/ANN-537 Project: Hibernate Annotations Type: Improvement Components: binder Versions: 3.2.1 Reporter: Max Rydahl Andersen with hbm2ddl and hbm2doc its a shame that Annotation does not support setting a comment on table and columns. -- 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

13 years, 4 months

9
22
0 / 0

[Hibernate-JIRA] Created: (HHH-3848) Hibernate.org documentation is out of date (Should be 3.3.x)

by Adam Brod (JIRA)

Hibernate.org documentation is out of date (Should be 3.3.x) ------------------------------------------------------------ Key: HHH-3848 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3848 Project: Hibernate Core Issue Type: Bug Components: documentation Affects Versions: 3.3.1 Reporter: Adam Brod The Hibernate Core API documentation is out of date. It appears to be from Hibernate 3.2.x. In Hibernate 3.3 most of the cache API was deprecated. Online, there is zero documentation for the new APIs. By downloading the source I can see there is some javadoc. The updated docs should be posted to the website. -- 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

13 years, 4 months

3
4
0 / 0

[Hibernate-JIRA] Created: (ANN-783) DOCS: says, monkey, should say tiger: section 2.2.5.3.2.4. Defaults

by Karl Palsson (JIRA)

DOCS: says, monkey, should say tiger: section 2.2.5.3.2.4. Defaults ------------------------------------------------------------------- Key: ANN-783 URL: http://opensource.atlassian.com/projects/hibernate/browse/ANN-783 Project: Hibernate Annotations Issue Type: Improvement Components: documentation Affects Versions: 3.4.0.GA Environment: http://www.hibernate.org/hib_docs/annotations/reference/en/html_single/ or http://www.hibernate.org/hib_docs/annotations/reference/en/html/entity.ht... Reporter: Karl Palsson Priority: Trivial Text says: Trainer describes a unidirectional relationship with Tiger using the join table Trainer_Tiger, with a foreign key trainer_id to Trainer (table name, _, trainer id) and a foreign key trainedTigers_id to Monkey (property name, _, Tiger primary column). Last reference to Monkey should say Tiger. Monkeys were used in the previous section -- 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

13 years, 4 months

2
1
0 / 0

[Hibernate-JIRA] Created: (HHH-4562) Some kind of typo in chapter 7.3.1

by Sorin Postelnicu (JIRA)

Some kind of typo in chapter 7.3.1 ---------------------------------- Key: HHH-4562 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4562 Project: Hibernate Core Issue Type: Bug Components: documentation Affects Versions: 3.3.2 Reporter: Sorin Postelnicu Priority: Trivial In the example shown in chapter 7.3.1 here: http://docs.jboss.org/hibernate/core/3.3/reference/en/html/associations.html The following line seems incorrect: create table PersonAddress ( personId not null, addressId bigint not null primary key ) Shouldn't it have been as follows? create table PersonAddress ( personId bigint not null, addressId bigint not null ) Even such simple things can be confusing for people who are just learning to develop database applications with hibernate. They usually assume that the manual is "bug-free" and can be followed word-to-word, as a definitive reference documentation. -- 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

13 years, 4 months

4
4
0 / 0

[Hibernate-JIRA] Created: (HHH-2796) Generated version are incremented by Hibernate

by Heba Tawfik (JIRA)

Generated version are incremented by Hibernate ---------------------------------------------- Key: HHH-2796 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2796 Project: Hibernate3 Issue Type: Bug Components: core Affects Versions: 3.2.1 Environment: 3.2.1, Oracle 10g Reporter: Heba Tawfik Creating a new entity which it's version is set to generated="always" & saving it, then in the same session adding an object to any of its on-to-many relationships is throwing a StaleObjectStateException. To regenerate the problem, consider the following code 1- departement.hbm.xml : ---------------------------------------- <hibernate-mapping package="com.myproject.domain"> <class name="Departement" table="Departement"> <id name="id"> <column name="dept_id" /> </id> <version column="version" generated="always" name="version" type="integer" unsaved-value="null" /> <property name="name" column="name" /> <bag name="employees" inverse="true" cascade="all" lazy="true"> <key column="dept_id"></key> <one-to-many class="Employee" /> </bag> </class> </hibernate-mapping> 2- employee.hbm.xml : -------------------------------------- <hibernate-mapping package="com.myproject.domain"> <class name="Employee" table="Employee"> <id name="id"> <column name="employee_id" /> </id> <property name="firstName" column="first_name" /> <property name="lastName" column="last_name" /> <property name="age" column="age" /> <property name="salary" column="salary" /> <many-to-one cascade="none" class="com.myproject.domain.Departement" column="dept_id" embed-xml="true" insert="false" name="department" not-null="false" unique="false" update="false" not-found="ignore"> </many-to-one> </class> </hibernate-mapping> 3- Departement.Java --------------------------- package com.myproject.domain; import java.util.ArrayList; import java.util.List; public class Departement extends BaseDepartement{ int id; String name; List employees; Integer version; public int getId() { return id; } public void setId(int id) { this.id = id; } public String getName() { return name; } public void setName(String name) { this.name = name; } public Integer getVersion() { return version; } public void setVersion(Integer version) { this.version = version; } public List getEmployees() { return employees; } public void setEmployees(List employees) { this.employees = employees; } public void addToEmployeeList(Employee emp) { if(employees==null) { setEmployees(new ArrayList()); } employees.add(emp); } } 4- Employee.Java : --------------------------- package com.myproject.domain; public class Employee { int id; String firstName; String lastName; int age; int salary; BaseDepartement department; public BaseDepartement getDepartment() { return department; } public void setDepartment(BaseDepartement department) { this.department = department; } public int getAge() { return age; } public void setAge(int age) { this.age = age; } public String getFirstName() { return firstName; } public void setFirstName(String firstName) { this.firstName = firstName; } public int getId() { return id; } public void setId(int id) { this.id = id; } public String getLastName() { return lastName; } public void setLastName(String lastName) { this.lastName = lastName; } public int getSalary() { return salary; } public void setSalary(int salary) { this.salary = salary; } } 4- Code To Test : ------------------------ public static void main(String args[]) throws Exception { SessionFactory factory = new Configuration().configure("com/myproject/config/hibernate.cfg.xml").buildSessionFactory(); Session session = factory.openSession(); Transaction transaction = session.beginTransaction(); Departement aDept =new Departement(); aDept.setId(10); aDept.setName("Test"); session.save(aDept); transaction.commit(); transaction = session.beginTransaction(); Employee emp=new Employee(); emp.setId(10); emp.setFirstName("test"); emp.setLastName("test"); emp.setSalary(10); emp.setAge(10); emp.setDepartment(aDept); aDept.addToEmployeeList(emp); session.saveOrUpdate(aDept); transaction.commit(); session.close(); } On the database, the default value for version cloumn is set to "1" and a trigger is defined as follow on the Departement table: create or replace TRIGGER TRIGGER1 BEFORE UPDATE ON DEPARTEMENT FOR EACH ROW BEGIN :new.version:= :old.version + 1; END; Upon executing the above code, the following is the hibernate logging : automatically flushing session /* insert com.eds.myproject.domain.Departement */ insert into Departement (name, dept_id) values (?, ?) binding 'Test' to parameter: 1 binding '10' to parameter: 2 /* get generated state com.eds.myproject.domain.Departement */ select departemen_.version as version1_ from Departement departemen_ where departemen_.dept_id=? binding '10' to parameter: 1 returning '1' as column: version1_ before transaction completion after transaction completion automatically flushing session /* get current state com.eds.myproject.domain.Employee */ select employee_.employee_id, employee_.first_name as first2_0_, employee_.last_name as last3_0_, employee_.age as age0_, employee_.salary as salary0_ from Employee employee_ where employee_.employee_id=? binding '10' to parameter: 1 /* insert com.eds.myproject.domain.Employee */ insert into Employee (first_name, last_name, age, salary, employee_id) values (?, ?, ?, ?, ?) binding 'test' to parameter: 1 binding 'test' to parameter: 2 binding '10' to parameter: 3 binding '10' to parameter: 4 binding '10' to parameter: 5 /* update com.eds.myproject.domain.Departement */ update Departement set name=? where dept_id=? and version=? binding 'Test' to parameter: 1 binding '10' to parameter: 2 binding '2' to parameter: 3 Could not synchronize database state with session org.hibernate.StaleObjectStateException: Row was updated or deleted by another transaction (or unsaved-value mapping was incorrect): [com.eds.myproject.domain.Departement#10] at org.hibernate.persister.entity.AbstractEntityPersister.check(AbstractEntityPersister.java:1714) at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2357) at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2257) at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2557) at org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:92) at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:232) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:140) at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298) at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27) at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000) at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338) at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106) at com.eds.myproject.test.Test.main(Test.java:43) org.hibernate.StaleObjectStateException: Row was updated or deleted by another transaction (or unsaved-value mapping was incorrect): [com.eds.myproject.domain.Departement#10] at org.hibernate.persister.entity.AbstractEntityPersister.check(AbstractEntityPersister.java:1714) at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2357) at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2257) at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2557) at org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:92) at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:232) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:140) at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298) at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27) at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000) at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338) at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106) at com.eds.myproject.test.Test.main(Test.java:43) -- 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

13 years, 4 months

4
4
0 / 0

[Hibernate-JIRA] Created: (HHH-2776) Restrictons.in(..) generates invalid SQL if list of values is empty

by Adrian Smith (JIRA)

Restrictons.in(..) generates invalid SQL if list of values is empty ------------------------------------------------------------------- Key: HHH-2776 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2776 Project: Hibernate3 Issue Type: Bug Components: query-criteria Affects Versions: 3.2.2 Environment: Hibernate 3.2.2.ga, MySQL 4.1.18, Windows XP Reporter: Adrian Smith I have classes called A and B. There is a 1:n relationship from A to B. Class B has the following in its mapping file: <many-to-one name="a" class="A" column="fk_a_id" not-null="true" /> If I write the following code: List<B> foo() { List<A> aList = .... Session session = .... Criteria query = session.createCriteria(B.class); query.add(Restrictions.in("a", aList)); return query.list(); } Then all works fine and the results I want are returned. However, if aList is empty (i.e. aList.size()==0) then the query.list function generates and executes invalid SQL for MySQL. java.sql.SQLException: Syntax error or access violation message from server: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1" I imagine that it is generating SQL like IN () which isn't valid. I realize it's a bit ridiculous to want to find the rows where a field is IN the empty list. Nothing will ever be returned. However, in my opinion it should still be allowed, and return no rows, just as saying "WHERE 1=2" is allowed, just doesn't return any rows. -- 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

13 years, 4 months

6
12
0 / 0

[Hibernate-JIRA] Created: (HCANN-17) SecondaryTable JoinColumn cannot reference a non primary key

by Krashan Brahmanjara (JIRA)

SecondaryTable JoinColumn cannot reference a non primary key ------------------------------------------------------------ Key: HCANN-17 URL: http://opensource.atlassian.com/projects/hibernate/browse/HCANN-17 Project: Hibernate Commons Annotations Issue Type: Bug Affects Versions: 3.1.0.GA Environment: Hibernate libraries added to jboss-6.0.0.20100216-M2(3.5) and jboss-5.1.0.GA(3.3.1) used with postgresql-8.3.7-1 database and jdbc driver postgresql-8.3-603.jdbc4.jar Reporter: Krashan Brahmanjara Hibertate annotations reject correct annotations with an error Full exception org.hibernate.AnnotationException: SecondaryTable JoinColumn cannot reference a non primary key at org.hibernate.cfg.annotations.TableBinder.bindFk(TableBinder.java:243) at org.hibernate.cfg.annotations.EntityBinder.bindJoinToPersistentClass(EntityBinder.java:520) at org.hibernate.cfg.annotations.EntityBinder.createPrimaryColumnsToSecondaryTable(EntityBinder.java:510) at org.hibernate.cfg.annotations.EntityBinder.finalSecondaryTableBinding(EntityBinder.java:441) at org.hibernate.cfg.SecondaryTableSecondPass.doSecondPass(SecondaryTableSecondPass.java:25) Example Three entity, two connected to main 'dokument' by their id columns @Entity @Table(name = "dokument") @SecondaryTables(value = { @SecondaryTable(name = "dokument_status", pkJoinColumns = @PrimaryKeyJoinColumn(name = "id_status", referencedColumnName = "id_status")), @SecondaryTable(name = "typ_dok", pkJoinColumns = @PrimaryKeyJoinColumn(name = "id_type", referencedColumnName = "id_type")) }) public class PosrDokument implements Serializable { @Id @Column(name="id_dokumentu", unique=true, nullable=false) private int id_dokumentu; @Column(name = "status", table = "dokument_status", nullable = false, insertable = false, updatable = false) private String status; @Column(name = "name", table = "typ_dok", nullable = false, insertable = false, updatable = false) private String name; (...) -- 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

13 years, 5 months

6
7
0 / 0

[Hibernate-JIRA] Created: (HHH-2831) Native SQL queries with addJoin or <return-join/> return object arrays instead of single Entities

by Jeremy Grodberg (JIRA)

Native SQL queries with addJoin or <return-join/> return object arrays instead of single Entities ------------------------------------------------------------------------------------------------- Key: HHH-2831 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2831 Project: Hibernate3 Issue Type: Bug Components: query-sql Affects Versions: 3.2.5, 3.2.4 Environment: Hibernate 3.2.4.ga and 3.2.5.ga with hsqldb on Win XP Reporter: Jeremy Grodberg Attachments: NativeSQLQueriesTest.patch Although the documentation is not crystal clear, I read it to say that using addJoin should eagerly fetch an associated object but should NOT return it as a separate value. In section 16.1.3. "Handling associations and collections" of the online documentation it says: "It is possible to eagerly join in the Dog to avoid the possible extra roundtrip for initializing the proxy. This is done via the addJoin() method, which allows you to join in an association or collection." This comes BEFORE the section on returning multiple entities, so I say the documentation at least implies it will only return a single entity at the top level. Also, if the intention is to return multiple entities, addEntity() works fine for that, so what then would be the difference of addJoin()? If I'm wrong about what addJoin() should do, please clarify that in the documentation and also clarify how, if it is possible, one could eagerly fetch the association without changing the return type of the quer y. I have reproduced this problem in the Hibernate JUnit tests in 3.2.4.ga and 3.2.5.ga, specifically NativeSQLQueriesTest.testSQLQueryInterface(). I'm attaching a patch to the Hibernate junit test org.hibernate.test.sql.hand.query.NativeSQLQueriesTest.java released in 3.2.5.ga that adds a test to ensure that a query with addJoin only returns a (list of) entities, not a list of Object arrays containing entities. Currently, the assertion fails because instead of returning a list of Organizations we get a list of Object[3] = { Organization, Employment, Person }, which is exactly what we get when the addJoin()s are replaced with appropriate addEntity() calls. -- 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

13 years, 5 months

14
15
0 / 0

[Hibernate-JIRA] Created: (BVAL-198) Simplify creation of ConstraintViolationExceptions

by Gunnar Morling (JIRA)

Simplify creation of ConstraintViolationExceptions -------------------------------------------------- Key: BVAL-198 URL: http://opensource.atlassian.com/projects/hibernate/browse/BVAL-198 Project: Bean Validation Issue Type: Improvement Components: spec-general Affects Versions: 1.1 Reporter: Gunnar Morling javax.validation.ConstraintViolationException wraps a set of constraint violations, currently in the following form: Set<ConstraintViolation<?>> constraintViolations As the exception's constructors have a parameter of the same type, instantiating it is not as easy as expected: Validator validator = ...; DomainObject domainObject = new DomainObject(); Set<ConstraintViolation<DomainObject>> constraintViolations = validator.validate(domainObject); //compiler error: ("The constructor ConstraintViolationException(Set<ConstraintViolation<DomainObject>>) is undefined") throw new ConstraintViolationException(constraintViolations); //this works throw new ConstraintViolationException(new HashSet<ConstraintViolation<?>>(constraintViolations)); This problem can be solved by changing the collection type to Set<? extends ConstraintViolation<?>> The exception then would read as follows: public class ConstraintViolationException extends ValidationException { private final Set<? extends ConstraintViolation<?>> constraintViolations; public ConstraintViolationException(String message, Set<? extends ConstraintViolation<?>> constraintViolations) { super( message ); this.constraintViolations = constraintViolations; } public ConstraintViolationException(Set<? extends ConstraintViolation<?>> constraintViolations) { super(); this.constraintViolations = constraintViolations; } public Set<ConstraintViolation<?>> getConstraintViolations() { return new HashSet<ConstraintViolation<?>>(constraintViolations); } } This makes the exception easier to use for producers, while maintaining simplicity for clients (since getConstraintViolations() still returns a Set<ConstraintViolation<?>>, clients don't have to do deal with the bound wildcard expression). -- 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

13 years, 5 months

3
10
0 / 0

[Hibernate-JIRA] Created: (HHH-3606) Can't use distinct in Oracle with BLOB/CLOB column

by Julien HENRY (JIRA)

Can't use distinct in Oracle with BLOB/CLOB column -------------------------------------------------- Key: HHH-3606 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3606 Project: Hibernate Core Issue Type: Bug Components: core Affects Versions: 3.2.6 Environment: Oracle 9i Reporter: Julien HENRY Problem: Oracle doesn't support distinct when a row is BLOB/CLOB. The resulting error is: ORA-00932: inconsistent datatypes: expected - got CLOB I got this error when trying to filter root entity (see FAQ: http://www.hibernate.org/117.html#A12). It is not really an Hibernate bug, much likely an Oracle limitation. But perhaps an entry may be added in the FAQ, or perhaps some workaround may be found to not use SQL distinct keyword when a BLOB/CLOB is involved in the query. Some related links: http://drupal.org/node/48435 (FR) http://www.developpez.net/forums/d553106/java/general-java/persistance/hi... http://www.dbasupport.com/forums/showthread.php?t=46785 (possible rewriting of the query) -- 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

13 years, 5 months

2
2
0 / 0

[Hibernate-JIRA] Created: (HHH-2969) DB2Dialect Clob SchemaExport uses default length even if no length set

by Philippe Mouawad (JIRA)

DB2Dialect Clob SchemaExport uses default length even if no length set ---------------------------------------------------------------------- Key: HHH-2969 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2969 Project: Hibernate3 Issue Type: Bug Components: core Affects Versions: 3.2.5 Environment: Hibernate 3.2.5, DB2 8, DB2 9 Reporter: Philippe Mouawad Attachments: db2-clob-schemaExport-patch.txt I have this property in my mapping: <property name="argumentsValues" column="cte_arguments_values" type="text" not-null="true" /> Notice no length is set. Hibernate schema Export generates: cte_arguments_names clob(255) not null, Same problem occurs for Clob and Blob. This is due to the following lines in org.hibernate.dialect.DB2Dialect: registerColumnType( Types.BLOB, "blob($l)" ); registerColumnType( Types.CLOB, "clob($l)" ); Attached is the patch. There would be another solution to test that Column has no length set. Philippe. www.ubik-ingenierie.com -- 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

13 years, 5 months

3
6
0 / 0

[Hibernate-JIRA] Created: (HHH-3298) Hibernate does not correcly apply LockMode.UPGRADE when performing a polymorphic select to a leaf-class via a mapped superclass on Oracle

by Mike Everett (JIRA)

Hibernate does not correcly apply LockMode.UPGRADE when performing a polymorphic select to a leaf-class via a mapped superclass on Oracle ----------------------------------------------------------------------------------------------------------------------------------------- Key: HHH-3298 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3298 Project: Hibernate3 Issue Type: Bug Components: core Affects Versions: 3.2.6 Environment: Hibernate 3.2.6, Oracle 10gR2 Reporter: Mike Everett Attachments: src.zip Greetings All, I'm experiencing an issue with Hibernate generated SQL when I attempt to retrieve a union-subclass entity via a concrete mapped superclass with LockMode.UPGRADE. Hibernate will generate SQL with a UNION ALL of the sub-classes and then apply FOR UPDATE to the query which is not allowed with Oracle. This leads to the following error: java.sql.SQLException: ORA-02014: cannot select FOR UPDATE from view with DISTINCT, GROUP BY, etc. It seems that "etc." part includes UNION and UNION ALL. Example with three classes: Entity (abstract) <--extends--- ConcreteInheritorOne (concrete) <--extends-- ConcreteInheritorTwo (concrete) assume: inheritorTwoId == the id of an item of class ConcreteInheritorTwo session == a Hibernate Session // These lookups will cause the error Entity e = (Entity) session.get(Entity.class, inheritorTwoId, LockMode.UPGRADE); Entity e = (Entity) session.get(ConcreteInheritorOne.class, inheritorTwoId, LockMode.UPGRADE); // This will not cause the error Entity e = (Entity) session.get(ConcreteInheritorTwo.class, inheritorTwoId, LockMode.UPGRADE); I have attached entity classes and a Test class which illustrate this effect. I spelunked into the code a bit, but an easy fix did not present itself to my hibernate-code-virgin eyes. Thanks for making Hibernate great! --Mje #### Workaround #### If anyone else is experiencing this problem, I've implemented code similar to the method below as a work-around in an abstraction layer: public Object getEntityForUpdate(Class entityClass, String entityId) { Session s = getSession(); ClassMetadata meta = s.getSessionFactory().getClassMetadata(entityClass); Boolean doTwoPhaseLock = false; if(meta instanceof UnionSubclassEntityPersister) { if(((UnionSubclassEntityPersister)meta).getEntityMetamodel().getSubclassEntityNames().size() > 1) doTwoPhaseLock = true; } if(doTwoPhaseLock) { Entity e = (Entity)s.get(entityClass, entityId); System.out.println("Using Two-Phase Lock on: EntityId[" + entityId + "] EntityClass[" + entityClass.getName() + "]"); s.lock(e, LockMode.UPGRADE); return e; } else { System.out.println("Using One-Phase Lock on: EntityId[" + entityId + "] EntityClass[" + entityClass.getName() + "]"); return s.get(entityClass, entityId, LockMode.UPGRADE); } } #### Hibernate Generated SQL Example #### select entity0_.id as id6_0_, entity0_.versionNumber as versionN2_6_0_, entity0_.clazz_ as clazz_0_ from ( select versionNumber, id, 2 as clazz_ from BASE_ConcreteInheritorTwo union all select versionNumber, id, 1 as clazz_ from BASE_ConcreteInheritorOne ) entity0_ where entity0_.id=? for update #### Stack Trace #### 15:18:14,484 ERROR JDBCExceptionReporter:78 - ORA-02014: cannot select FOR UPDATE from view with DISTINCT, GROUP BY, etc. 15:18:14,484 INFO DefaultLoadEventListener:111 - Error performing load command org.hibernate.exception.SQLGrammarException: could not load an entity: [org.example.domain.hibernate.Entity#1211505494256] at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.loader.Loader.loadEntity(Loader.java:1874) at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:48) at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:42) at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3049) at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:399) at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:375) at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:139) at org.hibernate.event.def.DefaultLoadEventListener.lockAndLoad(DefaultLoadEventListener.java:297) at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:106) at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:878) at org.hibernate.impl.SessionImpl.get(SessionImpl.java:869) at org.hibernate.impl.SessionImpl.get(SessionImpl.java:864) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.hibernate.context.ThreadLocalSessionContext$TransactionProtectionWrapper.invoke(ThreadLocalSessionContext.java:301) at $Proxy0.get(Unknown Source) at org.example.test.Test.doTest2(Test.java:68) at org.example.test.Test.main(Test.java:35) Caused by: java.sql.SQLException: ORA-02014: cannot select FOR UPDATE from view with DISTINCT, GROUP BY, etc. at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:810) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1039) at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:850) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1134) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3384) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186) at org.hibernate.loader.Loader.getResultSet(Loader.java:1787) at org.hibernate.loader.Loader.doQuery(Loader.java:674) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236) at org.hibernate.loader.Loader.loadEntity(Loader.java:1860) ... 19 more -- 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

13 years, 5 months

3
2
0 / 0

[Hibernate-JIRA] Created: (HHH-3011) merge() optimization for Oracle dialect

by MG (JIRA)

merge() optimization for Oracle dialect --------------------------------------- Key: HHH-3011 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3011 Project: Hibernate3 Issue Type: Improvement Components: core Reporter: MG Priority: Minor merge() optimization for Oracle dialect. Since 9i Oracle has a MERGE statement which is very useful to save round trips to database in merge() call which will make dramatic improvement for performance of loading large row sets. MERGE command processes the conditional INSERT-or-UPDATE within a single statement. So instead of doing 'select' first to detect whether entity is in database or not (This is one round trip to DB) and then issuing 'update' or 'insert' all of it could be done in one statement with no extra round trips using oracle SQL MERGE statement. http://www.oracle.com/technology/products/oracle9i/daily/Aug24.html -- 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

13 years, 5 months

4
6
0 / 0

[Hibernate-JIRA] Created: (HHH-3317) Entities saved within onPreUpdate() never inserted into db when id generator is sequenze (f.e. oracle)

by Martin Backhaus (JIRA)

Entities saved within onPreUpdate() never inserted into db when id generator is sequenze (f.e. oracle) ------------------------------------------------------------------------------------------------------ Key: HHH-3317 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3317 Project: Hibernate3 Issue Type: Bug Components: core Affects Versions: 3.2.6 Environment: hibernate3.2.6.ga.jar, Oracle 10 Reporter: Martin Backhaus Priority: Minor If you save (insert) a entity within the event preUpdate and the id is a oracle-sequenze, hibernate put the entity to insert in the session-ActionQueue, BUT NEVER INSERTS it. If you use mysql/hsql... where the id is differently generated, the insert happens immediately and no put to the ActionQueue occures. As workaround you can queue the object (to insert) yourself and call save() within the postUpdate-Event. I use this events for historizing some stuff. Inserts within onDelete() works fine. the ids are annotated as shown here: @Id @GeneratedValue(strategy = GenerationType.AUTO) protected Long id = null; -- 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

13 years, 5 months

4
10
0 / 0

[Hibernate-JIRA] Created: (HHH-2657) Bulk select using primary key or natural id

by charbel (JIRA)

Bulk select using primary key or natural id ------------------------------------------- Key: HHH-2657 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2657 Project: Hibernate3 Issue Type: Improvement Reporter: charbel I think that the following methods are really useful once we use hibernate with huge datas in the database: Object[] get(Class,Object[] id): ---------------------------------------- return objects giving their primary key. First check in cache if it exists, if not either use a select in () either create a temporary table if too many ids. Object[] getUsingNaturalId(Class,Object[] id): ---------------------------------------- return objects giving their natural id. the same thing than before. Be careful on the fact that the primary key and the naturalid can be composite objects. -- 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

13 years, 5 months

2
1
0 / 0

[Hibernate-JIRA] Created: (HHH-2331) bulk deletes on ID must not use HT_ tables

by Amir Pashazadeh (JIRA)

bulk deletes on ID must not use HT_ tables ------------------------------------------ Key: HHH-2331 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2331 Project: Hibernate3 Type: Improvement Components: core Reporter: Amir Pashazadeh when using bulk deletes hibernate inserts ids of rows which must be deleted in a temporary table (with HT_ prefix); I believe that's just for knowing primary keys of objects which must be deleted and updating caches. so if that is the reason there is no need to do so when deleting on primary key property, (for example "delete from MyEntity where id = ?") -- 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

13 years, 5 months

3
2
0 / 0

[Hibernate-JIRA] Created: (ANN-654) Generated SQL includes a column named "null" when referencing a map entry by key and using @LazyCollection(LazyCollectionOption.EXTRA)

by Paul Roe (JIRA)

Generated SQL includes a column named "null" when referencing a map entry by key and using @LazyCollection(LazyCollectionOption.EXTRA) -------------------------------------------------------------------------------------------------------------------------------------- Key: ANN-654 URL: http://opensource.atlassian.com/projects/hibernate/browse/ANN-654 Project: Hibernate Annotations Issue Type: Bug Components: binder Affects Versions: 3.2.0.ga Environment: Oracle 10g, hibernate 3.2 Reporter: Paul Roe We have an Product entity with a map of RegionProduct by Region. @MapKey(name="region") @OneToMany(mappedBy="product", targetEntity= RegionProductImpl.class, fetch = FetchType.LAZY) @LazyCollection(LazyCollectionOption.EXTRA) private Map<Region, RegionProduct> regionProducts = new HashMap<Region, RegionProduct>(); When accessing an element of the map by key, the SQL that is generated includes a "null" column in the WHERE condition. where regionprod0_.PROD_ID=? and regionprod0_.null=? resulting in the stack trace org.hibernate.exception.SQLGrammarException: could not collection element by index at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.loader.Loader.loadEntity(Loader.java:1841) at org.hibernate.loader.entity.CollectionElementLoader.loadElement(CollectionElementLoader.java:72) at org.hibernate.persister.collection.OneToManyPersister.getElementByIndex(OneToManyPersister.java:360) at org.hibernate.collection.AbstractPersistentCollection.readElementByIndex(AbstractPersistentCollection.java:158) at org.hibernate.collection.PersistentMap.get(PersistentMap.java:146) Iterating over the collection works successfully, but populates the entire collection, which is what Extra-Lazy is meant to avoid. -- 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

13 years, 5 months

6
6
0 / 0

[Hibernate-JIRA] Created: (HHH-3949) Intrumentated to one relations can not be join fetched

by Gérald Quintana (JIRA)

Intrumentated to one relations can not be join fetched ------------------------------------------------------ Key: HHH-3949 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3949 Project: Hibernate Core Issue Type: Bug Components: core, query-criteria, query-hql Affects Versions: 3.3.1 Reporter: Gérald Quintana 1) Relation Person -> Vehicle is annotated @OneToOne(optional=true, mappedBy="driver", fetch=FetchType.LAZY) @LazyToOne(LazyToOneOption.NO_PROXY) private Vehicle vehicle; 2) Both entities are instrumented with Javassist 3) Query (HQL or Criteria) Person and Vehicle: from Person p left join fetch p.vehicle => SQL query is correct but Vehicles are not loaded -- 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

13 years, 5 months

4
4
0 / 0

[Hibernate-JIRA] Created: (HHH-4953) Inconsistent behavior when fetching cached subclass entities from 2L

by Guenther Demetz (JIRA)

Inconsistent behavior when fetching cached subclass entities from 2L -------------------------------------------------------------------- Key: HHH-4953 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4953 Project: Hibernate Core Issue Type: Bug Components: caching (L2) Affects Versions: 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, 3.3.1, 3.2.5 Environment: Hibernate3.5.0CR2,HSQLDB, EHCache as 2L-cache Impl Reporter: Guenther Demetz Attachments: Test2LCache.jar Enabling the hibernate second-level cache is leading to inconsistent behavior when fetching cached subclass entities as opposed to fetching non-cached subclass entities. For more informations, please see https://forum.hibernate.org/viewtopic.php?f=1&t=1002880&p=2425931#p2425931 Testcase attached. Cause: IMHO the bug consists in the fact, that persister.getRootEntityName() instead to persister.getEntityName() is passed as 3thrd parameter to the constructor of CacheKey in most places where CacheKey is used, for example in DefaultLoadEventListener.java: new CacheKey( event.getEntityId(), persister.getIdentifierType(), persister.getRootEntityName(), source.getEntityMode(), source.getFactory() In this way the real entity name get swallowed and the type-saveness is not guaranteed anymore. Workaround: Subclass2 tofind = null; try { tofind = (Subclass2) em.find(Subclass2.class,"identifier1"); } catch (ClassCastException cc) { // swallow , this is a workaround } -- 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

13 years, 5 months

3
4
0 / 0

[Hibernate-JIRA] Created: (HHH-3854) Issue with greedy loading of associations (default-lazy=false )

by Amar Singh (JIRA)

Issue with greedy loading of associations (default-lazy=false ) --------------------------------------------------------------- Key: HHH-3854 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3854 Project: Hibernate Core Issue Type: Bug Components: envers Environment: Hibernate - core 3.4.0-SNAPSHOT, Hibernate-envers (from trunk) Reporter: Amar Singh Attachments: greedy-loading.zip I have an Entity GP which has a many to one association to entity CA. <?xml version="1.0"?> <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"> <hibernate-mapping package="org.hibernate.envers.test.integration.onetoone.bidirectional" default-lazy="false"> <class name="BidirectionalRefIngPK" table="BIDIRECTIONAL_REFERENCING_ENTITY"> <id name="id" type="long" column="BIDIRECTIONAL_REFERENCING_ID" > <generator class="native"/> </id> <property name="data"/> <many-to-one name="reference" cascade="save-update" class="BidirectionalRefEdPK" column="BIDIRECTIONAL_REFERENCED_ID"/> </class> <class name="BidirectionalRefEdPK" table="BIDIRECTIONAL_REFERENCED_ENTITY"> <id name="longId" type="long" column="BIDIRECTIONAL_REFERENCED_ID"> <generator class="native"/> </id> <property name="data"/> </class> </hibernate-mapping> With this when I load a previous version of BidirectionalRefIngPK, the loading mechanism tries to create a proxy for BidirectionalRefEdPK, but in my case lazy is false so an internal call to createProxy will return NULL hence . This happens in ToOneIdMapper.java in method mapToEntityFromMap around line 82, which then internally calls for AbstractEntityTuplizer.java line 395 for getProxyFactory() ending in NULL pointer exception because proxy factory is null as mine is a greedy loading. TO REPRODUCE ~~~~~~~~~~~~~ Please find a zipped folder attached. The zipped file has 4 files: - GreedyLoading.java (actual testng test case) - BidirectionalRefEdPK.java (Entity 1) - BidirectionalRefIngPK.java (Entity 2) - greedyloading.hbm.xml Please place the three java files in its package (org.hibernate.envers.test.integration.onetoone.bidirectional), couldn't find the right package so created test case accordingly. Put the greedyloading.hbm.xml in src/test/resources. Now when testng runs GreedyLoading.java you should see NPE. -- 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

13 years, 5 months

7
11
0 / 0

[Hibernate-JIRA] Created: (HHH-5126) JPA Query with InExpression and Collection_valued_input_parameter Complains About Bad Syntax

by Guido Müller (JIRA)

JPA Query with InExpression and Collection_valued_input_parameter Complains About Bad Syntax -------------------------------------------------------------------------------------------- Key: HHH-5126 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5126 Project: Hibernate Core Issue Type: Bug Affects Versions: 3.5.1 Reporter: Guido Müller Priority: Blocker JPA 2.0 spec final chapter 4.6.9 In Expressions In the spec there are 3 alternatives allowed for the query argument. For the 3rd alternative there are no parenthesis allowed. Hibernate seems to expect these illegal parenthesis. The error occurs within a named query in an entity class. -- 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

13 years, 5 months

6
16
0 / 0

[Hibernate-JIRA] Created: (HHH-3280) Remove OracleDialect and Oracle9Dialect

by Diego Plentz (JIRA)

Remove OracleDialect and Oracle9Dialect --------------------------------------- Key: HHH-3280 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3280 Project: Hibernate3 Issue Type: Deprecation Components: metamodel Reporter: Diego Plentz Fix For: 4.x Since they already really old ones. -- 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

13 years, 5 months

3
4
0 / 0

[Hibernate-JIRA] Created: (HHH-2891) Query cache fails on many-to-many select

by Oleg Efimov (JIRA)

Query cache fails on many-to-many select ---------------------------------------- Key: HHH-2891 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2891 Project: Hibernate3 Issue Type: Bug Components: query-hql Affects Versions: 3.2.5 Reporter: Oleg Efimov I have two entities, User and Group, with many-to-many relation: -------------------------------------------------------------------------------------------------- User.hbm.xml <?xml version="1.0"?> <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"> <hibernate-mapping package="test.hibernate"> <class name="User" table="`USER`"> <id name="id" type="long" unsaved-value="null"> <column name="USER_ID" not-null="true"/> <generator class="native"/> </id> <property name="login"> <column name="LOGIN" not-null="true" length="255"/> </property> <bag name="groups" table="USER_GROUP" lazy="false" cascade="none"> <key column="USER_ID"/> <many-to-many class="Group" column="GROUP_ID"/> </bag> </class> </hibernate-mapping> -------------------------------------------------------------------------------------------------- Group.hbm.xml <?xml version="1.0"?> <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"> <hibernate-mapping package="test.hibernate"> <class name="Group" table="`GROUP`"> <id name="id" type="long" unsaved-value="null"> <column name="GROUP_ID" not-null="true"/> <generator class="native"/> </id> <property name="name"> <column name="GROUPNAME" not-null="true" length="100"/> </property> <bag name="users" table="USER_GROUP" lazy="true" inverse="true" cascade="all-delete-orphan"> <key column="GROUP_ID"/> <many-to-many class="User" column="USER_ID"/> </bag> </class> <query name="Group.select.by.login" cacheable="true"><![CDATA[ select user.groups from User user where user.login=? ]]> </query> </hibernate-mapping> ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- test.hibernate.User and test.hibernate.Group classes are just simple beans. In Group.hbm.xml there is a query called "Group.select.by.login", it's intended to be cached. So I add corresponding properties to Hibernate configuraition: -------------------------------------------------------------------------------------------------- properties.put("hibernate.cache.provider_class", "org.hibernate.cache.EhCacheProvider"); properties.put("hibernate.cache.use_query_cache", "true"); ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Configuration has no extra parameters. Then I'm trying to execute the query two times: -------------------------------------------------------------------------------------------------- test fragment SessionFactory sessionFactory = configuration.buildSessionFactory(); Session session = null; try { session = sessionFactory.openSession(); Query query = session.getNamedQuery("Group.select.by.login"); List<Group> groups; groups = query.setParameter(0, "admin").list(); // +++++++++++++++This list() returns list of two Group objects, ok +++++++++++++++ System.out.println("-----------------------------------------------------------------------------------"); for (Group group : groups) { System.out.println(group.getName()); } System.out.println("-----------------------------------------------------------------------------------"); groups = query.setParameter(0, "admin").list(); // +++++++++++++++This list() returns list of two nulls +++++++++++++++ System.out.println("-----------------------------------------------------------------------------------"); for (Group group : groups) { System.out.println(group.getName()); } System.out.println("-----------------------------------------------------------------------------------"); } finally { if (session != null) { session.close(); } sessionFactory.close(); } ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- The first query returns list of, in my case, two groups. The second query returns list of two nulls instead of the same list. I've investigated the problem, and found the following: Query return value is "user.groups", and during query analysis (org.hibernate.hql.ast.QueryTranslatorImpl:160) query return type is defined as "org.hibernate.type.BagType(test.hibernate.User.groups)". This seems to be the problem, as during query put operation org.hibernate.CollectionType.disassemble is called (org.hibernate.cache.StandardQueryCache:80), which simply returns null as owner is null. If this query is not a misuse, then I think, something is to be done at the time of analysis, so that return type be somewhat different. Thanks. -- 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

13 years, 5 months

4
5
0 / 0

[Hibernate-JIRA] Created: (HHH-2049) LEFT OUTER JOIN subcriteria filters children

by Mattias Jiderhamn (JIRA)

LEFT OUTER JOIN subcriteria filters children -------------------------------------------- Key: HHH-2049 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2049 Project: Hibernate3 Type: Bug Components: query-criteria Versions: 3.1.3, 3.2.0.cr4 Environment: Hibernate 3.1.3/3.2.0rc4, hsqldb 1.8 Reporter: Mattias Jiderhamn Attachments: SubCriteriaTestCase.zip When using the Criteria API with LEFT OUTER JOIN to add criterias to the children, i.e. criteria.createCriteria("children", JoinFragment.LEFT_OUTER_JOIN) the child collections will only contain those children matching the criteria. (Even when *not* using any Filters). The attached testcase (also found here: http://forum.hibernate.org/viewtopic.php?p=2320786) will explain it in more detail. -- 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

13 years, 5 months

13
52
0 / 0

[Hibernate-JIRA] Created: (HHH-4732) Update Teradata Dialect for Teradata 13.0

by David Repshas (JIRA)

Update Teradata Dialect for Teradata 13.0 ----------------------------------------- Key: HHH-4732 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4732 Project: Hibernate Core Issue Type: Improvement Components: core Affects Versions: 3.3.2 Environment: Hibernate 3.3.2/ Teradata JDBC Driver 13.0, Teradata Database 13.0 Reporter: David Repshas Attachments: teradata.zip Would like to update Teradata Dialect to work with Teradata Database 13.0. I've include the following files with changes as noted: org.hibernate.dialect.dialect.java - added include of java.sql.statement - added code to support the removal of temporary files created when using referential integrity The three new methods are: public boolean supportsDropPreProcess() public String performDropPreProcess(Statement stmt, String dropSql) throws SQLException public void performDropPostProcess(Statement stmt, String dropSql) throws SQLException ================================== org.hibernate.dialect.TeradataDialect.java - added new include files - modified registerFunction calls for "current_time" and "current_date" - put registerKeyword list in alphabetical order and added keywords: column,map,password,summary, type, value and year - changed "getAddColumnString()" to return "Add" - added new methods: public ViolatedConstraintNameExtracter getViolatedConstraintNameExtracter() public String extractConstraintName(SQLException sqlex) public boolean supportsNotNullUnique() public boolean supportsExpectedLobUsagePattern() public boolean supportsUnboundedLobLocatorMaterialization() public boolean supportsDropPreProcess() public String performDropPreProcess(Statement stmt, String dropSql) throws SQLException public void performDropPostProcess(Statement stmt, String dropSql) throws SQLException ================================== org.hibernate.tool.hbm2ddl.SchemaExport - added hooks for new methods: supportsDropPreProcess,performDropPreProcess and performDropPostProcess ================================== Also made some changes to some of the files in testsuite: ============================================= test/hql/astParserLoadingTest.java - Add instance check of TeradataDialect to get correct behavior ============================================= test/legacy/foobartest.java - Add instance check of TeradataDialect to get correct behavior - modified SQL: Teradata requires "<>" rather than "!=" ============================================= test/typeParameters\typeparametertest.java -needed to disable these tests as Teradata locking was causing a deadlock situation when they run ============================================= -- 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

13 years, 5 months

4
25
0 / 0

[Hibernate-JIRA] Created: (HHH-3795) Unexpected behaviour of saveOrUpdate() for associations with delete-orphan

by Fabian Dankof (JIRA)

Unexpected behaviour of saveOrUpdate() for associations with delete-orphan -------------------------------------------------------------------------- Key: HHH-3795 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3795 Project: Hibernate Core Issue Type: Improvement Environment: Hibernate 3.2.6.GA, PostgreSQL 8.3 Reporter: Fabian Dankof Hello there, I think saveOrUpdate() behaves somewhat unexpected for associations with delete-orphan cascading style: Prerequisite: Association is set to cascade="all,delete-orphan" and nullable=true 1) Within a single session (i.e. a transient object): * Load parent * Delete child * saveOrUpdate() Result: Child is deleted from DB, a DELETE statement was issued 2) Across multiple session (i.e. a detached object): * Have parent with valid ID, but empty list/set of children * saveOrUpdate() Result: Child is not deleted from DB, an UPDATE statement is issued which sets FK of child to 'null' 3) like 2) but nullable is FALSE Result: Nothing happens. With merge() everything works as expected for detached and transient instances. I would either expect saveOrUpdate() to completely disregard DELETE statements OR behave similar to merge(). At least the different results of case 1) and 2) are pretty confusing. Best regards, Fabian -- 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

13 years, 6 months

4
4
0 / 0

[Hibernate-JIRA] Created: (HHH-3562) Support @OrderBy and @Sort annotations

by Adam Warski (JIRA)

Support @OrderBy and @Sort annotations -------------------------------------- Key: HHH-3562 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3562 Project: Hibernate Core Issue Type: New Feature Components: envers Reporter: Adam Warski -- 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

13 years, 6 months

3
2
0 / 0

[Hibernate-JIRA] Created: (HHH-3628) Hilo optimizer problem in case of multiple threads accessing the sequence table

by Montagnon Cyril (JIRA)

Hilo optimizer problem in case of multiple threads accessing the sequence table ------------------------------------------------------------------------------- Key: HHH-3628 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3628 Project: Hibernate Core Issue Type: Bug Affects Versions: 3.2.6 Environment: Sybase Reporter: Montagnon Cyril If 2 (or more) threads access the table storing the ids, this optimizer won't work and will try to insert entities with twice the same idea. The problem is the way the HiLoOptimizer class generates the id : public synchronized Serializable generate(AccessCallback callback) { if ( lastSourceValue < 0 ) { lastSourceValue = callback.getNextValue(); while ( lastSourceValue <= 0 ) { lastSourceValue = callback.getNextValue(); } hiValue = ( lastSourceValue * incrementSize ) + 1; value = hiValue - incrementSize; } else if ( value >= hiValue ) { lastSourceValue = callback.getNextValue(); hiValue = ( lastSourceValue * incrementSize ) + 1; } return make( value++ ); } In the 'else if' part, the 'value' variable isn't reaffected, which means the current thread will try to insert entities with an id that has already been used by another thread. The value should be reset with hiValue - incrementSize. -- 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

13 years, 6 months

5
8
0 / 0

[Hibernate-JIRA] Created: (HHH-5267) NPE on Cascade after switch to hibernate 3.5

by Krzysztof Kowalczyk (JIRA)

NPE on Cascade after switch to hibernate 3.5 -------------------------------------------- Key: HHH-5267 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5267 Project: Hibernate Core Issue Type: Bug Components: annotations, core Environment: Hibernate 3.5.x Reporter: Krzysztof Kowalczyk Priority: Blocker We use hibernate annotations and hibernate search in our project. After we moved to hibernate 3.5.2 (and 3.5.1 before that) we are having the following errors: java.lang.NullPointerException at org.hibernate.engine.EntityEntry.getLoadedValue(EntityEntry.java:255) at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:232) at org.hibernate.engine.Cascade.cascade(Cascade.java:161) at org.hibernate.engine.Cascade.cascade(Cascade.java:127) at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.cascadeOnUpdate(DefaultSaveOrUpdateEventListener.java:376) at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.performUpdate(DefaultSaveOrUpdateEventListener.java:350) at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsDetached(DefaultSaveOrUpdateEventListener.java:246) at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.performSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:112) at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:93) at org.hibernate.impl.SessionImpl.fireSaveOrUpdate(SessionImpl.java:677) at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:669) at org.hibernate.engine.CascadingAction$5.cascade(CascadingAction.java:252) at org.hibernate.engine.Cascade.cascadeToOne(Cascade.java:392) at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:335) at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:204) at org.hibernate.engine.Cascade.cascadeCollectionElements(Cascade.java:425) at org.hibernate.engine.Cascade.cascadeCollection(Cascade.java:362) at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:338) at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:204) at org.hibernate.engine.Cascade.cascade(Cascade.java:161) at org.hibernate.event.def.AbstractFlushingEventListener.cascadeOnFlush(AbstractFlushingEventListener.java:154) at org.hibernate.event.def.AbstractFlushingEventListener.prepareEntityFlushes(AbstractFlushingEventListener.java:145) at org.hibernate.event.def.AbstractFlushingEventListener.flushEverythingToExecutions(AbstractFlushingEventListener.java:88) at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50) at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1206) at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:375) at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:137) at org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:655) at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:709) at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:678) at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:321) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:116) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy67.initializePlacowka(Unknown Source) In different place we have the same problem: [java] java.lang.NullPointerException [java] at org.hibernate.engine.EntityEntry.getLoadedValue(EntityEntry.java:255) [java] at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:232) [java] at org.hibernate.engine.Cascade.cascade(Cascade.java:161) [java] at org.hibernate.engine.Cascade.cascade(Cascade.java:127) [java] at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.cascadeOnUpdate(DefaultSaveOrUpdateEventListener.java:376) [java] at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.performUpdate(DefaultSaveOrUpdateEventListener.java:350) [java] at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsDetached(DefaultSaveOrUpdateEventListener.java:246) [java] at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.performSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:112) [java] at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:93) [java] at org.hibernate.impl.SessionImpl.fireSaveOrUpdate(SessionImpl.java:677) [java] at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:669) [java] at org.hibernate.engine.CascadingAction$5.cascade(CascadingAction.java:252) [java] at org.hibernate.engine.Cascade.cascadeToOne(Cascade.java:392) [java] at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:335) [java] at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:204) [java] at org.hibernate.engine.Cascade.cascade(Cascade.java:161) [java] at org.hibernate.event.def.AbstractSaveEventListener.cascadeBeforeSave(AbstractSaveEventListener.java:451) [java] at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:288) [java] at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:204) [java] at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:144) [java] at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:210) [java] at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:195) [java] at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.performSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:117) [java] at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:93) [java] at org.hibernate.impl.SessionImpl.fireSaveOrUpdate(SessionImpl.java:677) [java] at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:669) [java] at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:665) The NPE is thrown because "loadedState" field is null. The exception seems to occur for instance when we have OneToOne with Cascade.DELETE_ORPHAN (or orphanRemoval="true"), CascadeType.SAVE_UPDATE and CascadeType.DELETE. I will try to create a simple example to reproduce the problem. -- 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

13 years, 6 months

19
47
0 / 0

[Hibernate-JIRA] Created: (HHH-4910) L2 parent collection cache eviction when a child is added/updated/removed

by Julien Kronegg (JIRA)

L2 parent collection cache eviction when a child is added/updated/removed ------------------------------------------------------------------------- Key: HHH-4910 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4910 Project: Hibernate Core Issue Type: Improvement Components: core Affects Versions: 3.3.1 Environment: Hibernate 3.3.1, DB2 390 Reporter: Julien Kronegg Priority: Minor Hibernate should automatically evict the collection cache an entity is persisted/updated/removed. Some precisions: - I'm not wanting to update the collection cache, evicting is fine - Doing persisted/updated/removed operation by using the collection add/remove evicts the collection - Doing persisted/updated/removed operation on the child entity does not evict the collection h3. Test case I have test case with a Parent entity which holds a OneToMany Set<Child> called 'children': {code} ... @Entity @Table(...) public class Parent { @Id private long id; @OneToMany(mappedBy="parent", fetch=FetchType.LAZY) @Cache(usage=CacheConcurrencyStrategy.NONSTRICT_READ_WRITE) private Set<Child> children; ... getters and setters } @Entity @Table(...) public class Child { @Id private long id; @ManyToOne() private Parent parent; ... getters and setters } {code} Level 2 cache is configured as follow: - EhCache 1.6.2, default configuration, L2 cache activated - entities are not cached - the 'children' collection is cached - no queries are cached The L2 cache works as expected when reading the Parent's children collection size: 1. new EntityManager 2. loading myParent -> makes a SQL query on the Parent table 3. calling myParent.getChildren().size() -> makes a SQL query on the Child table 4. new EntityManager 5. loading myParent -> makes a SQL query on the Parent table (since entities are not cached) 6. calling myParent.getChildren().size() -> hit the L2 cache (no SQL queries) The test case consists in - persisting a new Child with a Parent - updating a Child's Parent (i.e. changing its Parent for another Parent) - deleting a Child with a Parent When doing the test case by managing the Parent.children collection (e.g. myParent.getChildren().add(myNewChild)), the L2 cache works as expected: the Parent.children collection is evicted from the L2 cache and the next myParent.getChildren().size() makes a SQL query. But when doing the test case by managing the Child.parent, the L2 cache does not work as expected: the Parent.children collection is not evicted from L2 cache. Example 1: persist {code} Parent myParent = em.find(Parent.class, 1); System.out.println(em.find(Parent.class, 1).getChildren().size()); // by now, the Parent has 0 children Child myChild = new Child(); myChild.setParent(myParent); em.persist(myChild); em.flush(); em = ... // get a new EntityManager System.out.println(em.find(Parent.class, 1).getChildren().size()); // still 0 children {code} --> myParent.children has still the previous size (i.e. 0 instead of 1) Example 2: update {code} Child myChild = em.find(Child.class, 1); Parent myParent = em.find(Parent.class, 1); em.refresh(myParent); // refresh to be sure to bypass the L2 collection cache System.out.println(em.find(Parent.class, 1).getChildren().size()); // by now, the Parent has 1 children myChild.setParent(null); em.flush(); em = ... // get a new EntityManager System.out.println(em.find(Parent.class, 1).getChildren().size()); // still 1 children {code} -> myParent.children has still the previous size (i.e. 1 instead of 0) Example 3: remove {code} Child myChild = em.find(Child.class, 1); Parent myParent = em.find(Parent.class, 1); em.refresh(myParent); // refresh to be sure to bypass the L2 collection cache System.out.println(em.find(Parent.class, 1).getChildren().size()); // by now, the Parent has 1 children em.remove(myChild); em.flush(); em = ... // get a new EntityManager System.out.println(em.find(Parent.class, 1).getChildren().size()); // still 1 children and raise EntityNotFoundException {code} -> myParent.children has still the previous size and a EntityNotFoundException is raised because the deleted cached element cannot be found in the database This problem is also reported here: - http://stackoverflow.com/questions/1505940/hibernate-ehcache-evicting-col... - http://stackoverflow.com/questions/1470502/hibernate-clean-collections-2n... And is more or less related to the following JIRA issues: - http://opensource.atlassian.com/projects/hibernate/browse/HHH-496 - http://opensource.atlassian.com/projects/hibernate/browse/HHH-1444 - http://opensource.atlassian.com/projects/hibernate/browse/HHH-1913 h3. Expected behavior For these test cases, I expected the L2 cache behavior to be as follow: 1. when a new Child is persisted/removed, the collection which own it is evicted from the collection cache This means: {code} mySessionFactory.evictCollection("Parent.children", myChild.getParent().getId()); {code} 2. when a Child parent changes, the collection which was owning the child AND the collection which own the child are evicted from the collection cache This means: {code} mySessionFactory.evictCollection("Parent.children", myChildBeforeChange.getParent().getId()); mySessionFactory.evictCollection("Parent.children", myChild.getParent().getId()); {code} This behavior would probably be implemented in the following classes: - org.hibernate.action.EntityInsertAction - org.hibernate.action.EntityDeleteAction - org.hibernate.action.EntityUpdateAction See http://opensource.atlassian.com/projects/hibernate/browse/HHH-1913 for a patch temptative (incomplete: some code is missing) h3. Workaround: When working with JPA/Hibernate annotations, the above behavior can be implemented using reflection as such (pseudo-code): 1. listen to persist/update/remove entity events: @EntityListeners, @PostPersist, @PostRemove, @PreUpdate 2. in the @PostPersist/@PostRemove entity event listener: a. get all @ManyToOne fields/properties of the entity class (i.e. 'children' property of Child) and get the mapped class (i.e. Parent) b. get the collectionName (i.e. field name of Parent class with @OneToMany annotation and a type of Collection<Child>) c. build the collectionRole as Parent.class.getName()+"."+collectionName d. get the entityKey as the identifier of the field found in (a) e. call mySessionFactory.evictCollection(collectionRole, entityKey) 3. in the @PreUpdate entity event listener: a. get all @ManyToOne fields/properties of the entity class (i.e. 'children' property of Child) and get the mapped class (i.e. Parent) b. get the collectionName (i.e. field name of Parent class with @OneToMany annotation and a type of Collection<Child>) c. build the collectionRole as Parent.class.getName()+"."+collectionName d. get the entityKey as the identifier of the field found in (a) for the current entity e. get the previousEntityKey as the identifier of the field found in (a) for the previous entity f. if entityKey!=previousEntityKey then call mySessionFactory.evictCollection(collectionRole, entityKey) call mySessionFactory.evictCollection(collectionRole, previousEntityKey) We tested this workaround with success. The event listener lasts for about 3 us/call (microseconds) which is okay. Advantages: - easy for the programmer (no need for entityManager.refresh(myParent) or mySessionFactory.evictCollections()) - clean code Disadvantages: - @EntityListeners annotation to be put on every entity - requires Hibernate configuration by annotations on entities (does not work with XML configuration) -- 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

13 years, 6 months

2
7
0 / 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

hibernate-issues May 2010