in set definitions named queries do not work as expected -------------------------------------------------------- Key: HHH-4059 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4059 Project: Hibernate Core Issue Type: Bug Affects Versions: 3.3.2 Environment: « Hide OS: Kubuntu 9.04 amd64, kernel 2.6.28-13-generic Java: java version "1.6.0_14" Java(TM) SE Runtime Environment (build 1.6.0_14-b08) Java HotSpot(TM) 64-Bit Server VM (build 14.0-b16, mixed mode) Hibernate: checked out from svn on 25.07.2009. Reporter: Stefan Endrullis Attachments: code.zip I've discovered a problem with named queries in hibernate's set definitions. For demonstration I've prepared a very small example implementation. It consists mainly of the following two classes (only most important attributes illustrated): class Account { Set<Transaction> transactions; } class Transaction { Account from; Account to; } I mapped both classes and their attribute with the help of hibernate. Thereby I used a named query to retrieve the list of transactions for an account, since this is the only way of avoiding redundance, I think. This is the mapping of the class Account: <hibernate-mapping> <class name="transactiontest.model.Account" table="account"> <id name="id" length="10"> <generator class="native"/> </id> <property name="name" length="255" not-null="true"/> <set name="transactions" table="transaction" inverse="true"> <key/> <one-to-many class="transactiontest.model.Transaction"/> <loader query-ref="transactions"/> </set> </class> <sql-query name="transactions"> <load-collection alias="tra" role="transactiontest.model.Account.transactions"/> <query-param name="id" type="integer"/> select {tra.*} from transaction tra where tra.from=:id or tra.to=:id </sql-query> </hibernate-mapping> When I try to get the transactions of an account via the getTransactions() method I do not get the expected result. But the named query seems to be correct because it works when I call it directly with the account id as parameter. For a fast reproduction I've created a minimal test program (junit test) and zipped it (see attachment). If you want to test it with your local MySQL database you can use the SQL script setup/mysql_setup.sql to setup the corresponding DB and the DB user. -- 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