oracle and java.sql.SQLException: READ_COMMITTED and SERIALIZABLE are the only valid transaction levels

[Siarhei Padolski]

Hello,

I’m trying to import data using a read only account to an Oracle database.
My data-config.xml is:

<dataConfig>
  <dataSource name="jdbc" driver="oracle.jdbc.OracleDriver"
     url="jdbc:oracle:oci8:@//localhost:10010:CONNECTION"
     user="ATLAS_PANDABIGMON_R"
     password="Lutini72"
     readOnly="true"
     autoCommit="false" batchSize="100"
     />
  <document name="JOBSARCHIVED4">
    <entity name="job" dataSource="jdbc" query="SELECT * from JOBSARCHIVED4 
WHERE ROWNUM &lt; 1000">
   </entity>
  </document>
</dataConfig>


I’m getting:


Exception while processing: job document : SolrInputDocument(fields: 
[]):org.apache.solr.handler.dataimport.DataImportHandlerException: Exception 
initializing SQL connection Processing Document # 1
        at 
org.apache.solr.handler.dataimport.JdbcDataSource$1.call(JdbcDataSource.java:166)
        at 
org.apache.solr.handler.dataimport.JdbcDataSource$1.call(JdbcDataSource.java:133)
        at 
org.apache.solr.handler.dataimport.JdbcDataSource.getConnection(JdbcDataSource.java:402)
        at 
org.apache.solr.handler.dataimport.JdbcDataSource.access$200(JdbcDataSource.java:44)
        at 
org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.<init>(JdbcDataSource.java:270)
        at 
org.apache.solr.handler.dataimport.JdbcDataSource.getData(JdbcDataSource.java:240)
        at 
org.apache.solr.handler.dataimport.JdbcDataSource.getData(JdbcDataSource.java:44)
        at 
org.apache.solr.handler.dataimport.SqlEntityProcessor.initQuery(SqlEntityProcessor.java:58)
        at 
org.apache.solr.handler.dataimport.SqlEntityProcessor.nextRow(SqlEntityProcessor.java:72)
        at 
org.apache.solr.handler.dataimport.EntityProcessorWrapper.nextRow(EntityProcessorWrapper.java:243)
        at 
org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:475)
        at 
org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:414)
        at 
org.apache.solr.handler.dataimport.DocBuilder.doFullDump(DocBuilder.java:329)
        at 
org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:232)
        at 
org.apache.solr.handler.dataimport.DataImporter.doFullImport(DataImporter.java:416)
        at 
org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:480)
        at 
org.apache.solr.handler.dataimport.DataImporter$1.run(DataImporter.java:461)
Caused by: java.sql.SQLException: READ_COMMITTED and SERIALIZABLE are the only 
valid transaction levels
        at 
oracle.jdbc.driver.PhysicalConnection.setTransactionIsolation(PhysicalConnection.java:3301)
        at 
org.apache.solr.handler.dataimport.JdbcDataSource$1.initializeConnection(JdbcDataSource.java:180)
        at 
org.apache.solr.handler.dataimport.JdbcDataSource$1.call(JdbcDataSource.java:158)
        ... 16 more




Could you help me with this issue?

Thanks a lot.
With best regards,
Sergey