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

Popular posts from this blog

formatting - SAS SQL Datepart function returning odd values -

c++ - Apple Mach-O Linker Error(Duplicate Symbols For Architecture armv7) -

php - Yii 2: Unable to find a class into the extension 'yii2-admin' -