"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

  • Older News
  • Which type is BLOB? StackOverFlow (2 days ago) - I have about 100,000 BLOBs in my database and have to work with them. All is ok when someone tells me which type of BLOB I must deal with. But...