sql server - SQL queries do not currently support returning aliases -
sql server - SQL queries do not currently support returning aliases -
i have raw sql trying run on grails
final session = sessionfactory.currentsession; final string query = 'select count(a.*) artifact left bring together classification c on (a.id=c.artifact_id) c.id null or c.active=0'; final sqlquery = session.createsqlquery(query); def totalunclass = sqlquery.with { addentity(artifact); }
but getting error message: sql queries not back upwards returning aliases
tried method failed there accomplish result click here
try changing query line this
final string query = 'select count(*) artifact left bring together classification c on (a.id=c.artifact_id) c.id null or c.active=0';
sql-server oracle hibernate grails hql
Comments
Post a Comment