Hello everyone,
I'm trying to index on an Oracle DB, but can't seem to find any built in
support for objects of type oracle.sql.Clob. The field I try to put the data
into is of type text, but after indexing it only contains the Clob-objects
string representation, i.e. something like [EMAIL PROTECT
If you are querying Oracle yourself and using something like SolrJ,
then you must convert the Clob yourself into a String representation.
Also, did you look at Solr's DataImportHandler?
-Yonik
On Mon, Dec 1, 2008 at 3:11 PM, Joel Karlsson <[EMAIL PROTECTED]> wrote:
> Hello everyone,
>
> I'm tryi
Thanks for your reply!
I'm already using the DataImportHandler for indexing. Do I still have to
convert the Clob myself or are there any built-in functions that I've
missed?
// Joel
2008/12/1 Yonik Seeley <[EMAIL PROTECTED]>
> If you are querying Oracle yourself and using something like SolrJ,
Hi Joel,
DIH does not translate Clob automatically to text.
We can open that as an issue.
meanwhile you can write a transformer of your own to read Clob and
convert to text.
http://wiki.apache.org/solr/DataImportHandler#head-4756038c418ab3fa389efc822277a7a789d27688
On Tue, Dec 2, 2008 at 2:57 AM
I have raised a new issue
https://issues.apache.org/jira/browse/SOLR-891
On Tue, Dec 2, 2008 at 9:54 AM, Noble Paul നോബിള് नोब्ळ्
<[EMAIL PROTECTED]> wrote:
> Hi Joel,
> DIH does not translate Clob automatically to text.
>
> We can open that as an issue.
> meanwhile you can write a transformer of
cool
The only problem is that java.sql.Clob#getCharacterStream() is package
private and you have to use the oracle.sql.CLOB
On Tue, Dec 2, 2008 at 1:38 PM, Joel Karlsson <[EMAIL PROTECTED]> wrote:
> Thanks for your reply!
>
> I wrote such a transformer and now it seems to work perfectly. Here's
Thanks for your reply!
I wrote such a transformer and now it seems to work perfectly. Here's the
code for the transformer if anyone encounters the same problem, or if anyone
want to improve it:
import org.apache.solr.handler.dataimport.*;
import oracle.sql.CLOB;
import java.util.*;
import java.io
no probs We can fix that using reflection. I shall give a patch w/ that.
Probably it is better to fix it in a Transformer
On Tue, Dec 2, 2008 at 1:56 PM, Joel Karlsson <[EMAIL PROTECTED]> wrote:
> True, but perhaps it works with java.sql.Clob as well, haven't tried it
> though.
>
> 2008/12/2 Nob
True, but perhaps it works with java.sql.Clob as well, haven't tried it
though.
2008/12/2 Noble Paul നോബിള് नोब्ळ् <[EMAIL PROTECTED]>
> cool
>
> The only problem is that java.sql.Clob#getCharacterStream() is package
> private and you have to use the oracle.sql.CLOB
>
>
>
> On Tue, Dec 2, 2008 a