SQL state [72000]; error code [12899]的错误

最新推荐文章于 2024-07-31 15:19:06 发布

原创最新推荐文章于 2024-07-31 15:19:06 发布 · 1.5w 阅读

4 ·

CC 4.0 BY-SA版权

文章标签：

#ORA-12899

异常处理专栏收录该内容

1 篇文章

订阅专栏

本文介绍了一个关于数据库字段长度不足导致ORA-12899错误的问题及解决方案，通过调整数据库表中字段的长度来解决该问题。

部署运行你感兴趣的模型镜像

调用系统：

org.springframework.orm.hibernate3.HibernateJdbcException: JDBC exception on Hibernate data access: SQLException for SQL [update MEMBER_ACCOUNT set VERSION=?, STATUS=?, REMARK=?, MODIFYTIME=?, MODIFYBY=? where MEMBERACCOUNTID=? and VERSION=?]; SQL state [72000]; error code [12899]; could not update: [cn.itour.remote.account.po.MemberAccount#1101011207518206886]
at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:627)
at org.springframework.orm.hibernate3.SpringSessionSynchronization.beforeCommit(SpringSessionSynchronization.java:143)
at org.springframework.transaction.support.TransactionSynchronizationUtils.triggerBeforeCommit(TransactionSynchronizationUtils.java:72)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.triggerBeforeCommit(AbstractPlatformTransactionManager.java:882)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:692)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:678)
at

org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:321)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:116)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)

（被调用系统）

Caused by: java.sql.SQLException: ORA-12899: value too large for column "ACCOUNT"."MEMBER_ACCOUNT"."MODIFYBY" (actual: 12, maximum: 10)

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:213)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:952)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1160)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3368)
at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2403)
... 65 more

ORA-12899一般表示实际字段值太大，而数据库字段不够导致的错误。

解决方法：

alter table member_account modify modifyby char(15);

您可能感兴趣的与本文相关的镜像