Databases
StackOverflow2013
Postsdbo
POsolr clobtransfomer
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POsolr clobtransfomer
    text
    copied!<p>I am stuck with <code>ClobTransformer</code> in solr from the past 3 days. I want to convert an oracle clob field to text field in solr. I am using multiple cores and I started my config and schema files from scratch.</p> <p>This is my config file:</p> <pre><code>&lt;lib dir="../../../dist/" regex="apache-solr-dataimporthandler-.*\.jar" /&gt; &lt;requestHandler name="/dataimport" class="org.apache.solr.handler.dataimport.DataImportHandler"&gt; &lt;lst name="defaults"&gt; &lt;str name="config"&gt;data-config.xml&lt;/str&gt; &lt;/lst&gt; &lt;/requestHandler&gt; </code></pre> <p>These are the columns in my schema file for a core:</p> <pre><code>&lt;field name="id" type="string" indexed="true" stored="true" multiValued="false" required="true"/&gt; &lt;field name="mandp" type="text_en_splitting" indexed="true" stored="true" multiValued="false" /&gt; </code></pre> <p>This is my data-config.xml for the core:</p> <pre><code>&lt;dataConfig&gt; &lt;dataSource type="JdbcDataSource" driver="oracle.jdbc.driver.OracleDriver" url="jdbc:oracle:thin:@***" user="***" password="****"/&gt; &lt;document&gt; &lt;entity name="wiki" transformer="ClobTransformer" query="Select t.id as id, t.mandp From table1 t"&gt; &lt;field column="mandp" name="mandp" clob="true" /&gt; &lt;/entity&gt; &lt;/document&gt; &lt;/dataConfig&gt; </code></pre> <p>When I start solr, I can see that dataimporthandler*.jar files have loaded successfully in the console. When I run my dataimport from <code>http://localhost:8983/solr/wiki/dataimport?command=full-import&amp;clean=false</code>, I don't see any errors in the console neither do I see anything related to transformer or clob. So, If I type anything in my transformer parameter (transformer="bla bla bla"), it doesn't throw any errors in the console, that could mean my transformer argument is completely ignored or the full logging is turned off.</p> <p>When I query solr, I see <b>oracle.sql.CLOB@375c929a</b> in the mandp field. Nothing happens of course if I use HTMLStripTransformer class too. I want to use both on this field.</p> <p>Any ideas are appreciated!!!</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload