Bom dia
Procurei em vários lugares a solução para este problema porém não encontrei.
Estou usando o TopLink da IBM e o DB2 como banco .
Segue abaixo o log
14:00:08,030 INFO LazBuilderReportAuto:160 - 22170 - 63088
14:00:08,146 ERROR JobInterceptor:119 - ERRO: LOCAL EXCEPTION STACK:
EXCEPTION [TOPLINK-4002] (TopLink - 9.0.3 (Build 423)): oracle.toplink.exceptions.DatabaseException
EXCEPTION DESCRIPTION: com.ibm.db2.jcc.am.SqlException: [jcc][1037][12546][3.64.106] Ocorreu uma exceção durante a conversão de clob. Consulte o Throwable anexado para obter detalhes. ERRORCODE=-4220, SQLSTATE=null
INTERNAL EXCEPTION: com.ibm.db2.jcc.am.SqlException: [jcc][1037][12546][3.64.106] Ocorreu uma exceção durante a conversão de clob. Consulte o Throwable anexado para obter detalhes. ERRORCODE=-4220, SQLSTATE=null
ERROR CODE: -4220
at oracle.toplink.exceptions.DatabaseException.sqlException(Unknown Source)
at oracle.toplink.internal.databaseaccess.DatabaseAccessor.getObject(Unknown Source)
at oracle.toplink.internal.databaseaccess.DatabaseAccessor.fetchRow(Unknown Source)
at oracle.toplink.internal.databaseaccess.DatabaseAccessor.executeCall(Unknown Source)
at oracle.toplink.publicinterface.Session.executeCall(Unknown Source)
at oracle.toplink.internal.queryframework.CallQueryMechanism.executeCall(Unknown Source)
at oracle.toplink.internal.queryframework.CallQueryMechanism.executeCall(Unknown Source)
at oracle.toplink.internal.queryframework.CallQueryMechanism.executeSelectCall(Unknown Source)
at oracle.toplink.internal.queryframework.CallQueryMechanism.selectAllRows(Unknown Source)
at oracle.toplink.internal.queryframework.ExpressionQueryMechanism.selectAllRowsFromTable(Unknown Source)
at oracle.toplink.internal.queryframework.ExpressionQueryMechanism.selectAllRows(Unknown Source)
at oracle.toplink.queryframework.ReadAllQuery.execute(Unknown Source)
at oracle.toplink.queryframework.DatabaseQuery.execute(Unknown Source)
at oracle.toplink.queryframework.ReadQuery.execute(Unknown Source)
at oracle.toplink.publicinterface.Session.internalExecuteQuery(Unknown Source)
at oracle.toplink.publicinterface.Session.executeQuery(Unknown Source)
at oracle.toplink.publicinterface.Session.executeQuery(Unknown Source)
at oracle.toplink.publicinterface.Session.readAllObjects(Unknown Source)
at chubb.lazuw.dao.clientworkfolder.proposal.LazInsurableCoverageDao.getInsurableCoverageByCoverageId(LazInsurableCoverageDao.java:21)
at chubb.lazuw.tempo.assist.impli.LazBuilderReportAuto.populateBasicInformation(LazBuilderReportAuto.java:191)
at chubb.lazuw.tempo.assist.impli.LazBuilderReportAuto.generateRecordPolicy(LazBuilderReportAuto.java:163)
at chubb.lazuw.tempo.assist.impli.LazBuilderReportAuto.execute(LazBuilderReportAuto.java:60)
at com.chubb.job.lazuw.TempoAssistJob.execute(TempoAssistJob.java:49)
at com.chubb.job.lazuw.TempoAssistJob$$FastClassByCGLIB$$4597e47c.invoke()
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:191)
at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:689)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:622)
at com.chubb.job.lazuw.TempoAssistJob$$EnhancerByCGLIB$$3cf598ec.execute()
at com.chubb.job.quartz.job.impl.JobInterceptor.executeInternal(JobInterceptor.java:110)
at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:111)
at org.quartz.core.JobRunShell.run(JobRunShell.java:213)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:557)
INTERNAL EXCEPTION STACK:
com.ibm.db2.jcc.am.SqlException: [jcc][1037][12546][3.64.106] Ocorreu uma exceção durante a conversão de clob. Consulte o Throwable anexado para obter detalhes. ERRORCODE=-4220, SQLSTATE=null
at com.ibm.db2.jcc.am.bd.a(bd.java:663)
at com.ibm.db2.jcc.am.bd.a(bd.java:60)
at com.ibm.db2.jcc.am.bd.a(bd.java:85)
at <a href="http://com.ibm.db2.jcc.am.je">com.ibm.db2.jcc.am.je</a>.(je.java:112)
at com.ibm.db2.jcc.t4.c.b(c.java:1728)
at com.ibm.db2.jcc.am.fc.a(fc.java:994)
at com.ibm.db2.jcc.am.fc.X(fc.java:2718)
at com.ibm.db2.jcc.am.ResultSet.getObjectX(ResultSet.java:1438)
at com.ibm.db2.jcc.am.ResultSet.getObject(ResultSet.java:1413)
at oracle.toplink.internal.databaseaccess.DatabaseAccessor.getObject(Unknown Source)
at oracle.toplink.internal.databaseaccess.DatabaseAccessor.fetchRow(Unknown Source)
at oracle.toplink.internal.databaseaccess.DatabaseAccessor.executeCall(Unknown Source)
at oracle.toplink.publicinterface.Session.executeCall(Unknown Source)
at oracle.toplink.internal.queryframework.CallQueryMechanism.executeCall(Unknown Source)
at oracle.toplink.internal.queryframework.CallQueryMechanism.executeCall(Unknown Source)
at oracle.toplink.internal.queryframework.CallQueryMechanism.executeSelectCall(Unknown Source)
at oracle.toplink.internal.queryframework.CallQueryMechanism.selectAllRows(Unknown Source)
at oracle.toplink.internal.queryframework.ExpressionQueryMechanism.selectAllRowsFromTable(Unknown Source)
at oracle.toplink.internal.queryframework.ExpressionQueryMechanism.selectAllRows(Unknown Source)
at oracle.toplink.queryframework.ReadAllQuery.execute(Unknown Source)
at oracle.toplink.queryframework.DatabaseQuery.execute(Unknown Source)
at oracle.toplink.queryframework.ReadQuery.execute(Unknown Source)
at oracle.toplink.publicinterface.Session.internalExecuteQuery(Unknown Source)
at oracle.toplink.publicinterface.Session.executeQuery(Unknown Source)
at oracle.toplink.publicinterface.Session.executeQuery(Unknown Source)
at oracle.toplink.publicinterface.Session.readAllObjects(Unknown Source)
at chubb.lazuw.dao.clientworkfolder.proposal.LazInsurableCoverageDao.getInsurableCoverageByCoverageId(LazInsurableCoverageDao.java:21)
at chubb.lazuw.tempo.assist.impli.LazBuilderReportAuto.populateBasicInformation(LazBuilderReportAuto.java:191)
at chubb.lazuw.tempo.assist.impli.LazBuilderReportAuto.generateRecordPolicy(LazBuilderReportAuto.java:163)
at chubb.lazuw.tempo.assist.impli.LazBuilderReportAuto.execute(LazBuilderReportAuto.java:60)
at com.chubb.job.lazuw.TempoAssistJob.execute(TempoAssistJob.java:49)
at com.chubb.job.lazuw.TempoAssistJob$$FastClassByCGLIB$$4597e47c.invoke()
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:191)
at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:689)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:622)
at com.chubb.job.lazuw.TempoAssistJob$$EnhancerByCGLIB$$3cf598ec.execute()
at com.chubb.job.quartz.job.impl.JobInterceptor.executeInternal(JobInterceptor.java:110)
at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:111)
at org.quartz.core.JobRunShell.run(JobRunShell.java:213)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:557)
Caused by: java.nio.BufferOverflowException
at com.ibm.db2.jcc.am.r.a(r.java:24)
at <a href="http://com.ibm.db2.jcc.am.je">com.ibm.db2.jcc.am.je</a>.(je.java:104)
… 39 more
Caused by: sun.io.ConversionBufferFullException
at sun.io.ByteToCharSingleByte.convert(ByteToCharSingleByte.java:93)
at com.ibm.db2.jcc.am.r.a(r.java:16)
… 40 more
14:00:12,458 INFO LazTriggerListener:57 - Job GeraArquivosTempoAssist finalizado.
14:00:12,459 INFO LazTriggerListener:58 - Tempo total de excecução: 3760.493 segundos.