Hello,
i'm trying to load new SQL functions from a shared library with the
help of the SQLite Java
Wrapper/JDBC Driver (http://www.ch-werner.de/javasqlite). I'm trying
java -cp :. -Djava.library.path=/tmp/javasqlite-20090213/.libs
SQLite.Shell db "select
load_extension('/tmp/spatialite-2.2-linux-x86-libs/lib/libspatialite.so')"
I get the following SQL Error:
SQL Error: SQLite.Exception: not authorized
Same error in the small test program
(http://www.ch-werner.de/javasqlite/test.java) i ve added the
following line:
db.exec("select
load_extension('/tmp/spatialite-2.2-linux-x86-libs/lib/libspatialite.so')",new
test());
The following statements are fully working in sqlite:
sqlite> select
load_extension('/tmp/spatialite-2.2-linux-x86-libs/lib/libspatialite.so');
sqlite> .load /tmp/spatialite-2.2-linux-x86-libs/lib/libspatialite.so
Did I misunderstood something? Did i trying something which is not
provided by the SQLite Java
Wrapper/JDBC Driver?
I would be happy, if anyone can give me some tips. Is there a separate
mailing list for SQLite Java
Wrapper/JDBC Driver? I didn't find any. Should I contact the author directly?
bejay
Background:
-----------
javasqlite-20090213
Sqlite-LIB version: 3.6.11
Sqlite-DB version: 3.6.11
java version "1.6.0_12"
Java(TM) SE Runtime Environment (build 1.6.0_12-b04)
Java HotSpot(TM) Server VM (build 11.2-b01, mixed mode)
Running on a GNU\Linux Debian Lenny.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
