ERROR:ORA-30076: 对析出来源无效的析出字段

最新推荐文章于 2021-04-10 15:59:15 发布

转载最新推荐文章于 2021-04-10 15:59:15 发布 · 1.2k 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/Jeely/p/11200089.html

文章标签：

#数据库

本文探讨了使用Hibernate进行SQL查询的具体实现方式，包括参数设置和缓存使用情况。通过一个具体的例子展示了如何进行时间范围内的用户计数查询，并记录了查询是否命中缓存的信息。

DEBUG:key: sql: select count(*) as col_0_0_ from jc_user cmsuser0_ where 1=1 and cmsuser0_.register_time>=? and cmsuser0_.register_time<? and cmsuser0_.is_admin=0; parameters: ; named parameters: {end=Wed Jul 17 11:28:14 CST 2019, begin=Wed Jul 17 00:00:00 CST 2019}; transformer: org.hibernate.transform.CacheableResultTransformer@110f2
2019-07-17 11:28:14 上午 [Thread: http-8080-5][ Class:org.hibernate.cache.ehcache.internal.regions.EhcacheGeneralDataRegion Method: org.hibernate.cache.ehcache.internal.regions.EhcacheGeneralDataRegion.get(EhcacheGeneralDataRegion.java:81) ]
DEBUG:Element for key sql: select count(*) as col_0_0_ from jc_user cmsuser0_ where 1=1 and cmsuser0_.register_time>=? and cmsuser0_.register_time<? and cmsuser0_.is_admin=0; parameters: ; named parameters: {end=Wed Jul 17 11:28:14 CST 2019, begin=Wed Jul 17 00:00:00 CST 2019}; transformer: org.hibernate.transform.CacheableResultTransformer@110f2 is null
2019-07-17 11:28:14 上午 [Thread: http-8080-5][ Class:org.hibernate.cache.internal.StandardQueryCache Method: org.hibernate.cache.internal.StandardQueryCache.get(StandardQueryCache.java:174) ]
DEBUG:Query results were not found in cache

date改为timestamp(9)

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