[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2159?page=c...
]
Peter Nigl commented on HHH-2159:
---------------------------------
Hello, I read all of your posts and followed the problem. I'm currently using
Hibernate 3.2.4 sp1 and it still does not work...
My query...
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SELECT new Bean(a.b.x1, a.x2, a.x3, a.x4, a.x5,a.x6, a.x7, a.b.c.x8) FROM DataEntity a
WHERE a.x2 IN (SELECT as.status FROM StatusEntity as WHERE as.okToBill != ?0) AND a.x4 IN
(SELECT ad.date FROM DateEntity ad WHERE ad.beginDate != ?1) ORDER BY a.b.x1, a.x2
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
It worked fine with Hibernate 3.1 but now it stopped working. I'm still running on
Jboss 4.0.4 So it must be a Hibarnate issue...
Is there a solution yet???
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
Issue Type: Bug
Affects 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: FromClause.java, FromClause.java.diff, hibernate_testcase.tar.gz,
HibernateTestcase.tar.gz, OrignalTest.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....
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira