You are viewing a plain text version of this content. The canonical link for it is here.
Posted to solr-user@lucene.apache.org by "Radha C." <cr...@ceiindia.com> on 2009/04/02 15:27:39 UTC

Error in Importing from Oracle

Hello List,
 
I am trying to do full import from remote oracle server. I am getting the
below error, 
 
Can anyone please help me what configuration I am missing?  Thanks in
advance.
 
Apr 2, 2009 6:46:39 PM org.apache.solr.handler.dataimport.DataImporter
doFullImport
SEVERE: Full Import failed
org.apache.solr.handler.dataimport.DataImportHandlerException:
java.lang.UnsatisfiedLinkError: no ocijdbc10 in java.library.path
        at
org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:
402)
        at
org.apache.solr.handler.dataimport.DocBuilder.doFullDump(DocBuilder.java:225
)
        at
org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:167)
        at
org.apache.solr.handler.dataimport.DataImporter.doFullImport(DataImporter.ja
va:323)
        at
org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:381
)
        at
org.apache.solr.handler.dataimport.DataImporter$1.run(DataImporter.java:362)
Caused by: java.lang.UnsatisfiedLinkError: no ocijdbc10 in java.library.path
        at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1682)
        at java.lang.Runtime.loadLibrary0(Runtime.java:822)
        at java.lang.System.loadLibrary(System.java:992)
        at oracle.jdbc.driver.T2CConnection$1.run(T2CConnection.java:3135)
        at java.security.AccessController.doPrivileged(Native Method)
        at
oracle.jdbc.driver.T2CConnection.loadNativeLibrary(T2CConnection.java:3131)
        at oracle.jdbc.driver.T2CConnection.logon(T2CConnection.java:221)
        at
oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:414)
        at oracle.jdbc.driver.T2CConnection.<init>(T2CConnection.java:132)
        at
oracle.jdbc.driver.T2CDriverExtension.getConnection(T2CDriverExtension.java:
78)
        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
        at java.sql.DriverManager.getConnection(DriverManager.java:525)
        at java.sql.DriverManager.getConnection(DriverManager.java:140)
        at
org.apache.solr.handler.dataimport.JdbcDataSource$1.call(JdbcDataSource.java
:126)
        at
org.apache.solr.handler.dataimport.JdbcDataSource$1.call(JdbcDataSource.java
:119)
        at
org.apache.solr.handler.dataimport.JdbcDataSource.getConnection(JdbcDataSour
ce.java:325)
        at
org.apache.solr.handler.dataimport.JdbcDataSource.access$200(JdbcDataSource.
java:37)
        at
org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.<init>(J
dbcDataSource.java:201)
 


RE: Error in Importing from Oracle

Posted by "Radha C." <cr...@ceiindia.com>.
Thanks guys,

I used pure java driver. That works. 

-----Original Message-----
From: Noble Paul നോബിള്‍ नोब्ळ् [mailto:noble.paul@gmail.com] 
Sent: Friday, April 03, 2009 8:59 AM
To: solr-user@lucene.apache.org
Subject: Re: Error in Importing from Oracle

put your native dll/iso file in the LD_LIBRARY_PATH and start Solr with that. Or the  best solution is to use a pure java driver

On Thu, Apr 2, 2009 at 8:13 PM, Shalin Shekhar Mangar <sh...@gmail.com> wrote:
> On Thu, Apr 2, 2009 at 6:57 PM, Radha C. <cr...@ceiindia.com> wrote:
>> Hello List,
>>
>> I am trying to do full import from remote oracle server. I am getting 
>> the below error,
>>
>> Can anyone please help me what configuration I am missing?  Thanks in 
>> advance.
>>
>> Apr 2, 2009 6:46:39 PM 
>> org.apache.solr.handler.dataimport.DataImporter
>> doFullImport
>> SEVERE: Full Import failed
>> org.apache.solr.handler.dataimport.DataImportHandlerException:
>> java.lang.UnsatisfiedLinkError: no ocijdbc10 in java.library.path
>>
>
> It looks like your Oracle jdbc driver depends on some native code 
> libraries which are missing in your environment. I suggest that you 
> look in the documentation of the jdbc driver. However, I'm quite 
> certain that there exists a pure java jdbc driver for Oracle too.
>
> --
> Regards,
> Shalin Shekhar Mangar.
>



--
--Noble Paul


Re: Error in Importing from Oracle

Posted by Noble Paul നോബിള്‍ नोब्ळ् <no...@gmail.com>.
put your native dll/iso file in the LD_LIBRARY_PATH and start Solr
with that. Or the  best solution is to use a pure java driver

On Thu, Apr 2, 2009 at 8:13 PM, Shalin Shekhar Mangar
<sh...@gmail.com> wrote:
> On Thu, Apr 2, 2009 at 6:57 PM, Radha C. <cr...@ceiindia.com> wrote:
>> Hello List,
>>
>> I am trying to do full import from remote oracle server. I am getting the
>> below error,
>>
>> Can anyone please help me what configuration I am missing?  Thanks in
>> advance.
>>
>> Apr 2, 2009 6:46:39 PM org.apache.solr.handler.dataimport.DataImporter
>> doFullImport
>> SEVERE: Full Import failed
>> org.apache.solr.handler.dataimport.DataImportHandlerException:
>> java.lang.UnsatisfiedLinkError: no ocijdbc10 in java.library.path
>>
>
> It looks like your Oracle jdbc driver depends on some native code
> libraries which are missing in your environment. I suggest that you
> look in the documentation of the jdbc driver. However, I'm quite
> certain that there exists a pure java jdbc driver for Oracle too.
>
> --
> Regards,
> Shalin Shekhar Mangar.
>



-- 
--Noble Paul

Re: Error in Importing from Oracle

Posted by Shalin Shekhar Mangar <sh...@gmail.com>.
On Thu, Apr 2, 2009 at 6:57 PM, Radha C. <cr...@ceiindia.com> wrote:
> Hello List,
>
> I am trying to do full import from remote oracle server. I am getting the
> below error,
>
> Can anyone please help me what configuration I am missing?  Thanks in
> advance.
>
> Apr 2, 2009 6:46:39 PM org.apache.solr.handler.dataimport.DataImporter
> doFullImport
> SEVERE: Full Import failed
> org.apache.solr.handler.dataimport.DataImportHandlerException:
> java.lang.UnsatisfiedLinkError: no ocijdbc10 in java.library.path
>

It looks like your Oracle jdbc driver depends on some native code
libraries which are missing in your environment. I suggest that you
look in the documentation of the jdbc driver. However, I'm quite
certain that there exists a pure java jdbc driver for Oracle too.

-- 
Regards,
Shalin Shekhar Mangar.