October 2007 - hibernate-issues - Jboss List Archives

[Hibernate-JIRA] Created: (HHH-2258) Bad SQL Grammer: Implicit join when using r.fooClass.attributes[?]=?

by Darryl Miles (JIRA)

Bad SQL Grammer: Implicit join when using r.fooClass.attributes[?]=? -------------------------------------------------------------------- Key: HHH-2258 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2258 Project: Hibernate3 Type: Bug Components: core Versions: 3.1.3 Environment: MySQL server this has been tested with. Reporter: Darryl Miles Priority: Critical Attachments: test_joinedmapfilter.zip Please find this test case atteched to demonstrate the bug, maybe you can add to the hibernate distribution for future testing and piece of mind for me. The error: Testsuite: org.hibernate.test.joinedmapfilter.JoinedMapFilterTest Tests run: 1, Failures: 0, Errors: 1, Time elapsed: 0.498 sec Testcase: testJoinedMapFilter took 0.495 sec Caused an ERROR could not execute query org.hibernate.exception.SQLGrammarException: could not execute query at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.loader.Loader.doList(Loader.java:2147) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2028) at org.hibernate.loader.Loader.list(Loader.java:2023) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:393) at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338) at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121) at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79) at org.hibernate.test.joinedmapfilter.JoinedMapFilterTest.testJoinedMapFilter(JoinedMapFilterTest.java:116) at org.hibernate.test.TestCase.runTest(TestCase.java:250) at org.hibernate.test.TestCase.runBare(TestCase.java:316) Caused by: java.sql.SQLException: Unknown table 'productdet1_' in where clause at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666) at com.mysql.jdbc.Connection.execSQL(Connection.java:2994) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:936) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1030) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186) at org.hibernate.loader.Loader.getResultSet(Loader.java:1668) at org.hibernate.loader.Loader.doQuery(Loader.java:662) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224) at org.hibernate.loader.Loader.doList(Loader.java:2144) ... 25 more SELECT r FROM com.company.Toplevel AS r WHERE r.toplevel=? AND rec.productDetail.attributes[?]=? Also my recent post: http://forum.hibernate.org/viewtopic.php?t=966374&start=0&postdays=0&post... This testcase has been tested with 3.1.3 and 3.2.0-ga. 2nd problem: There is also another situation in the testcase which I found through serendipity which causes a NPE inside hibernate because I misspelled "r" as "rec". Check out the commented out section and swap over the createQuery() lines to demonstrate that 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

15 years, 11 months

1
3
0 / 0

[Hibernate-JIRA] Created: (HHH-2922) DML - update does not support component property in the set-clause

by Roman Pichlík (JIRA)

DML - update does not support component property in the set-clause ------------------------------------------------------------------ Key: HHH-2922 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2922 Project: Hibernate3 Issue Type: Bug Components: query-hql Affects Versions: 3.2.4.sp1 Reporter: Roman Pichlík Using of component property in in the set-clause of HQL update query leads to: org.springframework.orm.hibernate3.HibernateQueryException: unexpected AST node: AND near line 1, column 43 [update x a set a.component = : where a._revision = :revision and a._uuid = :uuid]; nested exception is org.hibernate.hql.ast.QuerySyntaxException: unexpected AST node: AND near line 1, column 43 [update artifactBase a set a._artifactData = :artifactData where a._revision = :revision and a._uuid = :uuid] -- 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

15 years, 11 months

3
2
0 / 0

[Hibernate-JIRA] Created: (ANN-603) Using @CollectionOfEelements with FetchMode.JOIN and FetchType.EAGER to map a Map breaks Example criteria

by Philippe Laflamme (JIRA)

Using @CollectionOfEelements with FetchMode.JOIN and FetchType.EAGER to map a Map breaks Example criteria --------------------------------------------------------------------------------------------------------- Key: ANN-603 URL: http://opensource.atlassian.com/projects/hibernate/browse/ANN-603 Project: Hibernate Annotations Issue Type: Bug Components: search Affects Versions: 3.3.0.ga Environment: hibernate-core-3.2.2.jar Reporter: Philippe Laflamme Attachments: ann-example_eager_join.patch I'm using CollectionOfElements to map a Map<String, @Embeddable>. I want it to eagerly join the associated table to fill the map. When I load the Entity using its PK, I obtain a single object with multiple entries in the Map, which is the expected behaviour. If I load the same Entity using an Example criteria (matching one of its property), I get one Entity per entry in the Map. If you use FetchMode.SELECT, the resulting Example query returns a single entity with multiple values in the Map (expected behaviour). Attached is a patch against annotations_3_3_0_GA that creates a test case in CollectionElementTest that reproduces 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

15 years, 11 months

4
3
0 / 0

[Hibernate-JIRA] Created: (EJB-300) create-drop with c3p0 causes SQLException

by Chris Redekop (JIRA)

create-drop with c3p0 causes SQLException ----------------------------------------- Key: EJB-300 URL: http://opensource.atlassian.com/projects/hibernate/browse/EJB-300 Project: Hibernate Entity Manager Issue Type: Bug Components: EntityManager Affects Versions: 3.2.1 Environment: hibernate-entitymanager 3.2.1.ga, c3p0 0.9.0, and postgreSQL 8.1.8 or hsqldb 1.8.7 Reporter: Chris Redekop Attachments: c3p0Test.tar.gz In the attached test application, an EntityManagerFactory is created and then closed. Closing the EMF causes line 801 of org.hibernate.impl.SessionFactoryImpl to call getConnectionProvider().close(), which eventually results in c3p0's PooledDataSource being closed. Line 808 of org.hibernate.impl.SessionFactoryImpl the calls schemaExport.drop(), which attempts to acquire a connection from the data source and causes the following SQLException. java.sql.SQLException: com.mchange.v2.c3p0.PoolBackedDataSource@fced4 [ connectionPoolDataSource -> com.mchange.v2.c3p0.WrapperConnectionPoolDataSource@9505f [ acquireIncrement -> 1, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 9505f, idleConnectionTestPeriod -> 100, initialPoolSize -> 10, maxIdleTime -> 100, maxPoolSize -> 100, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 10, nestedDataSource -> com.mchange.v2.c3p0.DriverManagerDataSource@80cac9 [ description -> null, driverClass -> null, factoryClassLocation -> null, identityToken -> 80cac9, jdbcUrl -> jdbc:hsqldb:., properties -> {user=******, password=******, autocommit=true, release_mode=auto} ], preferredTestQuery -> null, propertyCycle -> 300, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, usesTraditionalReflectiveProxies -> false ], factoryClassLocation -> null, identityToken -> fced4, numHelperThreads -> 3 ] has been closed() -- you can no longer use it. This exception is swallowed so it does not cause a test error, but it does appear in the console output. -- 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

15 years, 11 months

7
13
0 / 0

[Hibernate-JIRA] Created: (HHH-2820) Can not set HOLD_CURSORS_OVER_COMMIT when creating ScrollableResults

by steven (JIRA)

Can not set HOLD_CURSORS_OVER_COMMIT when creating ScrollableResults -------------------------------------------------------------------- Key: HHH-2820 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2820 Project: Hibernate3 Issue Type: Improvement Components: core Affects Versions: 3.2.5 Environment: N/A Reporter: steven Currently, I can not set HOLD_CURSORS_OVER_COMMIT when creating ScrollableResults. It seams that the method in Query: public ScrollableResults scroll(ScrollMode scrollMode) throws HibernateException; should be added with the second argument: ResultSet holdability. -- 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

15 years, 11 months

3
3
0 / 0

[Hibernate-JIRA] Created: (HBX-964) add serialVersionUID to entity classes

by Dan Allen (JIRA)

add serialVersionUID to entity classes -------------------------------------- Key: HBX-964 URL: http://opensource.atlassian.com/projects/hibernate/browse/HBX-964 Project: Hibernate Tools Issue Type: Improvement Components: hbm2java Affects Versions: 3.2beta10 Reporter: Dan Allen Priority: Minor The serialVersionUID is recommended for classes that implement java.io.Serializable. The hbm2java task should either set the serialVersionUID to 1L or automatically generate a value. I prefer setting it to 1L because it is easy and it will work, but if you feel motivated, you can look at what Eclipse does to generate this value from the class signature. I have included a patch that just sets it to 1L. -- 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

15 years, 11 months

6
18
0 / 0

[Hibernate-JIRA] Created: (HHH-2066) HSQL DB + multi-schema --> raised an exception (Problem to get an increment key [select max(id) from table)

by XOrangOutan (JIRA)

HSQL DB + multi-schema --> raised an exception (Problem to get an increment key [select max(id) from table) ----------------------------------------------------------------------------------------------------------- Key: HHH-2066 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2066 Project: Hibernate3 Type: Bug Components: core Versions: 3.2.0.cr4 Environment: HSQL DB 1.8.x Reporter: XOrangOutan When trying to save an object that has an "incremental" primary key, Hibernate API tries to know what the max current id is by executing a "SELECT MAX". Though, in this particular sql query, schema name is not taken into account (in hsqldialect). This cause an error that prevents anyone from carrying out unit tests. This bug also exists on 3.x versions -- 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

15 years, 11 months

4
4
0 / 0

[Hibernate-JIRA] Created: (HHH-2781) Changes to fields marked as non-updateable written to L2 cache

by Steve Ebersole (JIRA)

Changes to fields marked as non-updateable written to L2 cache -------------------------------------------------------------- Key: HHH-2781 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2781 Project: Hibernate3 Issue Type: Bug Components: caching (L2) Reporter: Steve Ebersole Assignee: Steve Ebersole When the value a field marked as update="false" is changed, that changed state is written to the L2 cache. This occurs at least on reattachment, but I assume it also occurs for managed entities (need to verify). Viable solutions include: 1) disallow this combination (cached + non-updateable, non-generationed properties) 2) implicitly treat these properties as generated. Workaround is to mark these fields as generated. -- 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

15 years, 11 months

1
7
0 / 0

[Hibernate-JIRA] Created: (HHH-2802) Support HQL style order by (JPA @OrderBy)

by Emmanuel Bernard (JIRA)

Support HQL style order by (JPA @OrderBy) ----------------------------------------- Key: HHH-2802 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2802 Project: Hibernate3 Issue Type: New Feature Components: core Reporter: Emmanuel Bernard Fix For: 3.3 Hibernate Annotations works around the lack of ability to define Order by clause using properties rather than columns by doing the translation at configuration time. Unfortunately, this cannot take alias into account. So moving this logic to the core would make sense -- 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

15 years, 11 months

2
8
0 / 0

[Hibernate-JIRA] Created: (ANN-651) Bad SQL generated when using the @OrderBy annotation

by Eyal Lupu (JIRA)

Bad SQL generated when using the @OrderBy annotation ---------------------------------------------------- Key: ANN-651 URL: http://opensource.atlassian.com/projects/hibernate/browse/ANN-651 Project: Hibernate Annotations Issue Type: Bug Affects Versions: 3.3.0.ga Environment: Hibernate Annotations 3.3.0.GA Hibernate 3.2.5 EntityManager 3.3.1.GA Hibernate Validator 3.0.0.GA Oracle 10g Reporter: Eyal Lupu Attachments: orderBy-bug-test-case.zip When upgrading to the versions above a code which works for months now stopped working, the reason is that Hibernate generates a bad SQL statment. Attached is a test case: Having the following classes Parent / \ Child1 Child2 The parent has a property named 'elementType'. Child1 has a list of Child2 (its sibling) which is ordered using the @OrderBy("elementType") annotation. When fetching a Child1 instance, using the EntityManager.find(...) method, Hibernate generates an invalid SQL: Hibernate: /* load bug.Child1 */ select child1x0_.ID as ID0_1_, child1x0_.ELEMENT_TYPE as ELEMENT3_0_1_, elements1_.PARENT_ID as PARENT4_3_, elements1_.ID as ID3_, elements1_.ID as ID0_0_, elements1_.ELEMENT_TYPE as ELEMENT3_0_0_, elements1_.PARENT_ID as PARENT4_0_0_ from BUG_TST child1x0_ left outer join BUG_TST elements1_ on child1x0_.ID=elements1_.PARENT_ID where child1x0_.ID=? and child1x0_.DTYPE='Child1' order by BUG_TST.ELEMENT_TYPE asc The error is in the order by clause, you can't use the table name if you gave it an alias - you should use the alias. * If I move the 'elementType' property down to Child2 it works! *If I remove the @OrderBy it also works -- It is hard to know if this is an Hibernate core or Hibernate annotation bug. This is the exception: Caused by: org.hibernate.exception.SQLGrammarException: could not load an entity: [bug.Child1#1] 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:3044) at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:395) 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.proxyOrLoad(DefaultLoadEventListener.java:195) at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:103) at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:878) at org.hibernate.impl.SessionImpl.get(SessionImpl.java:815) at org.hibernate.impl.SessionImpl.get(SessionImpl.java:808) at org.hibernate.ejb.AbstractEntityManagerImpl.find(AbstractEntityManagerImpl.java:175) ... 1 more Caused by: java.sql.SQLException: ORA-00904: "BUG_TST"."ELEMENT_TYPE": invalid identifier 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:743) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:799) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1038) at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:839) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1133) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3329) 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) ... 13 more -- Attached is a test case -- 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

15 years, 11 months

3
8
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

hibernate-issues October 2007