Re: Indexing from DB connection issue

Tue, 26 May 2009 08:41:57 -0700 

Did you move the Oracle JDBC driver to the other machine also?

        Erik

On May 26, 2009, at 11:37 AM, 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-tp23725712p23725712.html
Sent from the Solr - User mailing list archive at Nabble.com.

Reply via email to