jpa 原生查询createNativeQuery里面有冒号保留字关键字的问题
用\\:替换。
比如:
String sql = "select location.ToString() a,version,location.STDistance(geometry\\:\\:STGeomFromText('POINT(-22 60)', 4326)) b from spatial_event";
Query query = em.createNativeQuery(sql);
query.getResultList();
Encountered a duplicated sql alias [] during auto-discovery of a native-sql query:
这是由于select字段没有指定别名,加个别名就行。
ref link: https://blog.csdn.net/weixin_33825683/article/details/86020417
Space is not allowed after parameter prefix ':'
问题:在hibernate中执行mysql语句,如果mysql语句中含有@a := 1 之类的变量,回报这个错误
语句类似于“set @r