java.sql.SQLSyntaxErrorException: ORA-00923: 未找到要求的 FROM 关键字

NFO:HibernateSimpleDao----queryForListWithSql:SELECT site_id as id ,
MAX(case attr_name when 'siteName' then attr_value END) as 'siteName',
MAX(case attr_name when 'userName' then attr_value END) as 'userName',
MAX(case attr_name when 'password' then attr_value END) as 'password',
MAX(case attr_name when 'tjSiteId' then attr_value END) as 'tjSiteId',
MAX(case attr_name when 'tjToken' then attr_value END) as 'tjToken'
FROM jc_site_attr where attr_name in ('siteName','userName','password','tjToken','tjSiteId') GROUP BY site_id ORDER BY site_id
2019-07-17 10:53:02 上午 [Thread: http-8080-1][ Class:com.mchange.v2.c3p0.impl.NewPooledConnection Method: com.mchange.v2.log.slf4j.Slf4jMLog$Slf4jMLogger$DebugLogger.log(Slf4jMLog.java:207) ]
DEBUG:com.mchange.v2.c3p0.impl.NewPooledConnection@2f9923 handling a throwable.
java.sql.SQLSyntaxErrorException: ORA-00923: 未找到要求的 FROM 关键字

 

SELECT site_id as id ,MAX(case attr_name when 'siteName' then attr_value END) as siteName,
MAX(case attr_name when 'userName' then attr_value END) as userName,
MAX(case attr_name when 'password' then attr_value END) as password,
MAX(case attr_name when 'tjSiteId' then attr_value END) as tjSiteId,
MAX(case attr_name when 'tjToken' then attr_value END) as tjToken FROM jc_site_attr
where attr_name in ('siteName','userName','password','tjToken','tjSiteId')
GROUP BY site_id ORDER BY site_id

转载于:https://www.cnblogs.com/Jeely/p/11199620.html