"ISAM error: record is locked" when trying to obtain a BLOB

I have a java service that executes a select query in my DB, the table to which it points has a BLOB column that can be null. If the table is empty or if the table has rows but those rows have null in the BLOB value, everything works correctly, but when i try to access to a row with a not null BLOB, this error happened:

javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: Smart-large-object error.

at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1387)

at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1310)

at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:273)

at com.mysema.query.jpa.impl.AbstractJPAQuery.getResultList(AbstractJPAQuery.java:194)

at com.mysema.query.jpa.impl.AbstractJPAQuery.list(AbstractJPAQuery.java:246)

at com.everis.ehcos.sigur.server.dao.operacion.OperacionDAO.findOperaciones(OperacionDAO.java:33)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)

at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)

at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:85)

at com.everis.ehcos.framework.common.util.error.ErrorsLogsConfig.printErrorLogs(ErrorsLogsConfig.java:63)

at sun.reflect.GeneratedMethodAccessor75.invoke(Unknown...

Read More »

By: StackOverFlow - Friday, 9 November

Related Posts