I have found the reason. The reason is that I am using jboss JNDI
datasource, and oracle driver is placed in WEB-INFO/lib, this is a very
common error, driver should be placed in %JBOSS_HOME%\server\default\lib.
2012/10/10 jun Wang <wangjun...@gmail.com>
> Hi, all
> I found that dataimport will failed at first time after restart. and the
> log is here . It's seem like a bug.
>
> 2012-10-09 20:00:08,848 ERROR dataimport.DataImporter - Full Import
> failed:java.lang.RuntimeException: java.lang.RuntimeException:
> org.apache.solr.handler.dataimport.DataImportHandlerException: Unable to
> execute query: select a.id, a.subject, a.keywords, a.category_id,
> to_number((a.gmt_modified - to_date('1970-01-01','yyyy-mm-dd'))*24*60*60)
> as gmt_modified,a.member_seq, b.standard_attr_desc,
> b.custom_attr_desc, decode(a.product_min_price, null, 0,
> a.product_min_price)/100 as min_price, sign(a.ws_offline_date - sysdate) +
> 1 as is_offline from ws_product_draft a,
> ws_product_attribute_draft b where a.id =
> b.product_id(+) Processing Document # 1
> at
> org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:273)
> at
> org.apache.solr.handler.dataimport.DataImporter.doFullImport(DataImporter.java:382)
> at
> org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:448)
> at
> org.apache.solr.handler.dataimport.DataImporter$1.run(DataImporter.java:429)
> Caused by: java.lang.RuntimeException:
> org.apache.solr.handler.dataimport.DataImportHandlerException: Unable to
> execute query: select a.id, a.subject, a.keywords, a.category_id,
> to_number((a.gmt_modified - to_date('1970-01-01','yyyy-mm-dd'))*24*60*60)
> as gmt_modified,a.member_seq, b.standard_attr_desc,
> b.custom_attr_desc, decode(a.product_min_price, null, 0,
> a.product_min_price)/100 as min_price, sign(a.ws_offline_date - sysdate) +
> 1 as is_offline from ws_product_draft a,
> ws_product_attribute_draft b where a.id =
> b.product_id(+) Processing Document # 1
> at
> org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:413)
> at
> org.apache.solr.handler.dataimport.DocBuilder.doFullDump(DocBuilder.java:326)
> at
> org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:234)
> ... 3 more
> Caused by: org.apache.solr.handler.dataimport.DataImportHandlerException:
> Unable to execute query: select a.id, a.subject, a.keywords,
> a.category_id, to_number((a.gmt_modified -
> to_date('1970-01-01','yyyy-mm-dd'))*24*60*60) as gmt_modified,a.member_seq,
> b.standard_attr_desc, b.custom_attr_desc,
> decode(a.product_min_price, null, 0, a.product_min_price)/100 as min_price,
> sign(a.ws_offline_date - sysdate) + 1 as is_offline
> from ws_product_draft a, ws_product_attribute_draft b
> where a.id = b.product_id(+) Processing Document # 1
> at
> org.apache.solr.handler.dataimport.DataImportHandlerException.wrapAndThrow(DataImportHandlerException.java:71)
> at
> org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.<init>(JdbcDataSource.java:252)
> at
> org.apache.solr.handler.dataimport.JdbcDataSource.getData(JdbcDataSource.java:209)
> at
> org.apache.solr.handler.dataimport.JdbcDataSource.getData(JdbcDataSource.java:38)
> at
> org.apache.solr.handler.dataimport.SqlEntityProcessor.initQuery(SqlEntityProcessor.java:59)
> at
> org.apache.solr.handler.dataimport.SqlEntityProcessor.nextRow(SqlEntityProcessor.java:73)
> at
> org.apache.solr.handler.dataimport.EntityProcessorWrapper.nextRow(EntityProcessorWrapper.java:243)
> at
> org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:472)
> at
> org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:411)
> ... 5 more
> Caused by: java.lang.ClassNotFoundException: Unable to load null or
> org.apache.solr.handler.dataimport.null
> at
> org.apache.solr.handler.dataimport.DocBuilder.loadClass(DocBuilder.java:899)
> at
> org.apache.solr.handler.dataimport.JdbcDataSource$1.call(JdbcDataSource.java:159)
> at
> org.apache.solr.handler.dataimport.JdbcDataSource$1.call(JdbcDataSource.java:127)
> at
> org.apache.solr.handler.dataimport.JdbcDataSource.getConnection(JdbcDataSource.java:362)
> at
> org.apache.solr.handler.dataimport.JdbcDataSource.access$200(JdbcDataSource.java:38)
> at
> org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.<init>(JdbcDataSource.java:239)
> ... 12 more
> Caused by: java.lang.NullPointerException
> at
> java.util.concurrent.ConcurrentHashMap.get(ConcurrentHashMap.java:768)
> at
> org.apache.solr.core.SolrResourceLoader.findClass(SolrResourceLoader.java:387)
> at
> org.apache.solr.handler.dataimport.DocBuilder.loadClass(DocBuilder.java:889)
> ... 17 more
>
>
>
> --
> from Jun Wang
>
>
>
--
from Jun Wang
