From: <leg...@at...> - 2003-10-22 21:20:27
|
The following comment has been added to this issue: Author: Gavin King Created: Wed, 22 Oct 2003 12:50 PM Body: oooh sorry I misread .... the problem is that the join is missing. Thanks, we'll fix this. --------------------------------------------------------------------- View the issue: http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-417 Here is an overview of the issue: --------------------------------------------------------------------- Key: HB-417 Summary: Criteria API and key-many-to-one Type: Bug Status: Unassigned Priority: Minor Project: Hibernate2 Components: core Versions: 2.1 beta 4 Assignee: Reporter: Sebastien Cesbron Created: Wed, 22 Oct 2003 3:07 AM Updated: Wed, 22 Oct 2003 3:08 AM Environment: Win2k SQLServer with jTds driver Description: I have one class Bar with a primary key composed of a 'key-many-to-one' to a class Foo. I want to find a Bar instance with a Foo id so I have this criteria : Criteria criteria = session.createCriteria(Bar.class); criteria.createCriteria("foo").add(Expression.eq("id", new Integer(1))); Bar bar = (Bar) criteria.uniqueResult(); Then I have this sql statement select this.ID_FOO as ID_FOO0_, this.text as text0_ from BAR this where x0_.id=1 which fails because x0_ isn't defined. With an HQL query it works. --------------------------------------------------------------------- JIRA INFORMATION: 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 If you want more information on JIRA, or have a bug to report see: http://www.atlassian.com/software/jira |
From: <leg...@at...> - 2003-10-23 02:55:17
|
The following comment has been added to this issue: Author: Sebastien Cesbron Created: Wed, 22 Oct 2003 6:06 AM Body: when I use criteria.createCriteria("foo").add(Expression.eq("foo", new Integer(1))); I have the exception : net.sf.hibernate.QueryException: could not resolve property: foo of: Foo [null] at net.sf.hibernate.persister.AbstractPropertyMapping.toColumns(AbstractPropertyMapping.java:45) at net.sf.hibernate.expression.AbstractCriterion.getColumns(AbstractCriterion.java:35) at net.sf.hibernate.expression.SimpleExpression.toSqlString(SimpleExpression.java:40) at net.sf.hibernate.loader.CriteriaLoader.<init>(CriteriaLoader.java:57) at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:3487) at net.sf.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:165) at net.sf.hibernate.impl.CriteriaImpl.uniqueResult(CriteriaImpl.java:310) at Test.testHibernate(Test.java:52) at Test.main(Test.java:25) --------------------------------------------------------------------- View the issue: http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-417 Here is an overview of the issue: --------------------------------------------------------------------- Key: HB-417 Summary: Criteria API and key-many-to-one Type: Bug Status: Unassigned Priority: Minor Project: Hibernate2 Components: core Versions: 2.1 beta 4 Assignee: Reporter: Sebastien Cesbron Created: Wed, 22 Oct 2003 3:07 AM Updated: Wed, 22 Oct 2003 3:08 AM Environment: Win2k SQLServer with jTds driver Description: I have one class Bar with a primary key composed of a 'key-many-to-one' to a class Foo. I want to find a Bar instance with a Foo id so I have this criteria : Criteria criteria = session.createCriteria(Bar.class); criteria.createCriteria("foo").add(Expression.eq("id", new Integer(1))); Bar bar = (Bar) criteria.uniqueResult(); Then I have this sql statement select this.ID_FOO as ID_FOO0_, this.text as text0_ from BAR this where x0_.id=1 which fails because x0_ isn't defined. With an HQL query it works. --------------------------------------------------------------------- JIRA INFORMATION: 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 If you want more information on JIRA, or have a bug to report see: http://www.atlassian.com/software/jira |
From: <leg...@at...> - 2003-10-24 03:03:48
|
The following comment has been added to this issue: Author: Gavin King Created: Thu, 23 Oct 2003 1:25 PM Body: OK - this is a little bit harder to make work than I thought (its not so much a "bug" as a "new feature"). So I'll have a look at it when I get a chance. Unless you have a really pressing need for it, this won't be very soon.... --------------------------------------------------------------------- View the issue: http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-417 Here is an overview of the issue: --------------------------------------------------------------------- Key: HB-417 Summary: Criteria API and key-many-to-one Type: Bug Status: Assigned Priority: Minor Project: Hibernate2 Components: core Versions: 2.1 beta 4 Assignee: Gavin King Reporter: Sebastien Cesbron Created: Wed, 22 Oct 2003 3:07 AM Updated: Wed, 22 Oct 2003 12:51 PM Environment: Win2k SQLServer with jTds driver Description: I have one class Bar with a primary key composed of a 'key-many-to-one' to a class Foo. I want to find a Bar instance with a Foo id so I have this criteria : Criteria criteria = session.createCriteria(Bar.class); criteria.createCriteria("foo").add(Expression.eq("id", new Integer(1))); Bar bar = (Bar) criteria.uniqueResult(); Then I have this sql statement select this.ID_FOO as ID_FOO0_, this.text as text0_ from BAR this where x0_.id=1 which fails because x0_ isn't defined. With an HQL query it works. --------------------------------------------------------------------- JIRA INFORMATION: 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 If you want more information on JIRA, or have a bug to report see: http://www.atlassian.com/software/jira |
From: <leg...@at...> - 2003-10-24 03:53:36
|
The following comment has been added to this issue: Author: Gavin King Created: Wed, 22 Oct 2003 5:53 AM Body: What happens when you use: criteria.createCriteria("foo").add(Expression.eq("foo", new Integer(1))); --------------------------------------------------------------------- View the issue: http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-417 Here is an overview of the issue: --------------------------------------------------------------------- Key: HB-417 Summary: Criteria API and key-many-to-one Type: Bug Status: Unassigned Priority: Minor Project: Hibernate2 Components: core Versions: 2.1 beta 4 Assignee: Reporter: Sebastien Cesbron Created: Wed, 22 Oct 2003 3:07 AM Updated: Wed, 22 Oct 2003 3:08 AM Environment: Win2k SQLServer with jTds driver Description: I have one class Bar with a primary key composed of a 'key-many-to-one' to a class Foo. I want to find a Bar instance with a Foo id so I have this criteria : Criteria criteria = session.createCriteria(Bar.class); criteria.createCriteria("foo").add(Expression.eq("id", new Integer(1))); Bar bar = (Bar) criteria.uniqueResult(); Then I have this sql statement select this.ID_FOO as ID_FOO0_, this.text as text0_ from BAR this where x0_.id=1 which fails because x0_ isn't defined. With an HQL query it works. --------------------------------------------------------------------- JIRA INFORMATION: 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 If you want more information on JIRA, or have a bug to report see: http://www.atlassian.com/software/jira |