Re: Oracle Clob column with DIH does not turn to String

2009-04-04 Thread Shalin Shekhar Mangar
On Sat, Apr 4, 2009 at 7:15 PM, ashokc wrote: > > Yes, you are correct. But the documentation for DIH says the column names > are > case insensitive. That should be fixed. Here is what it says: > > = > A shorter data-config > > In the above example, there are mappings of fields to Sol

Re: Oracle Clob column with DIH does not turn to String

2009-04-04 Thread ashokc
Yes, you are correct. But the documentation for DIH says the column names are case insensitive. That should be fixed. Here is what it says: = A shorter data-config In the above example, there are mappings of fields to Solr fields. It is possible to totally avoid the field entries in

Re: Oracle Clob column with DIH does not turn to String

2009-04-03 Thread Noble Paul നോബിള്‍ नोब्ळ्
it is very expensive to do a case insensitive lookup. It must first convert all the keys to lower case and try looking up there. because it may not be always in uppercase it can be in mixed case as well On Sat, Apr 4, 2009 at 12:58 AM, ashokc wrote: > > Happy to report that it is working. Looks l

Re: Oracle Clob column with DIH does not turn to String

2009-04-03 Thread ashokc
Happy to report that it is working. Looks like we have to use UPPER CASE for all the column names. When I examined the map 'aRow', it had the column names in upper case, where as my config had lower case. No match was found so nothing happened. Changed my config and it works now. Thanks for your h

Re: Oracle Clob column with DIH does not turn to String

2009-04-03 Thread Noble Paul നോബിള്‍ नोब्ळ्
I guess u can write a custom transformer which gets a String out of the oracle.sql.CLOB. I am just out of clue, why this may happen. I even wrote a testcase and it seems to work fine --Noble On Fri, Apr 3, 2009 at 10:23 PM, ashokc wrote: > > I downloaded the nightly build yesterday (2nd April), m

Re: Oracle Clob column with DIH does not turn to String

2009-04-03 Thread ashokc
I downloaded the nightly build yesterday (2nd April), modified the ClobTransformer.java file with some prints, compiled it all (ant dist). It produced a war file, "apache-solr-1.4-dev.war". That is what I am using. My modification & compilation has not affected the results. I was getting the same

Re: Oracle Clob column with DIH does not turn to String

2009-04-03 Thread Noble Paul നോബിള്‍ नोब्ळ्
and which version of Solr are u using? On Fri, Apr 3, 2009 at 10:09 PM, ashokc wrote: > > Sure: > > data-config Xml > === > > >     url="jdbc:oracle:thin:@x" user="remedy" password="y"/> >     >             >                 >                 >                 >             >

Re: Oracle Clob column with DIH does not turn to String

2009-04-03 Thread ashokc
Sure: data-config Xml === === A search result on the field short_desc: -- 1.8670129 oracle.sql.c...@155e3ab 4486 Develop Rating functionality

Re: Oracle Clob column with DIH does not turn to String

2009-04-03 Thread Noble Paul നോബിള്‍ नोब्ळ्
There is something else wrong with your setup. can you just paste the whole data-config.xml --Noble On Fri, Apr 3, 2009 at 5:39 PM, ashokc wrote: > > Noble, > I put in a few 'System.out.println' statements in the ClobTransformer.java > file & remade the war. But I see none of these prints comin

Re: Oracle Clob column with DIH does not turn to String

2009-04-03 Thread ashokc
Noble, I put in a few 'System.out.println' statements in the ClobTransformer.java file & remade the war. But I see none of these prints coming up in my 'catalina.out' file. Is that the right file to be looking at? As an aside, is 'catalina.out' the ONLY log file for SOLR? I turned on the logging

Re: Oracle Clob column with DIH does not turn to String

2009-04-02 Thread Noble Paul നോബിള്‍ नोब्ळ्
yeah, ant dist will give you the .war file you may need . just drop it in and you are set to go. or if you can hook up a debugger to a running Solr that is the easiest --Noble On Fri, Apr 3, 2009 at 9:35 AM, ashokc wrote: > > That would require me to recompile (with ant/maven scripts?) the source

Re: Oracle Clob column with DIH does not turn to String

2009-04-02 Thread ashokc
That would require me to recompile (with ant/maven scripts?) the source and replace the jar for DIH, right? I can try - for the first time. - ashok Noble Paul നോബിള്‍ नोब्ळ् wrote: > > This looks strange. Apparently the Transformer did not get applied. Is > it possible for you to debug ClobTran

Re: Oracle Clob column with DIH does not turn to String

2009-04-02 Thread Noble Paul നോബിള്‍ नोब्ळ्
This looks strange. Apparently the Transformer did not get applied. Is it possible for you to debug ClobTransformer adding(System.out.println into ClobTransformer may help) On Fri, Apr 3, 2009 at 6:04 AM, ashokc wrote: > > Correcting my earlier post. It lost some lines some how. > > Hi, > > I hav

Re: Oracle Clob column with DIH does not turn to String

2009-04-02 Thread ashokc
Correcting my earlier post. It lost some lines some how. Hi, I have set up to import some oracle clob columns with DIH. I am using the latest nightly release. My config says, But it does not seem to turn this clob into a String. The search results show: 1.8670129 oracle.s