Question

org.springframework.jdbc.UncategorizedSQLException: Hibernate flushing: could not update

[com.luke.spoa.model.SpCode#admin6]; uncategorized SQLException for SQL [update

SPOA.dbo.sp_code set role_id=?, sp_code_id=?, sp_code_pwd=?, sp_code_state=?,

sp_code_created=?, sp_code_datetime=? where sp_code=?]; SQL state [HY000]; error code [8102];

[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]无法更新标识列 'sp_code_id'。; nested

exception is java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]无法

更新标识列 'sp_code_id'。
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate

(AbstractFallbackSQLExceptionTranslator.java:83)

org.springframework.orm.hibernate3.HibernateTransactionManager.convertJdbcAccessException

(HibernateTransactionManager.java:750)

org.springframework.orm.hibernate3.HibernateTransactionManager.convertHibernateAccessException

(HibernateTransactionManager.java:736)
org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit

(HibernateTransactionManager.java:614)

org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit

(AbstractPlatformTransactionManager.java:732)
org.springframework.transaction.support.AbstractPlatformTransactionManager.commit

(AbstractPlatformTransactionManager.java:701)

org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterRetu

rning(TransactionAspectSupport.java:321)
org.springframework.transaction.interceptor.TransactionInterceptor.invoke

(TransactionInterceptor.java:116)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed

(ReflectiveMethodInvocation.java:171)
org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke

(ExposeInvocationInterceptor.java:89)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed

(ReflectiveMethodInvocation.java:171)
org.springframework.aop.framework.JdkDynamicAopProxy.invoke

(JdkDynamicAopProxy.java:204)
$Proxy3.updateSpCode(Unknown Source)
com.luke.spoa.action.BasesInfoAction.exit(BasesInfoAction.java:188)
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)
com.opensymphony.xwork2.DefaultActionInvocation.invokeAction

(DefaultActionInvocation.java:441)
com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly

(DefaultActionInvocation.java:280)
com.opensymphony.xwork2.DefaultActionInvocation.invoke

Answer 1

SQL 语句异常，可能是你的语句写错了，或你的映射的类和数据中的表不对应，检查你的映射配置文件。

追问

映射配置文件我用MyEclipse生成的也不行啊。

追答

你再好好检查一下。