Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » EclipseLink » [SOLVED] - Impossible to store Large CLOBS with Oracle11Platform and Oracle 11g(ORA-06502: PL/SQL: numeric or value error: character string buffer too small)
icon14.gif  [SOLVED] - Impossible to store Large CLOBS with Oracle11Platform and Oracle 11g [message #1758349] Tue, 28 March 2017 01:00 Go to next message
Eduardo Frazão is currently offline Eduardo FrazãoFriend
Messages: 123
Registered: January 2012
Senior Member

Problem solved folks. Its not a Eclipselink related problem. In fact, the problem was related to a FunctionBased index that was causing problems with this CLOB column Specifically.



---------- Original post
I'm trying to store a CLOB with aproximatelly 95KB, but Oracle raises this error

ORA-06502: PL/SQL: numeric or value error: character string buffer too small


Logging reports that Eclipselink bounds the Insert parameters as a regular.

This is my entity config:

@Entity
@Table(name="CAMPO_FORMULARIO", uniqueConstraints={@UniqueConstraint(columnNames={"CAMPO_ID", "FORMULARIO_FK"})})
@Converter(name=DomainEnumConverter.NAME, converterClass=DomainEnumConverter.class)
@IdClass(CampoFormularioPK.class)
@SequenceGenerator(name="CAMPO_FORMULARIO_SEQ", sequenceName="CAMPO_FORMULARIO_SEQ", initialValue=1, allocationSize=1)
@Cacheable(false)
public class CampoFormulario extends AbstractEntity<CampoFormularioPK> {

	private static final long serialVersionUID = 1L;
	
	@Transient
	private CampoFormularioPK id;
	
	@Id
	@Column(name="CAMPO_ID", nullable=false)
	private String campoId;
	
	@Id
	@JoinColumn(name="FORMULARIO_FK", nullable=false)
	private Formulario form;
	
	@Column(name="TIPO_CAMPO", nullable=false)
	@Convert(DomainEnumConverter.NAME)
	private TipoCampo tipo;
	
	@Column(name="MULTI_VALOR", nullable=false)
	private boolean mutiValor;
	
	@Column(name="VALOR_INTEIRO")
	private Long longValue;
	
	@Column(name="VALOR_DECIMAL", length=16, precision=6)
	private Double doubleValue;
	
	@Column(name="VALOR_BOLEANO")
	private Boolean booleanValue;
	
	@Column(name="VALOR_DATAHORA")
	@Temporal(TemporalType.TIMESTAMP)
	private Date dateValue;
	
	@Column(name="VALOR_STRING")
	@Lob
	private String stringValue;
	
	@Column(name="CAPTION_STRING", length=512)
	private String captionValue;
	
	@OneToMany(fetch=FetchType.LAZY, cascade={CascadeType.MERGE, CascadeType.PERSIST, CascadeType.REMOVE}, mappedBy="campo", orphanRemoval=true)
	private List<ValorListaCampoFormulario> multiValues = new ArrayList<>();

	@Column(name="ELEVACAO")
	private boolean elevacao = false;
	
	@Column(name="ELEVACAO_LOGIN")
	private String elevacaoLogin;
	
	@PostLoad
	private void postLoad() {
		id = new CampoFormularioPK(campoId, getForm().getId());
	}

	@PrePersist
	@PreUpdate
	private void checkState() {
		if(isMutiValor()) {
			// limpando todos os fields locais
			setStringValue(null);
		}
	}


I'm using Eclipselink 2.6.4 and Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production

This is the stack trace:

Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.BatchUpdateException: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at line 1

Error Code: 6502
	at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:331)
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeJDK12BatchStatement(DatabaseAccessor.java:933)
	at org.eclipse.persistence.internal.databaseaccess.ParameterizedSQLBatchWritingMechanism.executeBatch(ParameterizedSQLBatchWritingMechanism.java:179)
	at org.eclipse.persistence.internal.databaseaccess.ParameterizedSQLBatchWritingMechanism.executeBatchedStatements(ParameterizedSQLBatchWritingMechanism.java:134)
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.writesCompleted(DatabaseAccessor.java:1845)
	at org.eclipse.persistence.internal.sessions.AbstractSession.writesCompleted(AbstractSession.java:4301)
	at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.writesCompleted(UnitOfWorkImpl.java:5592)
	at org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.writeChanges(RepeatableWriteUnitOfWork.java:456)
	at org.eclipse.persistence.internal.jpa.EntityManagerImpl.flush(EntityManagerImpl.java:874)
	... 110 more
Caused by: java.sql.BatchUpdateException: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at line 1

	at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10500)
	at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:230)
	at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.executeBatch(DelegatingStatement.java:348)
	at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.executeBatch(DelegatingStatement.java:348)
	at org.eclipse.persistence.platform.database.oracle.Oracle10Platform.executeBatch(Oracle10Platform.java:65)
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeJDK12BatchStatement(DatabaseAccessor.java:922)
	... 117 more

[Updated on: Wed, 29 March 2017 13:54]

Report message to a moderator

Re: Impossible to store Large CLOBS with Oracle11Platform and Oracle 11g [message #1758458 is a reply to message #1758349] Tue, 28 March 2017 20:24 Go to previous message
Eduardo Frazão is currently offline Eduardo FrazãoFriend
Messages: 123
Registered: January 2012
Senior Member
Folks, I've made more tests and appears that I can't persist anything with more than 3986 bytes in the Clob field.

This is the entire sql debug + stack trace:

[EL Fine]: sql: 2017-03-28 17:21:42.163--ClientSession(848331907)--Connection(770428516)--Thread(Thread[http-nio-7080-exec-2,5,main])--INSERT INTO CAMPO_FORMULARIO (CAMPO_ID, VALOR_BOLEANO, CAPTION_STRING, VALOR_DATAHORA, VALOR_DECIMAL, ELEVACAO, ELEVACAO_LOGIN, VALOR_INTEIRO, MULTI_VALOR, VALOR_STRING, TIPO_CAMPO, FORMULARIO_FK) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
[EL Fine]: sql: 2017-03-28 17:21:42.163--ClientSession(848331907)--Connection(770428516)--Thread(Thread[http-nio-7080-exec-2,5,main])--	bind => [descricaoAtividade, null, null, null, null, false, null, null, false, asdsa, 1, 14002]
[EL Fine]: sql: 2017-03-28 17:21:42.163--ClientSession(848331907)--Connection(770428516)--Thread(Thread[http-nio-7080-exec-2,5,main])--	bind => [dataLimite, null, null, 2017-04-04 23:59:59.0, null, false, null, null, false, null, 4, 14002]
[EL Fine]: sql: 2017-03-28 17:21:42.163--ClientSession(848331907)--Connection(770428516)--Thread(Thread[http-nio-7080-exec-2,5,main])--	bind => [responsavel, null, Cristiane Frazão, null, null, false, null, null, false, cristiane, 1, 14002]
[EL Fine]: sql: 2017-03-28 17:21:42.163--ClientSession(848331907)--Connection(770428516)--Thread(Thread[http-nio-7080-exec-2,5,main])--	bind => [status, null, Em andamento, null, null, false, null, null, false, 5, 1, 14002]
[EL Fine]: sql: 2017-03-28 17:21:42.164--ClientSession(848331907)--Connection(770428516)--Thread(Thread[http-nio-7080-exec-2,5,main])--	bind => [dataReplaneja, null, null, null, null, false, null, null, false, null, 4, 14002]
[EL Fine]: sql: 2017-03-28 17:21:42.164--ClientSession(848331907)--Connection(770428516)--Thread(Thread[http-nio-7080-exec-2,5,main])--	bind => [solicitante, null, Cristiane Frazão, null, null, false, null, null, false, cristiane, 1, 14002]
[EL Fine]: sql: 2017-03-28 17:21:42.164--ClientSession(848331907)--Connection(770428516)--Thread(Thread[http-nio-7080-exec-2,5,main])--	bind => [is_responsavel, null, null, null, null, false, null, null, false, null, 2, 14002]
[EL Fine]: sql: 2017-03-28 17:21:42.164--ClientSession(848331907)--Connection(770428516)--Thread(Thread[http-nio-7080-exec-2,5,main])--	bind => [is_solicitante, null, null, null, null, false, null, null, false, null, 2, 14002]
[EL Fine]: sql: 2017-03-28 17:21:42.164--ClientSession(848331907)--Connection(770428516)--Thread(Thread[http-nio-7080-exec-2,5,main])--	bind => [avaliacao, null, null, null, null, false, null, null, false, null, 5, 14002]
[EL Fine]: sql: 2017-03-28 17:21:42.164--ClientSession(848331907)--Connection(770428516)--Thread(Thread[http-nio-7080-exec-2,5,main])--	bind => [observacoes, null, null, null, null, false, null, null, false, Lorem ipsum dolor sit amet, consectetur adipiscing elit. Vestibulum semper sapien vitae lectus vehicula, vitae commodo nunc imperdiet. Nullam nisi eros, molestie fringilla imperdiet vitae, efficitur non mi. Vivamus imperdiet neque sit amet turpis efficitur dignissim. Fusce lacus nulla, sagittis ac ultrices et, tincidunt id purus. Aenean justo libero, condimentum vitae ante vitae, pellentesque accumsan dui. Curabitur vitae interdum sem, id tempus mauris. Duis gravida pulvinar consectetur. Vestibulum sagittis felis in erat efficitur viverra. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Sed eu metus sagittis, pharetra risus vitae, commodo arcu. Maecenas arcu odio, ullamcorper sed bibendum at, molestie nec velit. Suspendisse consectetur consectetur felis, ac semper justo dictum et.

Sed elementum magna sed ante congue, ac faucibus nibh cursus. Vestibulum eu malesuada eros. Orci varius natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Vivamus ac lobortis sem. Sed faucibus dolor leo. Integer suscipit magna sed est interdum congue. Aliquam finibus massa urna, quis lacinia diam vehicula ac. Aliquam dignissim diam imperdiet, sagittis sem quis, lacinia est.

Morbi sit amet elit lectus. Duis dignissim lacus sed velit commodo ornare. Sed posuere lacinia ligula vel mollis. Integer nisl lorem, accumsan sed turpis nec, congue ultrices est. Pellentesque et dictum erat. Vivamus ultricies euismod rhoncus. Quisque dignissim lectus a elementum vehicula. Vivamus feugiat sodales ornare.

Morbi sit amet dui pellentesque, faucibus ex sit amet, semper lectus. Phasellus fringilla libero vel magna finibus pretium. Maecenas feugiat ante eros, eget volutpat massa vehicula hendrerit. In quis elit augue. Curabitur mollis orci in nulla tincidunt porttitor. Nulla vehicula magna id justo consequat elementum. Quisque fringilla mi in sapien blandit pulvinar. Pellentesque ut enim quis lorem pharetra viverra sit amet id ante. In condimentum mi arcu, ut aliquam sem aliquet sit amet. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Morbi erat nibh, interdum eget risus in, tincidunt bibendum sem.

Donec eu tellus finibus, iaculis ipsum eget, dictum turpis. Nulla tincidunt, lectus a laoreet rutrum, ligula eros rutrum enim, non hendrerit nunc dui et nisi. Nam molestie id risus sed molestie. Nunc interdum mi sed pretium pharetra. Vestibulum rutrum vitae ligula quis rutrum. Cras ut laoreet lorem, vel lobortis arcu. Sed sagittis ornare metus id aliquet. Maecenas quis scelerisque tellus. Fusce sit amet nisi tincidunt, efficitur magna vel, egestas neque.

Aenean fringilla nibh tincidunt tincidunt iaculis. Nulla facilisi. Pellentesque imperdiet lacus vel lectus molestie fermentum. Ut rutrum, nunc eget tincidunt imperdiet, dolor mi bibendum ipsum, vel consequat felis turpis vitae felis. Morbi lectus libero, tincidunt non urna a, tincidunt rhoncus ante. Nullam commodo consectetur enim, vitae luctus justo ultricies sit amet. Suspendisse et tincidunt magna. Phasellus lacinia luctus rhoncus.

Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Donec nunc massa, scelerisque nec faucibus id, mattis vitae leo. Duis fermentum nibh augue, ac accumsan tortor accumsan eu. Ut a mollis metus. Aliquam gravida elit ac tortor accumsan vestibulum. Pellentesque molestie elit eget velit varius, eu tristique quam ullamcorper. Maecenas dignissim tristique tincidunt. Donec vel lacus in elit tempor luctus. Praesent tempus massa odio, quis ultricies tellus efficitur a.

Morbi aliquet risus vitae tempor faucibus. Curabitur ac leo quis orci volutpat pharetra in ac lectus. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Cras felis nisl, lobortis sit amet augue id, tempor laoreet tortor. Fusce in venenatis enim. Nulla vehicula cursus mauris, vitae interdum nulla tempor vitae. Vivamus eu libero in ex cras amet, 1, 14002]
[EL Fine]: sql: 2017-03-28 17:21:42.164--ClientSession(848331907)--Connection(770428516)--Thread(Thread[http-nio-7080-exec-2,5,main])--	bind => [marcador, null, Marcador 1, null, null, false, null, 4, false, null, 2, 14002]
[EL Fine]: sql: 2017-03-28 17:21:42.164--ClientSession(848331907)--Connection(770428516)--Thread(Thread[http-nio-7080-exec-2,5,main])--	bind => [AceitarReplaneja, null, null, null, null, false, null, null, false, null, 1, 14002]
[EL Fine]: sql: 2017-03-28 17:21:42.164--ClientSession(848331907)--Connection(770428516)--Thread(Thread[http-nio-7080-exec-2,5,main])--	bind => [prioridade, null, Baixa, null, null, false, null, null, false, 1, 1, 14002]
[EL Fine]: sql: 2017-03-28 17:21:42.229--ClientSession(848331907)--Thread(Thread[http-nio-7080-exec-2,5,main])--SELECT 1 FROM DUAL
Mar 28, 2017 5:21:42 PM br.com.davinti.vitruvio.ui.core.DefaultUIErrorHandler error
SEVERE: Erro imprevisto
com.vaadin.server.ServerRpcManager$RpcInvocationException: Unable to invoke method click in com.vaadin.shared.ui.button.ButtonServerRpc
	at com.vaadin.server.ServerRpcManager.applyInvocation(ServerRpcManager.java:162)
	at com.vaadin.server.ServerRpcManager.applyInvocation(ServerRpcManager.java:119)
	at com.vaadin.server.communication.ServerRpcHandler.handleInvocation(ServerRpcHandler.java:432)
	at com.vaadin.server.communication.ServerRpcHandler.handleInvocations(ServerRpcHandler.java:404)
	at com.vaadin.server.communication.ServerRpcHandler.handleRpc(ServerRpcHandler.java:273)
	at com.vaadin.server.communication.UidlRequestHandler.synchronizedHandleRequest(UidlRequestHandler.java:90)
	at com.vaadin.server.SynchronizedRequestHandler.handleRequest(SynchronizedRequestHandler.java:41)
	at com.vaadin.server.VaadinService.handleRequest(VaadinService.java:1422)
	at com.vaadin.server.VaadinServlet.service(VaadinServlet.java:379)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
	at br.com.davinti.vitruvio.server.CookieAuthFilter.doFilter(CookieAuthFilter.java:47)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
	at org.apache.catalina.core.StandardContextValve.__invoke(StandardContextValve.java:108)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:620)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:349)
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:783)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:789)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1455)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.reflect.InvocationTargetException
	at sun.reflect.GeneratedMethodAccessor1284.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.__invoke(DelegatingMethodAccessorImpl.java:43)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java)
	at java.lang.reflect.Method.invoke(Method.java:606)
	at com.vaadin.server.ServerRpcManager.applyInvocation(ServerRpcManager.java:158)
	... 34 more
Caused by: com.vaadin.event.ListenerMethod$MethodException: Invocation of method buttonClick in br.com.davinti.base.vaadin.components.layout.ConfirmationBox$ConfirmationDialogWindow$3 failed.
	at com.vaadin.event.ListenerMethod.receiveEvent(ListenerMethod.java:533)
	at com.vaadin.event.EventRouter.fireEvent(EventRouter.java:200)
	at com.vaadin.event.EventRouter.fireEvent(EventRouter.java:163)
	at com.vaadin.server.AbstractClientConnector.fireEvent(AbstractClientConnector.java:1015)
	at com.vaadin.ui.Button.fireClick(Button.java:377)
	at com.vaadin.ui.Button$1.click(Button.java:54)
	... 40 more
Caused by: org.springframework.orm.jpa.JpaSystemException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.BatchUpdateException: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at line 1

Error Code: 6502; nested exception is javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.BatchUpdateException: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at line 1

Error Code: 6502
	at org.springframework.orm.jpa.EntityManagerFactoryUtils.convertJpaAccessExceptionIfPossible(EntityManagerFactoryUtils.java:418)
	at org.springframework.orm.jpa.DefaultJpaDialect.translateExceptionIfPossible(DefaultJpaDialect.java:122)
	at org.springframework.dao.support.ChainedPersistenceExceptionTranslator.translateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:59)
	at org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:213)
	at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:147)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
	at com.sun.proxy.$Proxy60.getTotalMetricas(Unknown Source)
	at br.com.davinti.vitruvio.spi.impl.FormServiceImpl.extractMetricas(FormServiceImpl.java:1806)
	at br.com.davinti.vitruvio.spi.impl.FormServiceImpl.handleMetricas(FormServiceImpl.java:1798)
	at br.com.davinti.vitruvio.spi.impl.FormServiceImpl.storeStartForm(FormServiceImpl.java:1791)
	at br.com.davinti.vitruvio.spi.impl.FormServiceImpl.storeStartForm(FormServiceImpl.java:1771)
	at sun.reflect.GeneratedMethodAccessor1112.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java)
	at java.lang.reflect.Method.invoke(Method.java:606)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
	at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
	at com.sun.proxy.$Proxy47.storeStartForm(Unknown Source)
	at br.com.davinti.vitruvio.spi.impl.ProcessoInstanciaServiceImpl.create(ProcessoInstanciaServiceImpl.java:398)
	at br.com.davinti.vitruvio.spi.impl.ProcessoInstanciaServiceImpl.criarInstancia(ProcessoInstanciaServiceImpl.java:1182)
	at br.com.davinti.vitruvio.spi.impl.ProcessoInstanciaServiceImpl.criarInstancia(ProcessoInstanciaServiceImpl.java:1176)
	at sun.reflect.GeneratedMethodAccessor1105.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java)
	at java.lang.reflect.Method.invoke(Method.java:606)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
	at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
	at com.sun.proxy.$Proxy80.criarInstancia(Unknown Source)
	at br.com.davinti.vitruvio.ui.processo.StartProcessViewPresenter.createProcess(StartProcessViewPresenter.java:474)
	at br.com.davinti.vitruvio.ui.processo.StartProcessViewPresenter.startInstance(StartProcessViewPresenter.java:453)
	at br.com.davinti.vitruvio.ui.processo.StartProcessViewPresenter.access$14(StartProcessViewPresenter.java:452)
	at br.com.davinti.vitruvio.ui.processo.StartProcessViewPresenter$12.dialogEnd(StartProcessViewPresenter.java:411)
	at br.com.davinti.base.vaadin.components.layout.ConfirmationBox$ConfirmationDialogWindow.confirmBoxWithYES(ConfirmationBox.java:530)
	at br.com.davinti.base.vaadin.components.layout.ConfirmationBox$ConfirmationDialogWindow.access$5(ConfirmationBox.java:527)
	at br.com.davinti.base.vaadin.components.layout.ConfirmationBox$ConfirmationDialogWindow$3.buttonClick(ConfirmationBox.java:469)
	at sun.reflect.GeneratedMethodAccessor1263.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.__invoke(DelegatingMethodAccessorImpl.java:43)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java)
	at java.lang.reflect.Method.invoke(Method.java:606)
	at com.vaadin.event.ListenerMethod.receiveEvent(ListenerMethod.java:510)
	... 45 more
Caused by: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.BatchUpdateException: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at line 1

Error Code: 6502
	at org.eclipse.persistence.internal.jpa.EntityManagerImpl.flush(EntityManagerImpl.java:879)
	at org.eclipse.persistence.internal.jpa.QueryImpl.performPreQueryFlush(QueryImpl.java:967)
	at org.eclipse.persistence.internal.jpa.QueryImpl.executeReadQuery(QueryImpl.java:207)
	at org.eclipse.persistence.internal.jpa.QueryImpl.getSingleResult(QueryImpl.java:521)
	at org.eclipse.persistence.internal.jpa.EJBQueryImpl.getSingleResult(EJBQueryImpl.java:400)
	at br.com.davinti.vitruvio.domain.dao.instancia.FormularioDaoImpl.getTotalMetricas(FormularioDaoImpl.java:225)
	at sun.reflect.GeneratedMethodAccessor1119.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java)
	at java.lang.reflect.Method.invoke(Method.java:606)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
	at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:136)
	... 96 more
Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.BatchUpdateException: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at line 1

Error Code: 6502
	at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:331)
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeJDK12BatchStatement(DatabaseAccessor.java:933)
	at org.eclipse.persistence.internal.databaseaccess.ParameterizedSQLBatchWritingMechanism.executeBatch(ParameterizedSQLBatchWritingMechanism.java:179)
	at org.eclipse.persistence.internal.databaseaccess.ParameterizedSQLBatchWritingMechanism.executeBatchedStatements(ParameterizedSQLBatchWritingMechanism.java:134)
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.writesCompleted(DatabaseAccessor.java:1845)
	at org.eclipse.persistence.internal.sessions.AbstractSession.writesCompleted(AbstractSession.java:4301)
	at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.writesCompleted(UnitOfWorkImpl.java:5592)
	at org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.writeChanges(RepeatableWriteUnitOfWork.java:456)
	at org.eclipse.persistence.internal.jpa.EntityManagerImpl.flush(EntityManagerImpl.java:874)
	... 108 more
Caused by: java.sql.BatchUpdateException: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at line 1

	at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10500)
	at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:230)
	at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.executeBatch(DelegatingStatement.java:348)
	at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.executeBatch(DelegatingStatement.java:348)
	at org.eclipse.persistence.platform.database.oracle.Oracle10Platform.executeBatch(Oracle10Platform.java:65)
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeJDK12BatchStatement(DatabaseAccessor.java:922)
	... 115 more
Previous Topic:How to exclude entity transactions from logging
Next Topic:BatchFetch examples?
Goto Forum:
  


Current Time: Thu Dec 14 04:23:54 GMT 2017

Powered by FUDForum. Page generated in 0.01394 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software