[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-2159) Query that previously worked in 3.2.0CR2 does not work anymore
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2159?page=c...
]
Andy Dale commented on HHH-2159:
--------------------------------
The single table inheritance strategy being used is not that simple. If i ever got
hibernate to work with eclipse or to so i could test the mappings i might be able to help
more. The mapping i currently have is:
<?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="Expression" table="experssionHierarchy">
<id name="id" column="expression_id" type="int"
/>
<discriminator column="discrim" type="string"/>
<property name="expr" type="string" />
<property name="description" type="string" />
<property name="type" type="Expression.ExpressionType"
not-null="true" />
<set name="mExpressionTargets"
inverse="true"
cascade="save-update">
<key column="exptarg_id"/>
<one-to-many class="ExpressionTarget"/>
</set>
<subclass name="Rule" discriminator-value="rule">
<set name="Restrictions"
table="expressionHierarchy_restrictions">
<key column="expression_id"/>
<many-to-many column="expression_id"
unique="true"
class="Expression"/>
</set>
</subclass>
<subclass name="Restriction"
discriminator-value="restriction">
</subclass>
</class>
</hibernate-mapping>
I am not sure on how to specify the many-to-one between the 2 subclasses of the parent
class. But that aside form that it might work in standalone hibernate but that does not
matter to me as i am using hibernate as the underlying persistence layer of JBoss and not
in stand alone mode. So maybe the problem lies in the integration of hibernate and jboss.
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....
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira