I have an update:
I played around with it some more and it seems like it's being caused by the
ClobTransformer. If I remove the 'clob="true"' from the field part in the
data-config, it works fine.
The Solr install is a multicore one. I placed the
apache-solr-dataimporthandler-1.4-dev.jar from the nightly builds in the
{solrHome}/core1/lib directory (I only need it for the first core). Is there
something else I need to do for it to work?
I don't recall doing an additional step when I did this a few weeks ago on
my local machine.
Any help is appreciated.
Regards
ahammad wrote:
>
> Hello all,
>
> I am tyring to index directly from an Oracle DB. This is what appears in
> the stack trace:
>
> SEVERE: Full Import failed
> org.apache.solr.handler.dataimport.DataImportHandlerException: Unable to
> execute query: select * from ARTICLE Processing Document # 1
> at
> org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.<init>(JdbcDataSource.java:186)
> at
> org.apache.solr.handler.dataimport.JdbcDataSource.getData(JdbcDataSource.java:143)
> at
> org.apache.solr.handler.dataimport.JdbcDataSource.getData(JdbcDataSource.java:43)
> at
> org.apache.solr.handler.dataimport.SqlEntityProcessor.initQuery(SqlEntityProcessor.java:59)
> at
> org.apache.solr.handler.dataimport.SqlEntityProcessor.nextRow(SqlEntityProcessor.java:74)
> at
> org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:285)
> at
> org.apache.solr.handler.dataimport.DocBuilder.doFullDump(DocBuilder.java:178)
> at
> org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:136)
> at
> org.apache.solr.handler.dataimport.DataImporter.doFullImport(DataImporter.java:334)
> at
> org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:386)
> at
> org.apache.solr.handler.dataimport.DataImporter$1.run(DataImporter.java:377)
> Caused by: java.sql.SQLException: Closed Connection
> at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
> at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
> at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
> at
> oracle.jdbc.driver.PhysicalConnection.createStatement(PhysicalConnection.java:755)
> at
> org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.<init>(JdbcDataSource.java:174)
> ... 10 more
>
> Funny thing is, the data import works on my local machine. I moved all the
> config files to another server, and I get this. I reindexed on my local
> machine immediately after in order to verify that the DB works, and it
> indexes fine.
>
> Here is my data-config file, just in case:
>
> <dataConfig>
> <dataSource driver="oracle.jdbc.driver.OracleDriver" url="xxxxxxx"
> user="xxxxxxx" password="xxxxxxx"/>
> <document name="articles">
> <entity name="ARTICLE" pk="ID" query="select * from ARTICLE"
> transformer="ClobTransformer">
> <field column="TITLE" name="title" />
> <field column="BODY" name="body" clob="true" />
> <field column="ID" name="id" />
>
> <entity name="ARTICLE_AUTHOR" query="select
> ID_A from ARTICLE_AUTHOR
> where ID_A='${ARTICLE.ID}'">
> <field column="ID_A" name="author" />
> </entity>
>
> </entity>
> </document>
> </dataConfig>
>
> I am using the 1.3 release version, with the 1.4 DIH jar file for the Clob
> Transformer. What could be causing this?
>
> Cheers
>
--
View this message in context:
http://www.nabble.com/Indexing-from-DB-connection-issue-tp23725712p23728596.html
Sent from the Solr - User mailing list archive at Nabble.com.
