免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
最近访问板块 发新帖
查看: 2784 | 回复: 0
打印 上一主题 下一主题

[WebLogic] weblogic9.2发布应用程序,出现“ORA-01401: 插入的值对于列过大”错误,为什么? [复制链接]

论坛徽章:
0
跳转到指定楼层
1 [收藏(0)] [报告]
发表于 2009-06-01 14:12 |只看该作者 |倒序浏览
同样的程序(基于jdk1.5),连的同一个数据库(版本9i),用tomcat发布毫无问题,但一换到weblogic就出来这个错误,百思不得其解,请教各位高手,这是啥问题,如何解决?

weblogic错误信息:
        */ insert
        into
            CORE_LOGININFO
            (USERID, USERNAME, LOGINTIME, LOGINIP, LOPINSTATION, LOGENVINFO, LOG
OUTTIME, SESSIONID, LOGINID)
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?)
2009-05-29 20:37:44,171 WARN [org.hibernate.util.JDBCExceptionReporter] - SQL Er
ror: 1401, SQLState: 23000
2009-05-29 20:37:44,187 ERROR [org.hibernate.util.JDBCExceptionReporter] - ORA-0
1401: 插入的值对于列过大

2009-05-29 20:37:44,187 WARN [org.hibernate.util.JDBCExceptionReporter] - SQL Er
ror: 1401, SQLState: 23000
2009-05-29 20:37:44,187 ERROR [org.hibernate.util.JDBCExceptionReporter] - ORA-0
1401: 插入的值对于列过大

2009-05-29 20:37:44,203 ERROR [org.hibernate.event.def.AbstractFlushingEventList
ener] - Could not synchronize database state with session
org.hibernate.exception.ConstraintViolationException: Could not execute JDBC bat
ch update
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j
ava:71)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp
er.java:43)
        at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:
249)
        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:235)

        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:139)

        at org.hibernate.event.def.AbstractFlushingEventListener.performExecutio
ns(AbstractFlushingEventListener.java:29
        at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlus
hEventListener.java:27)
        at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
        at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:33
        at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java
:106)
        at org.springframework.orm.hibernate3.HibernateTransactionManager.doComm
it(HibernateTransactionManager.java:559)
        at org.springframework.transaction.support.AbstractPlatformTransactionMa
nager.processCommit(AbstractPlatformTransactionManager.java:611)
        at org.springframework.transaction.support.AbstractPlatformTransactionMa
nager.commit(AbstractPlatformTransactionManager.java:581)
        at org.springframework.transaction.interceptor.TransactionAspectSupport.
commitTransactionAfterReturning(TransactionAspectSupport.java:307)
        at org.springframework.transaction.interceptor.TransactionInterceptor.in
voke(TransactionInterceptor.java:117)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:176)
        at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterc
eptor.intercept(Cglib2AopProxy.java:652)
        at com.mip.core.security.service.logic.FiterLogActionManager$$EnhancerBy
CGLIB$$936bbe45.setLog(<generated>
        at com.mip.core.security.service.filter.UserAuthenticationProcessingFilt
er.requiresAuthentication(UserAuthenticationProcessingFilter.java:155)
        at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProces
singFilter.java:189)
        at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(F
ilterChainProxy.java:274)
        at com.mip.core.security.service.filter.SSOProcessingFilter.doFilter(SSO
ProcessingFilter.java:176)
        at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(F
ilterChainProxy.java:274)
        at org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:1
0
        at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(F
ilterChainProxy.java:274)
        at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilte
r(HttpSessionContextIntegrationFilter.java:195)
        at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(F
ilterChainProxy.java:274)
        at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.jav
a:14
        at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.j
ava:90)
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.ja
va:42)
        at org.springframework.web.filter.CharacterEncodingFilter.doFilterIntern
al(CharacterEncodingFilter.java:7
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerR
equestFilter.java:77)
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.ja
va:42)
        at weblogic.servlet.internal.WebAppServletContext$ServletInvocationActio
n.run(WebAppServletContext.java:3212)
        at weblogic.security.acl.internal.AuthenticatedSubject.doAs(Authenticate
dSubject.java:321)
        at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:
121)
        at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppS
ervletContext.java:1983)
        at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletC
ontext.java:1890)
        at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.j
ava:1344)
        at weblogic.work.ExecuteThread.execute(ExecuteThread.java:209)
        at weblogic.work.ExecuteThread.run(ExecuteThread.java:181)
Caused by: java.sql.BatchUpdateException: ORA-01401: 插入的值对于列过大

        at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseEr
ror.java:343)
        at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePrepare
dStatement.java:1069
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:
100)
        at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.ja
va:57)
        at oracle.jdbc.internal.OraclePreparedStatement$$EnhancerByProxool$$e906
20c8.executeBatch(<generated>
        at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.jav
a:4
        at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:
242)
        ... 38 more
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP