[hibernate-dev] Sybase BLOB loading errors

[Strong Liu]

there was some problems with sybase blob support, but I think from Sybase ASE 15.7 it is resolved now

the problem here is using scrollable result set

something worth to try though:

1. using FORWARD_ONLY in the org.hibernate.Query#scroll since the sybase driver seems supports this mode best

2. try to find the latest sybase jdbc driver and hop it now fixes the problem

On Jul 10, 2013, at 6:58 PM, Sanne Grinovero <sanne at hibernate.org> wrote:

> We have the below error reported since quite a while in the Hibernate
> Search testsuite, when run on Sybase.
> I remember when initially noticing that someone told me it was about a
> known problem in ORM, but I didn't track the JIRA issue. Someone knows
> please?
> 
> TiA
> Sanne
> 
> 
> Error Message
> 
> The method com.sybase.jdbc4.jdbc.SybCursorResultSet.getBlob(String) is
> not supported and should not be called.
> 
> Stacktrace
> 
> java.lang.UnsupportedOperationException: The method
> com.sybase.jdbc4.jdbc.SybCursorResultSet.getBlob(String) is not
> supported and should not be called.
> at com.sybase.jdbc4.jdbc.ErrorMessage.raiseRuntimeException(Unknown Source)
> at com.sybase.jdbc4.utils.Debug.notSupported(Unknown Source)
> at com.sybase.jdbc4.jdbc.SybResultSet.getBlob(Unknown Source)
> at org.hibernate.type.descriptor.sql.BlobTypeDescriptor$1.doExtract(BlobTypeDescriptor.java:64)
> at org.hibernate.type.descriptor.sql.BasicExtractor.extract(BasicExtractor.java:64)
> at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:261)
> at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:257)
> at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:247)
> at org.hibernate.type.AbstractStandardBasicType.hydrate(AbstractStandardBasicType.java:332)
> at org.hibernate.persister.entity.AbstractEntityPersister.hydrate(AbstractEntityPersister.java:2912)
> at org.hibernate.loader.Loader.loadFromResultSet(Loader.java:1673)
> at org.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:1605)
> at org.hibernate.loader.Loader.getRow(Loader.java:1505)
> at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:713)
> at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:683)
> at org.hibernate.loader.Loader.loadSingleRow(Loader.java:379)
> at org.hibernate.internal.ScrollableResultsImpl.prepareCurrentRow(ScrollableResultsImpl.java:240)
> at org.hibernate.internal.ScrollableResultsImpl.next(ScrollableResultsImpl.java:117)
> at org.hibernate.search.test.bridge.tika.TikaBridgeBlobSupportTest.indexBook(TikaBridgeBlobSupportTest.java:128)
> at org.hibernate.search.test.bridge.tika.TikaBridgeBlobSupportTest.testDefaultTikaBridgeWithBlobData(TikaBridgeBlobSupportTest.java:74)
> _______________________________________________
> hibernate-dev mailing list
> hibernate-dev at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/hibernate-dev

-------------------------
Best Regards,

Strong Liu <stliu at hibernate.org>
http://about.me/stliu/bio