Question

请问org.springframework.jdbc.UncategorizedSQLException:是什么异常

msg: org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not execute query; uncategorized SQLException for SQL [select fancyaccou0_.Account_No as Account1_3_, fancyaccou0_.createDate as createDate3_, fancyaccou0_.balance as balance3_, fancyaccou0_.Bank_Code as Bank4_3_, fancyaccou0_.Customer_ID as Customer5_3_ from fancy_account fancyaccou0_]; SQL state [S1000]; error code [0]; Unknown type '246 in column 2 of 5 in binary-encoded result set.; nested exception is java.sql.SQLException: Unknown type '246 in column 2 of 5 in binary-encoded result set.
StackTrace:
org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:120)
org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:276)
org.springframework.orm.hibernate3.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:424)
org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:410)
org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:374)
org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:837)
org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:829)
com.fancybank.atm.dao.AccountHibernateDaoImpl.listAll(AccountHibernateDaoImpl.java:25)
com.fancybank.atm.service.AccountServiceImpl.listAll(AccountServiceImpl.java:27)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:597)
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:197)
$Proxy2.listAll(Unknown Source)
com.fancybank.atm.web.action.AccountMaintainAction.list(AccountMaintainAction.java:40)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:597)
org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:270)
org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:187)
com.fancybank.atm.web.action.BaseDispatchAction.execute(BaseDispatchAction.java:77)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
Cause:
java.sql.SQLException: Unknown type '246 in column 2 of 5 in binary-encoded result set.

Answer 1

SQL 查询语句异常，可能是你的查询语句写错了，或都你的映射的类和数据中的表不对应，检查你的映射配置文件。
看异常信息，你持久层应该用的是Hibernate 检查一下你的hibernate 映射配置文件，或你的HQL语句。