Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
3 replies Latest Post - ‏2012-11-16T09:30:50Z by myutaka
reddz
reddz
23 Posts
ACCEPTED ANSWER

Pinned topic IBM Database Crawling with CLOB column throwing Null Pointer exception

‏2012-11-14T13:57:37Z |
Hi All,

I am crawling IBM DB2 table, with CLOB Column . CLOB column contains plain text. when i try to crawl table its Throwing Null Pointer exception. Logs are saying its Not to Retrieve next Records.
Can you please let me where i am going wrong.
Omnifind Version is 9.1.
Crawler is JDBC Crawler.
Database IBM db2

I have also Selected CLOB Column in Edit of Crawl setting and enabled Column Content & Metadata is Plaintext.
Updated on 2012-11-16T09:30:50Z at 2012-11-16T09:30:50Z by myutaka
  • bfoyle
    bfoyle
    29 Posts
    ACCEPTED ANSWER

    Re: IBM Database Crawling with CLOB column throwing Null Pointer exception

    ‏2012-11-14T21:37:10Z  in response to reddz
    Can you try a different table or one without the CLOB and see if it's related to that or if it's just JDBC to that source in general?

    bf
  • reddz
    reddz
    23 Posts
    ACCEPTED ANSWER

    Re: IBM Database Crawling with CLOB column throwing Null Pointer exception

    ‏2012-11-15T05:54:49Z  in response to reddz
    Hi bfoyle,

    Thanks for reply ,

    Crawling of other database tables without CLOB column is working fine, Only Table with Clob is having issues .
    If i Uncheck Column with clob for Crawling , Then also its working fine .
  • myutaka
    myutaka
    1 Post
    ACCEPTED ANSWER

    Re: IBM Database Crawling with CLOB column throwing Null Pointer exception

    ‏2012-11-16T09:30:50Z  in response to reddz
    Hi
    Which version of DB2 are you trying to crawl?
    Do you use JDBC driver bundled with the DB2 server?
    Also, copy&paste the error message (stack trace) may help.
    Thanks