Can't tell you why this breaks as I have not looked at that projection
stuff. I would guess that it is not *properly* resolving the return
types until there is actually a result set.
yes got that, but i was just wondering if this is expected/wanted behavior.
/max
-----Original Message-----
From: Max Rydahl Andersen [mailto:[EMAIL PROTECTED]
Sent: Friday, January 28, 2005 2:30 PM
To: Steve Ebersole; Hibernate development
Subject: Re: [Hibernate] Criteria curiosity...
but this check is something hibernate generates. its not db dependent
AFAIK.
Not sure which DB you are using, but for example I've noticed that
HSQL
seems to not parse the entire statement string upfront which can lead
to
issue like this. It leaves parsing certain pieces relative to its
internal working datasets; if there are no results in those working
sets, you get no errors. Specifically I have seen this with
correlated
sub-queries.
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Max
Rydahl Andersen
Sent: Friday, January 28, 2005 9:56 AM
To: Hibernate development
Subject: [Hibernate] Criteria curiosity...
Hi,
while working on Critiera i "bumped" into this funny behavior:
Doing the following Critieria on an empty db gives no error:
s.createCriteria(Student.class)
.add( Expression.like("name", "Gavin",
MatchMode.START) )
.addOrder( Order.asc("name") )
.createCriteria("enrolments", "e")
.addOrder( Order.desc("year") )
.addOrder( Order.desc("semester") )
.createCriteria("course")
.addOrder( Order.asc("description") )
.setProjection( Expression.projection()
.add(
Expression.property("this.name") )
.add(
Expression.property("e.year") )
.add(
Expression.property("e.semester") )
.add(
Expression.property("courseCode") )
.add(
Expression.property("description") )
)
.uniqueResult();
but when data is available i get an error saying
that courseCode is not available on Student - which is totally
correct.
(using explicit criteria aliases solves it)
I'm just wondering why this is not discovered when the query gives no
result - it should still be able to tell
that courseCode is not on Student - is this expected behavior ?
--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/
-------------------------------------------------------
This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting
Tool for open source databases. Create drag-&-drop reports. Save time
by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc.
Download a FREE copy at http://www.intelliview.com/go/osdn_nl
_______________________________________________
hibernate-devel mailing list
hibernate-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/hibernate-devel
