java.sql.SQLException: lob is no longer valid

hsqldb | wespsousa | 7 years ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.

Root Cause Analysis

  1. java.sql.SQLException

    lob is no longer valid

    at org.hsqldb.jdbc.Util.sqlException()
  2. HSQLDB
    JDBCBlobClient.getBytes
    1. org.hsqldb.jdbc.Util.sqlException(Unknown Source)
    2. org.hsqldb.jdbc.Util.sqlException(Unknown Source)
    3. org.hsqldb.jdbc.JDBCBlobClient.getBytes(Unknown Source)
    3 frames
  3. com.whateversoft.foundation
    BlobType.nullSafeGet
    1. com.whateversoft.foundation.dao.hibernate.BlobType.nullSafeGet(BlobType.java:69)
    1 frame
  4. net.sf.hibernate
    CriteriaImpl.list
    1. net.sf.hibernate.type.CustomType.nullSafeGet(CustomType.java:92)
    2. net.sf.hibernate.type.AbstractType.hydrate(AbstractType.java:67)
    3. net.sf.hibernate.loader.Loader.hydrate(Loader.java:690)
    4. net.sf.hibernate.loader.Loader.loadFromResultSet(Loader.java:631)
    5. net.sf.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:590)
    6. net.sf.hibernate.loader.Loader.getRow(Loader.java:505)
    7. net.sf.hibernate.loader.Loader.getRowFromResultSet(Loader.java:218)
    8. net.sf.hibernate.loader.Loader.doQuery(Loader.java:285)
    9. net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:138)
    10. net.sf.hibernate.loader.Loader.doList(Loader.java:1063)
    11. net.sf.hibernate.loader.Loader.list(Loader.java:1054)
    12. net.sf.hibernate.loader.CriteriaLoader.list(CriteriaLoader.java:118)
    13. net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:3661)
    14. net.sf.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:238)
    14 frames
  5. pt.brisa.sgmp
    VehicleInfoManager.getVehiclePhotoList
    1. pt.brisa.sgmp.integration.persistence.vehiclemodel.VehiclePhotoDAO.execute(VehiclePhotoDAO.java:102)
    2. pt.brisa.sgmp.integration.persistence.vehiclemodel.VehiclePhotoDAO.findByModelId(VehiclePhotoDAO.java:54)
    3. pt.brisa.sgmp.remote.dispatcher.control.VehicleInfoManager.getVehiclePhotoList(VehicleInfoManager.java:71)
    3 frames