Could any one shed a light please?
I saw in the log a message as below, but I don't think it's the root
cause, because my dataSrouce, the readOnly is true
Caused by: java.sql.SQLException: READ_COMMITTED and SERIALIZABLE are
the only valid transaction levels
A newbie Solr user
=============
On 10/29/2010 1:49 PM, Bac Hoang wrote:
Hello all,
I'm getting stuck when trying to import oracle DB to solr index, could
any one of you give a hand. Thanks million.
Below is some short info. that might be a question
My Sorl: 1.4.1
==== *LOG *========
INFO: Starting Full Import
Oct 29, 2010 1:19:35 PM org.apache.solr.handler.dataimport.SolrWriter
readIndexerProperties
INFO: Read dataimport.properties
Oct 29, 2010 1:19:35 PM
org.apache.solr.handler.dataimport.JdbcDataSource$1 call
INFO: Creating a connection for entity attach with URL:
jdbc:oracle:thin:@192.168.72.7:1521:OFIRDS22
Oct 29, 2010 1:19:36 PM org.apache.solr.handler.dataimport.DocBuilder
buildDocument
*SEVERE: Exception while processing: attach document *:
SolrInputDocument[{}]
org.apache.solr.handler.dataimport.DataImportHandlerException: *Unable
to execute query: *select * from A.B Processing Document # 1
============
where A: a schema
B: a table
==== *dataSource *=======
<dataSource name="jdbc" driver="oracle.jdbc.driver.OracleDriver"
url="jdbc:oracle:thin:@192.168.72.7:1521:OFIRDS22" user="abc"
password="xyz"
readOnly="true" autoCommit="false" batchSize="1"/>
<document>
<entity dataSource="jdbc" name="attach" query="select * from A.B">
<entity processor="SqlEntityProcessor" dataField="attach.TOPIC"
format="text">
<field column="text" name="text" />
</entity>
</entity>
</document>
============
where TOPIC is a filed of table B
Thanks again
