Hello Erik,
Yes, the drivers are there.
I forgot to mention, this DB indexing was working before on the server when
the DB was using a different schema.
The schema has changed, so I did all my testing on my local machine. When I
saw that it worked fine, I put in the new connection string/user/pass and
tried it on the server...
Erik Hatcher wrote:
>
> 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.
>
>
>
--
View this message in context:
http://www.nabble.com/Indexing-from-DB-connection-issue-tp23725712p23727121.html
Sent from the Solr - User mailing list archive at Nabble.com.
