Not knowing much about your specific environment, wouldn't it be easier to just do what you need to do in Java without having to use C? ------Original Message------ From: Pierre Thibault Sender: [email protected] To: [email protected] ReplyTo: General Discussion of SQLite Database Subject: Re: [sqlite] Unable to make SQLite working with Java Sent: Nov 28, 2010 20:18
Hello, I found that copying the library, libsqlite_jna.so and libsqlite_jna.la, from /usr/local/lib to /usr/lib solve the problem. I don't why but it works. :-) 2010/11/28 Pierre Thibault <[email protected]> > Hello, > > I am unable to access an sqlite file in Groovy: > > import java.sql.DriverManager > driverManager = Class.forName("java.sql.DriverManager").newInstance(); > //Class.forName("org.sqlite.JDBC").newInstance(); // SQLite.JDBCDriver > org.sqlite.JDBC > print > DriverManager.getConnection("jdbc:sqlite:/media/pierreth-backup/work/web2py/applications/welcome/databases/storage.sqlite") > > I have this error: > > Unable to load sqlite_jni: java.lang.UnsatisfiedLinkError: no sqlite_jni in > java.library.path > Caught: java.sql.SQLException: java.lang.UnsatisfiedLinkError: > SQLite.Database.internal_init()V > > But my class path is OK: > > /usr/local/share/java/sqlite.jar:/opt/java/lib/sqlitejdbc-v056.jar > > and java.library.path is /usr/local/lib where I have libsqlite_jni.so. > > Any idea? > > -- > A+ > > ------------- > Pierre > -- A+ ------------- Pierre _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ** Sent from my mobile device with the tiny keys ** Timothy A. Sawyer, CISSP Managing Director MBD Consulting, LLC 55 Madison Av., Suite 400 Morristown, NJ 07960 Phone: (973) 285-3261 | Fax: (973) 538-0503 Web: http://www.mybowlingdiary.com Email: [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

