Upgrade JIRA 7, get error Error occurred during export before upgrade: Error creating GenericValue (SQL Exception while getting value: (Invalid column type: getBLOB not implemented for class oracle.jdbc.driver.T4CLongRawAccessor))

[Adrian Stephen]

Performed an upgrade to JIRA 7, got the following exception:

Error occurred during export before upgrade: Error creating GenericValue (SQL Exception while getting value: (Invalid column type: getBLOB not implemented for class oracle.jdbc.driver.T4CLongRawAccessor))
If necessary, auto-export can be disabled; see http://www.atlassian.com/software/jira/docs/latest/upgrade/autoexport.html
org.ofbiz.core.util.GeneralRuntimeException: Error creating GenericValue (SQL Exception while getting value: (Invalid column type: getBLOB not implemented for class oracle.jdbc.driver.T4CLongRawAccessor))
at org.ofbiz.core.entity.EntityListIterator.next(EntityListIterator.java:253)
at com.atlassian.jira.ofbiz.DefaultOfBizListIterator.next(DefaultOfBizListIterator.java:140)
at com.atlassian.jira.ofbiz.WrappingOfBizListIterator.next(WrappingOfBizListIterator.java:80)
at com.atlassian.jira.action.admin.export.DefaultSaxEntitiesExporter.exportEntity(DefaultSaxEntitiesExporter.java:159)
at com.atlassian.jira.action.admin.export.DefaultSaxEntitiesExporter.exportEntities(DefaultSaxEntitiesExporter.java:110)
at com.atlassian.jira.bc.dataimport.DefaultExportService.exportJIRA(DefaultExportService.java:203)
at com.atlassian.jira.bc.dataimport.DefaultExportService.export(DefaultExportService.java:89)
at com.atlassian.jira.bc.dataimport.DefaultExportService.export(DefaultExportService.java:71)
com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.doNowOrEnqueue(DatabaseConfigurationManagerImpl.java:356)
at 
Caused by: java.sql.SQLException: Invalid column type: getBLOB not implemented for class oracle.jdbc.driver.T4CLongRawAccessor
at oracle.jdbc.driver.Accessor.unimpl(Accessor.java:412)
at oracle.jdbc.driver.Accessor.getBLOB(Accessor.java:1270)
at oracle.jdbc.driver.OracleResultSetImpl.getBLOB(OracleResultSetImpl.java:1623)
at oracle.jdbc.driver.OracleResultSetImpl.getBlob(OracleResultSetImpl.java:585)
at org.apache.commons.dbcp.DelegatingResultSet.getBlob(DelegatingResultSet.java:550)
at org.apache.commons.dbcp.DelegatingResultSet.getBlob(DelegatingResultSet.java:550)
at org.ofbiz.core.entity.jdbc.SqlJdbcUtil.getBlobAsByteArray(SqlJdbcUtil.java:741)
at org.ofbiz.core.entity.jdbc.SqlJdbcUtil.getValue(SqlJdbcUtil.java:701)
... 34 more

[Huw Evans]

Same here, we're using 12c and get the same behaviour.

I think this is related to this - https://confluence.atlassian.com/pages/viewpage.action?pageId=788042925

Which references this ticket - https://jira.atlassian.com/browse/JRA-47267 

[Azfar Masut]

This is due to the Oracle Version is 11g

[o.o.c.entity.jdbc.DatabaseUtil] Database Product Version is Oracle Database 11g Release 11.2.0.4.0 - 64bit Production
Upgrade the Oracle database version to 12c, and ensure that JIRA 7 supported platforms are checked.
https://confluence.atlassian.com/display/adminjiraserver070/Supported+Platforms

[Rune Hauge]

I have Oracle 12 and i get the same error.