现象:
使用人大金仓数据库,查询遇到的问题
09:16:06.686 [http-nio-23456-exec-5] DEBUG c.c.h.c.L.selectUserByUsername - ==> Preparing: select loginName as username, password, id from c_user where loginName=?
09:16:06.687 [http-nio-23456-exec-5] DEBUG c.c.h.c.L.selectUserByUsername - ==> Parameters: beijing(String)
09:16:06.693 [http-nio-23456-exec-5] ERROR o.a.c.c.C.[.[.[.[dispatcherServlet] - Servlet.service() for servlet [dispatcherServlet] in context with path [/hfjs] threw exception
org.springframework.jdbc.UncategorizedSQLException:
Error querying database. Cause: com.kingbase8.util.KSQLException: ERROR: cache lookup failed for type 536871955
The error may exist in com/cait/hfjs/config/LoginUserDao.java (best guess)
The error may involve com.cait.hfjs.config.LoginUserDao.selectUserByUsername-Inline
The error occurred while setting parameters
SQL: select loginName as username, password, id from c_user where loginName=?
Cause: com.kingbase8.util.KSQLException: ERROR: cache lookup failed for type 536871955
; uncategorized SQLException; SQL state [XX000]; error code [0]; ERROR: cache lookup failed for type 536871955; nested exception is com.kingbase8.util.KSQLException: ERROR: cache lookup failed for type 536871955
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:92)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441)
at com.sun.proxy.$Proxy83.selectOne(Unknown Source)
at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:160)
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:87)
at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:152)