You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@tika.apache.org by Bradley Beach <be...@us.ibm.com> on 2020/04/20 22:20:53 UTC

WARNING: org.xerial's sqlite-jdbc is not loaded for 1.2.4

Dear friends,



I am a first time user of tika and am having issues getting sqlite-jdbc
loaded. I understand that it is "provided."



I have tried every permutation of adding sqlite-jdbc-3.30.1.jar to my
classpath but still get:



java -classpath ".:sqlite-jdbc-3.30.1.jar" -jar tika-server-1.24.jar
--host=localhost --port=12345

Apr 20, 2020 6:17:57 PM org.apache.tika.config.InitializableProblemHandler$3
handleInitializableProblem

WARNING: org.xerial's sqlite-jdbc is not loaded.  
Please provide the jar on your classpath to parse sqlite files.  
See tika-parsers/pom.xml for the correct version.



I am on a Mac, running Catalina, with tika 1.2.4 (and I tried 1.2.4.1).



I have tried:

java -Djava.class.path=.:sqlite-jdbc-3.30.1.jar -jar tika-server-1.24.1.jar
--host=localhost --port=12345

java -cp ".:sqlite-jdbc-3.30.1.jar" -jar tika-server-1.24.jar --host=localhost
--port=12345



I have looked at tika-parsers/pom.xml  and it shows sqlite-jdbc 3.30.1 is
required.

I dont want to exclude it in the tika-config.xml, as I need it for parsing
.shp/.dbf file.



Any guidance would be great.



Thanks

**E-mail:** [ beachb@us.ibm.com](mailto:beachb@us.ibm.com)

  


RE: WARNING: org.xerial's sqlite-jdbc is not loaded for 1.2.4

Posted by Bradley Beach <be...@us.ibm.com>.
Nick/Tim,



From  <https://github.com/chrismattmann/tika-python> tika-python uses
TIKA_SERVER_CLASSPATH



If you were looking to help us newbies... maybe an example of downloading
sqlite-(version).jar (or any parser labeled as "Provided") to
TIKA_SERVER_CLASSPATH and executing:



java -cp "$TIKA_SERVER_CLASSPATH" org.apache.tika.server.TikaServerCli
--host=localhost --port=12345 --config=./tika-config.xml



A good place to put the note/example could be
<https://tika.apache.org/1.24/configuring.html#Configuring_Parsers>



Thanks again for your help

**Regards,**  
  
 **BRAD**





> \----- Original message -----  
> From: Nick Burch <ap...@gagravarr.org>  
> To: Tim Allison <ta...@apache.org>  
> Cc: user@tika.apache.org  
> Subject: [EXTERNAL] Re: WARNING: org.xerial's sqlite-jdbc is not loaded for
1.2.4  
> Date: Wed, Apr 22, 2020 7:34 AM  
>  
>

> On Wed, 22 Apr 2020, Tim Allison wrote:  
> > Y. Agreed. Where should we document this? Where would you look for it?  
>  
> The Tika Server and Tika App both get a fair bit of use from non-Java devs  
>  
> Maybe we need a quickstart for non-Java folks section, and probably a  
> python-specific one as we get loads of queries from newbies on that front  
> who we want to help!  
>  
> Nick  
>  



  


Re: WARNING: org.xerial's sqlite-jdbc is not loaded for 1.2.4

Posted by Nick Burch <ap...@gagravarr.org>.
On Wed, 22 Apr 2020, Tim Allison wrote:
> Y. Agreed. Where should we document this? Where would you look for it?

The Tika Server and Tika App both get a fair bit of use from non-Java devs

Maybe we need a quickstart for non-Java folks section, and probably a 
python-specific one as we get loads of queries from newbies on that front 
who we want to help!

Nick

Re: WARNING: org.xerial's sqlite-jdbc is not loaded for 1.2.4

Posted by Tim Allison <ta...@apache.org>.
Y. Agreed. Where should we document this? Where would you look for it?

On Tue, Apr 21, 2020 at 9:03 AM Bradley Beach <be...@us.ibm.com> wrote:

> Thank you Tim for the detail. It is working now. Sorry for the simple
> question. I couldn't seem to find it in any of the Tika docs.
> *Regards,*
>
> *BRAD BEACH*
>
>
> ----- Original message -----
> From: Tim Allison <ta...@apache.org>
> To: user@tika.apache.org
> Cc:
> Subject: [EXTERNAL] Re: WARNING: org.xerial's sqlite-jdbc is not loaded
> for 1.2.4
> Date: Tue, Apr 21, 2020 8:53 AM
>
> Agreed.
>
> I typically put the tika-server.jar and the other jars in a bin directory
> and then run `java -cp "bin/*" org.apache.tika.server.TikaServerCli
> ----options`
>
> On Tue, Apr 21, 2020 at 8:15 AM Nick Burch <ap...@gagravarr.org> wrote:
>
> On Mon, 20 Apr 2020, Bradley Beach wrote:
> > I have tried every permutation of adding sqlite-jdbc-3.30.1.jar to my
> > classpath but still get:
> >
> > java -classpath ".:sqlite-jdbc-3.30.1.jar" -jar tika-server-1.24.jar
> > --host=localhost --port=12345
>
> You can't combine -classpath and -jar, you have to use one or the other.
> If you give -jar then -classpath is ignored...
>
> Nick
>
>
>
>

RE: WARNING: org.xerial's sqlite-jdbc is not loaded for 1.2.4

Posted by Bradley Beach <be...@us.ibm.com>.
Thank you Tim for the detail. It is working now. Sorry for the simple
question. I couldn't seem to find it in any of the Tika docs.

**Regards,**  
  
 **BRAD BEACH**



> \----- Original message -----  
> From: Tim Allison <ta...@apache.org>  
> To: user@tika.apache.org  
> Cc:  
> Subject: [EXTERNAL] Re: WARNING: org.xerial's sqlite-jdbc is not loaded for
1.2.4  
> Date: Tue, Apr 21, 2020 8:53 AM  
>  
>

> Agreed.

>

>  
>

> I typically put the tika-server.jar and the other jars in a bin directory
and then run `java -cp "bin/*" org.apache.tika.server.TikaServerCli
----options`

>

>  
>

> On Tue, Apr 21, 2020 at 8:15 AM Nick Burch
<[apache@gagravarr.org](mailto:apache@gagravarr.org)> wrote:

>

>> On Mon, 20 Apr 2020, Bradley Beach wrote:  
> > I have tried every permutation of adding sqlite-jdbc-3.30.1.jar to my  
> > classpath but still get:  
> >  
> > java -classpath ".:sqlite-jdbc-3.30.1.jar" -jar tika-server-1.24.jar  
> > \--host=localhost --port=12345  
>  
> You can't combine -classpath and -jar, you have to use one or the other.  
> If you give -jar then -classpath is ignored...  
>  
> Nick



  


Re: WARNING: org.xerial's sqlite-jdbc is not loaded for 1.2.4

Posted by Tim Allison <ta...@apache.org>.
Agreed.

I typically put the tika-server.jar and the other jars in a bin directory
and then run `java -cp "bin/*" org.apache.tika.server.TikaServerCli
----options`

On Tue, Apr 21, 2020 at 8:15 AM Nick Burch <ap...@gagravarr.org> wrote:

> On Mon, 20 Apr 2020, Bradley Beach wrote:
> > I have tried every permutation of adding sqlite-jdbc-3.30.1.jar to my
> > classpath but still get:
> >
> > java -classpath ".:sqlite-jdbc-3.30.1.jar" -jar tika-server-1.24.jar
> > --host=localhost --port=12345
>
> You can't combine -classpath and -jar, you have to use one or the other.
> If you give -jar then -classpath is ignored...
>
> Nick

Re: WARNING: org.xerial's sqlite-jdbc is not loaded for 1.2.4

Posted by Nick Burch <ap...@gagravarr.org>.
On Mon, 20 Apr 2020, Bradley Beach wrote:
> I have tried every permutation of adding sqlite-jdbc-3.30.1.jar to my
> classpath but still get:
>  
> java -classpath ".:sqlite-jdbc-3.30.1.jar" -jar tika-server-1.24.jar
> --host=localhost --port=12345

You can't combine -classpath and -jar, you have to use one or the other. 
If you give -jar then -classpath is ignored...

Nick