It shouldn't make any difference, but just for grins try:
def assessment = Assessment.findByAsessorAndPosting(judge,posting)
I'd also load up a few records in your bootstrap. Does it work when
you have matching data?
You can try playing with this by in the console. Does it work from there?
If none of that works, trying using criteria and/or hql. But I can
tell you that in general, dynamic finders like that do work.
---------------------------
www.maf.org/rhoads
www.ontherhoads.org
On Fri, Sep 2, 2011 at 9:42 PM, Gene Golovchinsky <
[hidden email]> wrote:
> The single parameter finder works. Here is the log:
>
>
> 11/09/02 20:38:59 DEBUG hibernate.SQL: select this_.id as id0_0_,
> this_.version as version0_0_, this_.assessor_id as assess
> or3_0_0_, this_.comment as comment0_0_, this_.date_created as date5_0_0_,
> this_.last_updated as last6_0_0_, this_.value as
> value0_0_ from assessment this_ where this_.assessor_id=?
> 11/09/02 20:38:59 TRACE type.LongType: binding '2' to parameter: 1
> Some assessment [null] by com.fxpal.docusearch.Searcher : 2
>
> This last line is printed by my code after the findByAssessor() call returns
> null. (As it should, since I cannot create any assessments at the moment!)
>
> The rest of the log is as before:
>
> 11/09/02 20:38:59 DEBUG hibernate.SQL: select this_.id as id0_0_,
> this_.version as version0_0_, this_.assessor_id as assess
> or3_0_0_, this_.comment as comment0_0_, this_.date_created as date5_0_0_,
> this_.last_updated as last6_0_0_, this_.value as
> value0_0_ from assessment this_ where this_.id=? and this_.assessor_id=?
> 11/09/02 20:38:59 TRACE type.LongType: binding '2' to parameter: 1
> 11/09/02 20:38:59 ERROR util.JDBCExceptionReporter: No value specified for
> parameter 2
> 11/09/02 20:38:59 ERROR docusearch.UiController: Could not save assessment
> org.springframework.dao.InvalidDataAccessResourceUsageException: could not
> execute query; SQL [select this_.id as id0_0_, t
> his_.version as version0_0_, this_.assessor_id as assessor3_0_0_,
> this_.comment as comment0_0_, this_.date_created as date5
> _0_0_, this_.last_updated as last6_0_0_, this_.value as value0_0_ from
> assessment this_ where this_.id=? and this_.assessor
> _id=?]; nested exception is org.hibernate.exception.SQLGrammarException:
> could not execute query
> at
> org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:
> 629)
> at
> org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)
> at
> org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:411)
> ...
>
> Thanks for thinking about this!
>
> Gene
>
> --
> View this message in context:
http://grails.1312388.n4.nabble.com/problem-using-mysql-with-hibernate-grails-v1-3-7-tp3787337p3787445.html> Sent from the Grails - user mailing list archive at Nabble.com.
>
> ---------------------------------------------------------------------
> To unsubscribe from this list, please visit:
>
>
http://xircles.codehaus.org/manage_email>
>
>
---------------------------------------------------------------------
To unsubscribe from this list, please visit:
http://xircles.codehaus.org/manage_email
Locked
