7:59 p.m.
Criteria.createCriteria(associationPath) not works for Key-many-to-one
----------------------------------------------------------------------
Key: HHH-2941
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2941
Project: Hibernate3
Issue Type: Bug
Components: query-criteria
Affects Versions: 3.2.4.sp1
Environment: Hibernate 3.2.4.sp1 + MySQL
Reporter: Eddie Man
Attachments: criteria_test.tar.gz
Suppose I had 2 class with the following content:
A.java
=================
public class A {
public A() {
}
public int ID;
public java.util.Set bs = new java.util.HashSet();
}
B.java
=================
import java.io.Serializable;
public class B implements Serializable {
public B() {
}
public int ID;
public A a;
}
A.hbm.xml
=================
<?xml version="1.0" encoding="utf-8" ?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD
3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<class name="A" table="A" lazy="false">
<id name="ID" column="ID" type="integer"
unsaved-value="0" access="field">
<generator class="native">
</generator>
</id>
<set name="bs" lazy="true" cascade="save-update,lock"
inverse="true" access="field">
<key column="AID" not-null="true"/>
<one-to-many class="B"/>
</set>
</class>
</hibernate-mapping>
B.hbm.xml
=================
<?xml version="1.0" encoding="utf-8" ?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD
3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<class name="B" table="B" lazy="false">
<composite-id>
<key-property name="ID" column="ID" type="integer"
access="field"/>
<key-many-to-one name="a" column="AID" class="A"
access="field">
</key-many-to-one>
</composite-id>
</class>
</hibernate-mapping>
Now, I want to find the B object with the specify B.ID and A.ID. Here is my code
Criteria criteria = session.createCriteria(B.class);
criteria.add(Expression.eq("ID", new Integer(2))); // B.ID = 2
criteria.createCriteria("a").add(Expression.eq("ID", new Integer(4)));
// A.ID = 4
B b = (B) criteria.uniqueResult();
I turned on the show_sql in my configure file so that it will prompt all the sql statement
in runtime, then executing the code, here is the printout:
09:35:59,096 WARN RootClass:211 - composite-id class does not override equals(): B
09:35:59,099 WARN RootClass:216 - composite-id class does not override hashCode(): B
Hibernate:
select
this_.ID as ID1_0_,
this_.AID as AID1_0_
from
B this_
where
this_.ID=?
and a1_.ID=?
09:35:59,982 WARN JDBCExceptionReporter:77 - SQL Error: 1054, SQLState: 42S22
09:35:59,982 ERROR JDBCExceptionReporter:78 - Unknown column 'a1_.ID' in
'where clause'
Exception in thread "main" 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:2223)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
at org.hibernate.loader.Loader.list(Loader.java:2099)
at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:94)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1571)
at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283)
at org.hibernate.impl.CriteriaImpl.uniqueResult(CriteriaImpl.java:305)
at ListTestData.main(ListTestData.java:17)
Caused by: java.sql.SQLException: Unknown column 'a1_.ID' in 'where
clause'
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2921)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1570)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2978)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2902)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:930)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1024)
at
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
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.doList(Loader.java:2220)
... 7 more
It look like that the hibernate is missing the join table for the key-many-to-one. I had
tested to using <key-property> and <many-to-one insert="false"
update="false"> instread of <key-many-to-one>, and get no problem for
that, so is it the bug on key many to one?
The schema and test case is attached.
Steps of reproduce the problem with the attached project:
=========
1. Execute the schema.ddl in to mysql db.
2. Execute java application "InsertTestData"
3. Record the last inserted id from the database and modify the "ListTestData"
so that the expression value is correct.
4. Execute java application "ListTestData"
--
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