Hibernate version: 2.1.4
I need to set parameter of a query that lives inside quotes. The query is:
Code:
from School s where s.schoolName like ':letter%'
I am getting the following exception
Code:
Testsuite: edu.columbia.law.admissions.domain.SystemDictionaryTests
Tests run: 9, Failures: 0, Errors: 1, Time elapsed: 8.031 sec
Testcase: testSchoolsStartingWithALetterListCount(edu.columbia.law.admissions.domain.SystemDictionaryTests): Caused an ERROR
Parameter letter does not exist as a named parameter in [
from edu.columbia.law.admissions.domain.School s where s.schoolName like ':letter%'
]
java.lang.IllegalArgumentException: Parameter letter does not exist as a named parameter in [
from edu.columbia.law.admissions.domain.School s where s.schoolName like ':letter%'
]
at net.sf.hibernate.impl.AbstractQueryImpl.setParameter(AbstractQueryImpl.java:341)
at net.sf.hibernate.impl.AbstractQueryImpl.setParameter(AbstractQueryImpl.java:390)
at edu.columbia.law.admissions.impl.SystemDictionarySpringDAOImpl$7.doInHibernate(SystemDictionarySpringDAOImpl.java:218)
at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:150)
at org.springframework.orm.hibernate.HibernateTemplate.executeFind(HibernateTemplate.java:170)
at edu.columbia.law.admissions.impl.SystemDictionarySpringDAOImpl.listSchools(SystemDictionarySpringDAOImpl.java:212)
at edu.columbia.law.admissions.domain.SystemDictionaryTests.testSchoolsStartingWithALetterListCount(SystemDictionaryTests.java:100)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at org.apache.commons.jelly.tags.ant.AntTag.doTag(AntTag.java:232)
at org.apache.commons.jelly.impl.TagScript.run(TagScript.java:279)
at org.apache.commons.jelly.impl.ScriptBlock.run(ScriptBlock.java:135)
at org.apache.commons.jelly.TagSupport.invokeBody(TagSupport.java:233)
at org.apache.commons.jelly.tags.core.IfTag.doTag(IfTag.java:88)
at org.apache.commons.jelly.impl.TagScript.run(TagScript.java:279)
at org.apache.commons.jelly.impl.ScriptBlock.run(ScriptBlock.java:135)
at org.apache.maven.jelly.tags.werkz.MavenGoalTag.runBodyTag(MavenGoalTag.java:79)
at org.apache.maven.jelly.tags.werkz.MavenGoalTag$MavenGoalAction.performAction(MavenGoalTag.java:110)
at com.werken.werkz.Goal.fire(Goal.java:639)
at com.werken.werkz.Goal.attain(Goal.java:575)
at com.werken.werkz.WerkzProject.attainGoal(WerkzProject.java:193)
at org.apache.maven.plugin.PluginManager.attainGoals(PluginManager.java:616)
at org.apache.maven.MavenSession.attainGoals(MavenSession.java:266)
at org.apache.maven.cli.App.doMain(App.java:486)
at org.apache.maven.cli.App.main(App.java:1215)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at com.werken.forehead.Forehead.run(Forehead.java:551)
at com.werken.forehead.Forehead.main(Forehead.java:581)
Are there any alternatives if the above is not possible?
Thanks for your help.