Oracle LONG RAW data type

197 views

Skip to first unread message

Andrey Rogov

unread,

Nov 3, 2021, 1:52:52 PM11/3/21

to mybati...@googlegroups.com

Hi,

I need to read the LONG RAW data type from Oracle,

I get an error when I try to read the LR data into the byte[]

Error attempting to get column 'FILEDATA' from result set. Cause: java.sql.SQLException: Invalid column type: getBLOB not implemented for class oracle.jdbc.driver.T4CLongRawAccessor \ n; uncategorized SQLException; SQL state [99999]; error code [17004]; Invalid column type: getBLOB not implemented for class oracle.jdbc.driver.T4CLongRawAccessor; nested exception is java.sql.SQLException: Invalid column type: getBLOB not implemented for class oracle.jdbc.driver.T4CLongRawAccessor ",

What is the JDBC Type is needed for this :LONG RAW ?

regards

Andrey

Guy Rouillier

unread,

Nov 4, 2021, 3:45:22 AM11/4/21

to mybati...@googlegroups.com

Looks like you need to use streams:

https://docs.oracle.com/cd/F49540_01/DOC/java.815/a64685/basic4.htm

And here is an example of reading an input steam via MyBatis:

https://stackoverflow.com/questions/62066525/how-do-i-use-mybatis-blobinputstreamtypehandler-clobreadertypehandler-to-strea

--
You received this message because you are subscribed to the Google Groups "mybatis-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mybatis-user...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/mybatis-user/CAAJ_J14E9thuiVXo4DsYa35teXwVvrDozxhakYFKRHrgCD7kJg%40mail.gmail.com.

--