July 2009 - hibernate-issues - Jboss List Archives

[Hibernate-JIRA] Commented: (HHH-1673) hql parsed with exception (with clause)

by Trygve Hardersen (JIRA)

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-1673?page=c... ] Trygve Hardersen commented on HHH-1673: --------------------------------------- I had a similar issue where a left join would reference a column from a previous left join in the "with" clause. The SQL for this works on MySQL at least, but Hibernate gave me the "with-clause referenced two different from-clause elements" error. I checked our the 3.3.2.GA tag source and managed to build it locally. I then commented our line 447 org.hibernate.hql.ast.HqlSqlWalker where the exception is thrown, and Hibernate is now generating the correct SQL for me without complaining. I'm not sure which implications this can have, but any queries that reached that point in the code would have resulted in an exception being thrown anyway. I guess Hibernate may generate invalid queries in some cases. > hql parsed with exception (with clause) > --------------------------------------- > > Key: HHH-1673 > URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-1673 > Project: Hibernate Core > Issue Type: Deprecation > Components: query-hql > Affects Versions: 3.1.3 > Reporter: Tomasz Bech > Attachments: HHH-1673.patch, HHH-1673.patch > > > The 'improvement' bug fix: http://opensource.atlassian.com/projects/hibernate/browse/HHH-1520 > has broken working functionality: > I found that after switching to 3.1.3 following construction is not working any longer: > (FootnoteTypeBO has collection 'descriptions' and reference to languageBO) > from FootnoteTypeBO as o > left outer join o.descriptions as t1 > with (t1.language in (select loid from LanguageBO where name = 'aa')) > --> exception: 'with-clause referenced two different from-clause elements'. > There is no implicit join as dewscribed in main anomaly, so it shouldn't cause the problem. So now there is no way to write correct hql/sql, and I don't see any 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

15 years, 5 months

1
0
0 / 0

[Hibernate-JIRA] Created: (HHH-4005) Restrictions should honor expressions and functions

by Atlassian Support (JIRA)

Restrictions should honor expressions and functions --------------------------------------------------- Key: HHH-4005 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4005 Project: Hibernate Core Issue Type: New Feature Reporter: Tarik Makota When using Restrictions where 2 columns/properties need to be concatanated and then compared to value hibernate is unable to do so. Example: PoJo: TABLE SNIPPET: ---------------------------------------------- FIRSTNAME VARCHAR2(50) LASTNAME VARCHAR2(50) JAVA ENTITY: ---------------------------------------------- @Colum (name="FIRSTNAME") private String firstName; @Colum (name="LASTNAME") private String lastName; ACTUAL PROBLEM (trivial example): ----------------------------------------------- Criteria crit.add(Restrictions.in( "concat(firstName,lastName) ", parmUserFullName)); << concat doesnt work -- 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, 5 months

1
0
0 / 0

[Hibernate-JIRA] Created: (HHH-4004) Allow embeddable classes to have prefix

by Atlassian Support (JIRA)

Allow embeddable classes to have prefix --------------------------------------- Key: HHH-4004 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4004 Project: Hibernate Core Issue Type: New Feature Reporter: Ricardo Mayerhofer Some times when using embedded classes, some of these classes have attributes with the same name. E.g.: Customer{ Address address; Document document; } Address{ String number; } Document{ String number; } This raises the following error: column: number (should be mapped with insert="false" update="false"). If we could specify a prefix for the embeddable class, the field in database would be much clear (address_number instead of number), and would solve this kind of issue. Thanks for considering. -- 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, 5 months

1
0
0 / 0

[Hibernate-JIRA] Created: (HBX-1130) Hibernate Tools as a Maven based project

by Jordi Fernandez (JIRA)

Hibernate Tools as a Maven based project ---------------------------------------- Key: HBX-1130 URL: http://opensource.atlassian.com/projects/hibernate/browse/HBX-1130 Project: Hibernate Tools Issue Type: Task Affects Versions: 3.2.4.GA Reporter: Jordi Fernandez It would be easier to contribute to the project if hibernate tools were a Maven based project. Some Hibernate projects are Maven based and are hosted under http://anonsvn.jboss.org/repos/hibernate/core/trunk/ and Ant based projects are under http://anonsvn.jboss.org/repos/hibernate/branches/Branch_3_2/HibernateExt/. We can help in moving Hibernate Tools to a Maven based project so that it can be hosted under http://anonsvn.jboss.org/repos/hibernate/core/trunk/. This way, contributing to Hibernate Tools would be much easier. We have already much of the work done and can contribute it pretty soon. -- 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, 5 months

1
0
0 / 0

[Hibernate-JIRA] Commented: (HHH-892) HQL parser does not resolve alias in ORDER BY clause

by Matt Fozard (JIRA)

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-892?page=co... ] Matt Fozard commented on HHH-892: --------------------------------- I also would welcome an explanation of why this isn't a bug. Perhaps someone could explain it in the HQL documentation, expand the "14.11 Order by" section from its hugely comprehensive 4 lines of text on this topic. > HQL parser does not resolve alias in ORDER BY clause > ----------------------------------------------------- > > Key: HHH-892 > URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-892 > Project: Hibernate Core > Issue Type: Bug > Components: query-hql > Affects Versions: 3.0.5 > Environment: Hibernate 3.0.5, MySQL, Tomcat > Reporter: Guido Laures > Priority: Minor > > When using an alias for an ORDER BY clause this is not always correctly resolved. Example: > SELECT SUM(A.x) AS mySum FROM MyClass AS A GROUP BY A.y ORDER BY mySum > does not work because "mySum" is not resolved in the ORDER BY clause which results in an exception telling that mySum is an unknown column. > Workaround (not to say "hack") is using: > SELECT SUM(A.x) AS mySum FROM MyClass AS A GROUP BY A.y ORDER BY col_0_0_ -- 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, 5 months

1
0
0 / 0

[Hibernate-JIRA] Commented: (HHH-1615) GROUP BY entity does not work

by Rafael Santini (JIRA)

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-1615?page=c... ] Rafael Santini commented on HHH-1615: ------------------------------------- I also ran into this problem with SQL Server. With MySQL the same query works. HQL: select count(emprestimo.exemplar.obra), emprestimo.exemplar.obra from Emprestimo emprestimo where emprestimo.data between ? and ? group by emprestimo.exemplar.obra order by count(emprestimo.exemplar.obra) desc SQL generated: select count(exemplar1_.id_obra) as col_0_0_, exemplar1_.id_obra as col_1_0_, obra2_.id as id157_, obra2_.mfn as mfn157_, obra2_.titulo as titulo157_, obra2_.localizacao as localiza4_157_, obra2_.id_idioma as id5_157_, obra2_.id_tipo_obra as id6_157_, obra2_.id_categoria_obra as id7_157_, obra2_.id_area_obra as id8_157_, obra2_.id_base as id9_157_ from bs_emp_mov_emprestimo emprestimo0_, bs_emp_ace_exemplar exemplar1_, bs_emp_ace_obra obra2_ where emprestimo0_.id_exemplar=exemplar1_.id and exemplar1_.id_obra=obra2_.id and (emprestimo0_.data between ? and ?) group by exemplar1_.id_obra order by count(exemplar1_.id_obra) desc Error: A coluna 'bs_emp_ace_obra.ID' é inválida na lista de seleção porque não está contida em uma função agregada nem na cláusula GROUP BY. > GROUP BY entity does not work > ----------------------------- > > Key: HHH-1615 > URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-1615 > Project: Hibernate Core > Issue Type: Improvement > Components: query-hql > Affects Versions: 3.2.5 > Environment: PostgreSQL 8.1.3, Hibernate 3.1.3 > Reporter: Xavier Bugaud > Assignee: Anthony Patricio > Priority: Critical > Attachments: group-by-discriminator.patch, hibernate-group-by.diff > > > The query : "select cat, count(*) from Cat cat group by cat" does not work. > ERROR: column "xxxx" must appear in the GROUP BY clause or be used in an aggregate function > See : > - http://forum.hibernate.org/viewtopic.php?t=953716 > - http://jira.nhibernate.org/browse/NH-528 -- 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, 5 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

hibernate-issues July 2009