Solr-Oracle Multi Value Issue

 Hi

 

I'm  trying to create Solr index from oracle db.

the trick is that i'm using multivalue field in solr, and expect from solr to split the value to multi value field.

here is my data-config.xml

<document name="doc">           
            <entity name="EBAYSE_CORE" transformer="RegexTransformer"
                      query="SELECT id,value1 FROM multivalue" >

                <field column="id" name="id" />
                <field column="value1" name="value1" splitBy="\;" />

            </entity>
        </document>

here is the schema.xml:

 <field name="id" type="string" indexed="true" stored="true" required="true"/>
        <field name="value" type="text_en" indexed="true" stored="true" required="false" multiValued="true"/>

 

and here is a data sample:

id         value1
1	iphone4;iphone3
2	itai;ram;tomer;vladi
3	test1;test2;test3

 

when indexing the data i get the values as one row instead of seperate by ';' 

any ideas?

 

Note: with mySQL wit works fine, as expexted.

 

thanks

Itai

 

Comments

 try to set character encoding to dataSource:

<dataSource type="FileDataSource" encoding="UTF-8"/>

 

 

Another possible solution is to use ClobTransformer
 
 ...transformer="ClobTransformer, RegexTransformer"
 
<field column="value1" name="value1" splitBy="\;" clob="true"/>

 

 solve the problem -

oracle is case sensative and its output field names are in upper case...