[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-2159) Query that previously worked in 3.2.0CR2 does not work anymore

[Andy Dale (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2159?page=comments#action_24911 ] 

Andy Dale commented on HHH-2159:
--------------------------------

I have figured out what the issue/bug is with the new version :-)

After isolating the problem to the e.expression.class = Rule section of the query, i decided to experiment with a few things and discovered the fix for it.  

First off with i experimented with enclosing the Rule within single quotation marks, this query ran without any problems !!!!,  but did not return anything.   I then tried experimenting by putting the discriminator value within single quotation marks like so 'rule' and this fixed the problem.

So in my opinion this is not so much a bug, but rather an error in the documentation, as in the documentation it says:

"Likewise, the special property class accesses the discriminator value of an instance in the case of polymorphic persistence. A Java class name embedded in the where clause will be translated to its discriminator value.

from Cat cat where cat.class = DomesticCat"

I have assumed that DomesticCat was the class name, but even if it was the discriminator value it would not work with 3.2.0.GA as it is not enclosed in single quotation marks.





> Query that previously worked in 3.2.0CR2 does not  work anymore
> ---------------------------------------------------------------
>
>          Key: HHH-2159
>          URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2159
>      Project: Hibernate3
>         Type: Bug

>     Versions: 3.2.0.ga
>  Environment: hibernate 3.2.0GA, PostgreSQL 8.1.4 (using build 407 of the JDBC driver).  JDK 1.5.0_06, JBoss 4.0.4GA, Operating system is Fedora Core 5
>     Reporter: Andy Dale
>  Attachments: hibernate_testcase.tar.gz
>
>
> First off i do not know if this bug belongs to the Hibernate3(core) or Hibernate EntityManger branch, but have entered it against core because that is where the exception occurs (in org.hibernate.hql.ast.tree.FromClause.findIntendedAliasedFromElementBasedOnCrazyJPARequirements).
> I have a relativley simple entity setup up to test a proof of concept.  Persisting the data to the database is not a problem in the new version 3.2.0.GA, but the problems occurs when trying to perform a query on the persisted data, the very same query works with 3.2.0CR2 but gives a nullPointException in 3.2.0GA.
> I have attached the java source for the entities + session bean (in hibernate_testcase.tar.gz/entities file) and the java class (in hibernate_testcase.tar.gz/service file) that is used to persist and query the data, and because this was only meant to be a proof of concept i have also included the .ear archive as apart from the entity definitions and session bean the only other thing it contains is a JBoss .sar archive which calls the static persist and query methods in the session bean (service test.testcase).  Please note to use the .ear archive you need a datasource called Postgres_Test

-- 
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.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira