i have a DTO class with the following constructor:
Code:
public void ListingItem(String tradename,String strength, String unit )
{
this.tradeName = tradename;
this.strength = strength;
this.unit = unit;
}
I have the following named query in my Listings class:
Code:
@NamedQuery(name = "findDistinctStrengthUnitTradeNameListingsByStrengthContaining", query = "select distinct new com.medtimetable.domain.ListingItem(myListings.tradename, myListings.strength, myListings.unit) from Listings myListings where myListings.tradename like ?1")
The relevant fields in the Listings class are defined as follow:
Code:
@Column(name = "STRENGTH", length = 10)
@Basic(fetch = FetchType.EAGER)
@XmlElement
String strength;
/**
*/
@Column(name = "UNIT", length = 10)
@Basic(fetch = FetchType.EAGER)
@XmlElement
String unit;
/**
*/
@Column(name = "TRADENAME", length = 100)
@Basic(fetch = FetchType.EAGER)
@XmlElement
String tradename;
I am getting the following exception:
Quote:
ErrorCounter - Unable to locate appropriate constructor on class [com.medtimetable.domain.ListingItem]
[cause=org.hibernate.PropertyNotFoundException: no appropriate constructor in class: com.medtimetable.domain.ListingItem]
2010-09-28 17:39:14,506 ERROR [main] SessionFactoryImpl - Error in named query: findDistinctStrengthUnitTradeNameListingsByStrengthContaining
org.hibernate.hql.ast.QuerySyntaxException: Unable to locate appropriate constructor on class [com.medtimetable.domain.ListingItem] [select distinct new com.medtimetable.domain.ListingItem(myListings.tradename, myListings.strength, myListings.unit) from com.medtimetable.domain.Listings myListings where myListings.tradename like ?1]
at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:31)
at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:24)
at org.hibernate.hql.ast.ErrorCounter.throwQueryException(ErrorCounter.java:59)
at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:238)
at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:162)
at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:113)
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:77)
HELP!!!!!!!!!! :)
Thanks,
Shy Kraus