Env:
Oracle Database 10g Release 10.2.0.4.0 - Production
WebLogic Platform 8.1.4.0
JDK 1.4.2_05-b04
Oracle Thin Driver
####<Sep 28, 2010 11:20:50 AM CST> <Info> <EJB> <ydctest03> <myserver> <mediumJobProcessor1-0> <wlsadmin> <BEA1-6AAEA53E9B09B9D9E7B4> <BEA-010049> <EJB Exception in method: ejbFindMvLogByOwnerListForGML: javax.ejb.EJBException: nested exception is: java.sql.SQLException: Data size bigger than max size for this type: 4119.
javax.ejb.EJBException: nested exception is: java.sql.SQLException: Data size bigger than max size for this type: 4119
java.sql.SQLException: Data size bigger than max size for this type: 4119
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.ttc7.TTCItem.setArrayData(TTCItem.java:155)
at oracle.jdbc.dbaccess.DBDataSetImpl.setBytesBindItem(DBDataSetImpl.java:2531)
at oracle.jdbc.driver.OraclePreparedStatement.setItem(OraclePreparedStatement.java:1243)
at oracle.jdbc.driver.OraclePreparedStatement.setString(OraclePreparedStatement.java:1685)
at weblogic.jdbc.wrapper.PreparedStatement.setString(PreparedStatement.java:638)
at xxx.xxx.ioc.model.beans.LineMovementLogBeanImpl.ejbFindMvLogByOwnerListForGML(LineMovementLogBeanImpl.java:7424)
at xxx.xxx.ioc.model.beans.myLineMovementLog_vktap0_Impl.ejbFindMvLogByOwnerListForGML(myLineMovementLog_vktap0_Impl.java:355)
at sun.reflect.GeneratedMethodAccessor87.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at weblogic.ejb20.manager.BeanManagedPersistenceManager.collectionFinder(BeanManagedPersistenceManager.java:152)
at weblogic.ejb20.manager.BaseEntityManager.collectionFinder(BaseEntityManager.java:1784)
at weblogic.ejb20.manager.BaseEntityManager.collectionFinder(BaseEntityManager.java:1756)
at weblogic.ejb20.internal.EntityEJBHome.finder(EntityEJBHome.java:648)
at xxx.xxx.ioc.model.beans.myLineMovementLog_vktap0_HomeImpl.findMvLogByOwnerListForGML(myLineMovementLog_vktap0_HomeImpl.java:500)
at xxx.xxx.ioc.model.booking.beans.DownloadEDILineMvLogInterfaceProcessBean.sendDtlLineMoveLog(DownloadEDILineMvLogInterfaceProcessBean.java:425)
at xxx.xxx.ioc.model.booking.beans.DownloadEDILineMvLogInterfaceProcessBean.sendLineMvLogForGroupType(DownloadEDILineMvLogInterfaceProcessBean.java:563)
at xxx.xxx.ioc.model.booking.beans.DownloadEDILineMvLogInterfaceProcessBeanImpl_ngflhq_EOImpl.sendLineMvLogForGroupType(DownloadEDILineMvLogInterfaceProcessBeanImpl_ngflhq_EOImpl.java:104)
at xxx.xxx.ioc.model.booking.DownloadEDILineMvLogInterfaceProcessCommand$SendLineMvLogForGroupType.execute(DownloadEDILineMvLogInterfaceProcessCommand.java:316)
at xxx.xxx.rose.ejb.beans.CommandExecutorBean.executeCommand(CommandExecutorBean.java:420)
at xxx.xxx.rose.ejb.beans.myCommandExecutor_wisgn8_EOImpl.executeCommand(myCommandExecutor_wisgn8_EOImpl.java:46)
at xxx.xxx.rose.ejb.dispatchers.ServerCommandDispatcher.executeCommandInternal(ServerCommandDispatcher.java:123)
at xxx.xxx.rose.ejb.dispatchers.AbstractCommandDispatcher.executeCommand(AbstractCommandDispatcher.java:113)
at xxx.xxx.rose.ejb.dispatchers.AbstractCommandDispatcher.executeCommand(AbstractCommandDispatcher.java:71)
at xxx.xxx.ioc.model.booking.DownloadEDILineMvLogInterfaceProcessCommand$SendLineMvLogForGroupType.execute(DownloadEDILineMvLogInterfaceProcessCommand.java:328)
at xxx.xxx.ioc.model.booking.DownloadEDILineMvLogInterfaceProcessCommand$SendLineMvLogForGroupType.execute(DownloadEDILineMvLogInterfaceProcessCommand.java:346)
at xxx.xxx.ioc.model.booking.beans.DownloadEDILineMvLogInterfaceProcessBean.downloadEDILineMovementLog(DownloadEDILineMvLogInterfaceProcessBean.java:265)
at xxx.xxx.ioc.model.booking.beans.DownloadEDILineMvLogInterfaceProcessBeanImpl_ngflhq_EOImpl.downloadEDILineMovementLog(DownloadEDILineMvLogInterfaceProcessBeanImpl_ngflhq_EOImpl.java:46)
at xxx.xxx.ioc.model.booking.DownloadEDILineMvLogInterfaceProcessCommand$DownloadEDILineMovementLog.execute(DownloadEDILineMvLogInterfaceProcessCommand.java:162)
at xxx.xxx.rose.ejb.beans.CommandExecutorBean.executeCommand(CommandExecutorBean.java:420)
at xxx.xxx.rose.ejb.beans.myCommandExecutor_wisgn8_EOImpl.executeCommand(myCommandExecutor_wisgn8_EOImpl.java:46)
at xxx.xxx.rose.job.AbstractJobProcessor$Dispatcher.executeCommandInternal(AbstractJobProcessor.java:470)
at xxx.xxx.rose.ejb.dispatchers.AbstractCommandDispatcher.executeCommand(AbstractCommandDispatcher.java:113)
at xxx.xxx.rose.ejb.dispatchers.AbstractCommandDispatcher.executeCommand(AbstractCommandDispatcher.java:71)
at xxx.xxx.ioc.model.booking.DownloadEDILineMvLogInterfaceProcessCommand$DownloadEDILineMovementLog.execute(DownloadEDILineMvLogInterfaceProcessCommand.java:174)
at xxx.xxx.ioc.model.booking.DownloadEDILineMvLogInterfaceProcessCommand$DownloadEDILineMovementLog.execute(DownloadEDILineMvLogInterfaceProcessCommand.java:192)
at xxx.xxx.ioc.jobs.DownloadEDILineMvLogJobActionHandler.onAction(DownloadEDILineMvLogJobActionHandler.java:22)
at xxx.xxx.rose.job.AbstractJobProcessor.processRequest(AbstractJobProcessor.java:344)
at xxx.xxx.rose.job.AbstractJobProcessor.run(AbstractJobProcessor.java:249)
at java.lang.Thread.run(Thread.java:534)
当PreparedStatement中的参数遇到大字符串
http://www.360doc.com/content/10/0602/13/11586_30848384.shtml
note:if you're using JDK 1.4 or later then you should reference 'odjbc14.jar' and not 'classes12.zip'.
