Hi
I need to install a tool in Redhat Linux which needs PHP, Java and Sqlite. Here PHP is the front-end and Java is the backend server with Sqlite database. I set everything and completed installation almost. Now server started, I can able to access front-end very well. But some php files are not working properly which are java database related and giving error message as:

[root@localhost mail_java3]# Unable to load sqlite: java.lang.UnsatisfiedLinkError: no sqlite_jni in java.library.path
java.sql.SQLException: java.lang.UnsatisfiedLinkError: open
at SQLite.JDBCDriver.connect(JDBCDriver.java:61)
at java.sql.DriverManager.getConnection(DriverManager .java:525)
at java.sql.DriverManager.getConnection(DriverManager .java:193)
at com.attract.imail3.datamodel.sqlite.listmngr.ListD atabase.createNewListDatabase(ListDatabase.java:52 4)
at com.attract.imail3.datamodel.sqlite.listmngr.ListD atabase.serviceCREATELIST(ListDatabase.java:571)
at com.attract.imail3.IMT3Server.serviceDirect(IMT3Se rver.java:248)
at com.attract.util.jnetdaemon.JDaemonController.main (JDaemonController.java:142)

I downloaded sqlite_jni linux amd64 (64bit) v1.tar file and sqlitejdbc-v056 file. Can anyone please tell me how to work with these two files i.e where to place these files and how to set path. I am new to Linux and Java.


R.Sridaran

You need to add the file to the Java library path. There are many documents that you can easily find on Google, explaining how to do this. For example, you can either specify the class library location when you're calling the module. Try copying the file into /usr/lib, or (better), edit the /etc/ld.so.conf file to add the directory with your new Java library, then run (as root) "ldconfig".

1 members found this post helpful.

# 'yum install javasqlite' will provide :
/usr/lib/javasqlite/libsqlite_jni.so
/usr/lib/javasqlite/sqlite.jar

Could that be, what you are looking for ?

'javasqlite' is in the epel.repo https://fedoraproject.org/wiki/EPEL
https://fedoraproject.org/wiki/EPEL/FAQ#howtouse

..

Thank you very much. I downloaded sqlitejdbc-v056.jar, sqlite_jni linux x86 (32bit) v1.tar.bz2 files and copied inside /usr/local/lib. In bash-profile file I set path like:

PATH=$PATH:/usr/java/jdk1.5.0_22/bin:$PATH:/usr/local/lib/sqlite.jar:$PATH:/usr/local/lib/sqlitejdbc-v056.jar:$PATH:/usr/local/lib/libsqlite_jni.so
export PATH

I restarted the server and got the following error:

Unable to load sqlite: java.lang.UnsatisfiedLinkError: /usr/local/lib/libsqlite_jni.so: /lib/i686/nosegneg/libc.so.6: version `GLIBC_2.7' not found (required by /usr/local/lib/libsqlite_jni.so)
java.sql.SQLException: java.lang.UnsatisfiedLinkError: open
at SQLite.JDBCDriver.connect(JDBCDriver.java:61)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:193)
at com.attract.imail3.datamodel.sqlite.listmngr.ListDatabase.createNewListDatabase(ListDatabase.java:52 4)
at com.attract.imail3.datamodel.sqlite.listmngr.ListDatabase.serviceCREATELIST(ListDatabase.java:571)
at com.attract.imail3.IMT3Server.serviceDirect(IMT3Server.java:248)
at com.attract.util.jnetdaemon.JDaemonController.main(JDaemonController.java:142)

How to solve this error?


R.Sridaran

It's a wrong version, meant for a later Linux.


The correct package : See post # 3 : javasqlite , el.5
wget http://download.fedora.redhat.com/pu...el5.1.i386.rpm
> > javasqlite-20090430-1.el5.1.i386.rpm

..

1 members found this post helpful.

Thank you very much. I downloaded javasqlite-20090430-1.el5.1.i386.rpm from the url you mentioned. After installing I got libsqlite_jni.so and sqlite.jar file in /usr/lib folder. I copied to /usr/local/lib folder and set path in my bash-profile file. Now "no sqlite_jni in java.library.path" error was solved and am getting only the following error:

[root@localhost imailtract_java3]# java.sql.SQLException: java.lang.UnsatisfiedLinkError: open
at SQLite.JDBCDriver.connect(JDBCDriver.java:61)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:193)
at com.attract.imail3.datamodel.sqlite.listmngr.ListDatabase.createNewListDatabase(ListDatabase.java:52 4)
at com.attract.imail3.datamodel.sqlite.listmngr.ListDatabase.serviceCREATELIST(ListDatabase.java:571)
at com.attract.imail3.IMT3Server.serviceDirect(IMT3Server.java:248)
at com.attract.util.jnetdaemon.JDaemonController.main(JDaemonController.java:142)


I tried
sqlitejdbc-v056.jar
sqlitejdbc-v054.jar
sqlitejdbc-v056-pure.jar
sqlitejdbc-v055-pure.jar
sqlite-jdbc-3.7.2.jar

Can you please tell me a jdbc jar file to solve this error.


R.Sridaran

javasqlite-20090430-1.el5.1.i386.rpm provides :
/usr/lib/javasqlite/libsqlite_jni.so
/usr/lib/javasqlite/sqlite.jar

.. which is what you get with a normal install method : yum or rpm commands :
I.e. # rpm -Uvh javasqlite-20090430-1.el5.1.i386.rpm


The default location for the most '.jar' files is /usr/share/java/,
which is already in the standard 'java' search path.
That's where I would put the sqlitejdbc-vXX.jar .
And then create a link : 1) cd /usr/share/java/ && su ;
2) ln -s sqlitejdbc-vXX.jar sqlitejdbc.jar

But why not tell, which tool, you are trying to use.
May be I can find the correct solution for the sqlitejdbc.jar ?
..

1 members found this post helpful.

Thank you very much. Actually my tool is about IMailTract, Email Newsletter and Campaign Management application. IMailTract can handle huge volumes of personalized email, track responses to mail (opened, clicked, Lead/Sale) and allow advertiser to run campaigns based on response. For installing this tool we need Linux OS, Java, PHP, Sqlite. In this PHP is the front-end, Java is the back-end server with Sqlite database. I installed everything. Server also started running.Front-end is working fine.Database connected with front-end(PHP) since I can able to see folders that I create in database as drop down list in the front-end. But if I create any folders in front-end using create button this error(SQLException, Unsatisfied Link Error) is coming. Also for campaign creation, if I click create-campaign button it is asking campaign name. After giving the name it is displaying message "campaign created successfully". But no campaigns in the list. I thought this is the connection problem between Java and Sqlite.

I followed your last instruction also but still the same error exists. Actually I don't know Linux, Java. Also this tool was used five years back with old versions. Now I am using new version softwares. By modifying configuration files and referring the net I completed this installation upto this level. Only this error needs to be solved. Please tell me the suitable sqlitejdbc.jar file.


R.Sridaran

Please provide direct links to the application(s) in question.

..

Sorry...I, for one, will not help someone send spam. Thread reported.