search

tanqidong1992 / sqlite4java

Automatically exported from code.google.com/p/sqlite4java
0 stars 0 forks source link

Raspberry Pi #68

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
Problem when executing the library on my Pi.

Console Output:
pi@raspberrypi /var/sqliteTest/sqlite_lib $ java -jar sqlite4java.jar -d
sqlite4java 282
141025:112148.845 FINE [sqlite] Internal: loading library
141025:112148.861 FINE [sqlite] Internal: 
java.library.path=/usr/java/packages/lib/arm:/lib:/usr/lib
141025:112148.864 FINE [sqlite] Internal: sqlite4java.library.path=null
141025:112148.866 FINE [sqlite] Internal: cwd=/var/sqliteTest/sqlite_lib/.
141025:112148.868 FINE [sqlite] Internal: default 
path=/var/sqliteTest/sqlite_lib
141025:112148.872 FINE [sqlite] Internal: forced path=null
141025:112148.875 FINE [sqlite] Internal: os.name=linux; os=linux
141025:112148.878 FINE [sqlite] Internal: os.arch=arm
141025:112148.885 FINE [sqlite] Internal: trying to load sqlite4java-linux-arm
141025:112148.892 FINE [sqlite] Internal: cannot load sqlite4java-linux-arm: 
java.lang.UnsatisfiedLinkError: no sqlite4java-linux-arm in java.library.path
141025:112148.894 FINE [sqlite] Internal: trying to load sqlite4java-linux
141025:112148.899 FINE [sqlite] Internal: cannot load sqlite4java-linux: 
java.lang.UnsatisfiedLinkError: no sqlite4java-linux in java.library.path
141025:112148.901 FINE [sqlite] Internal: trying to load sqlite4java
141025:112148.906 FINE [sqlite] Internal: cannot load sqlite4java: 
java.lang.UnsatisfiedLinkError: no sqlite4java in java.library.path
141025:112148.908 FINE [sqlite] Internal: trying to load sqlite4java-linux-arm-d
141025:112148.913 FINE [sqlite] Internal: cannot load sqlite4java-linux-arm-d: 
java.lang.UnsatisfiedLinkError: no sqlite4java-linux-arm-d in java.library.path
141025:112148.915 FINE [sqlite] Internal: trying to load sqlite4java-linux-d
141025:112148.927 FINE [sqlite] Internal: cannot load sqlite4java-linux-d: 
java.lang.UnsatisfiedLinkError: no sqlite4java-linux-d in java.library.path
141025:112148.930 FINE [sqlite] Internal: trying to load sqlite4java-d
141025:112148.946 FINE [sqlite] Internal: cannot load sqlite4java-d: 
java.lang.UnsatisfiedLinkError: no sqlite4java-d in java.library.path
Error: cannot load SQLite
java.lang.UnsatisfiedLinkError: no sqlite4java-linux-arm in java.library.path
        at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1878)
        at java.lang.Runtime.loadLibrary0(Runtime.java:849)
        at java.lang.System.loadLibrary(System.java:1087)
        at com.almworks.sqlite4java.Internal.tryLoadFromSystemPath(Internal.java:349)
        at com.almworks.sqlite4java.Internal.loadLibraryX(Internal.java:124)
        at com.almworks.sqlite4java.SQLite.main(SQLite.java:368)
pi@raspberrypi /var/sqliteTest/sqlite_lib $

Pls fix, because its an awesome Library!

Original issue reported on code.google.com by ferdinan...@gmail.com on 25 Oct 2014 at 11:22

GoogleCodeExporter commented 9 years ago 
Same here :/

Original comment by ceisse...@gmail.com on 4 Nov 2014 at 8:15

GoogleCodeExporter commented 9 years ago 
I solved the Problem
you have to compile it on your raspberry pi, then it will work for all linux 
distributions (i dont know if all, but i tested the actual ubuntu, mint and 
debian)

Here is my native driver:
http://uploaded.net/file/zl33020r

If anyone wants an tutorial for that, just write an email :)

Original comment by ferdinan...@gmail.com on 4 Nov 2014 at 8:20

Attachments:

GoogleCodeExporter commented 9 years ago 
Hey guys - sorry about that, somehow linux/arm configuration slipped from our 
build configs :( We'll fix this soon and compile for linux/arm too.

Ferdinand - thanks for attaching your binary! Which ARM architecture is it for? 
Which compiler did you use?

Cheers
Igor

Original comment by ser...@almworks.com on 4 Nov 2014 at 8:27

GoogleCodeExporter commented 9 years ago 
I used the CodeSourcery G++ Lite 2007q3-51 for ARM GNU/Linux
http://www.codesourcery.com/sgpp/lite/arm/portal/package1787/public/arm-none-lin
ux-gnueabi/arm-2007q3-51-arm-none-linux-gnueabi-i686-pc-linux-gnu.tar.bz2 from 
your Tutorial here: 
http://sqlite4java.googlecode.com/svn/trunk/ant/how-to-cross-compile_sqlite4java
_r01.txt

I found an Stackoverflow Post 
(http://stackoverflow.com/questions/21750601/sqlite4java-on-raspberry-pi) where 
someone is offering an RELEASE file .. I just had to edit the paths to the Java 
JDK, but the build time is horrible .. about 45 mins!

Thanks for this Library! You are awesome!

Best Regards

Original comment by ferdinan...@gmail.com on 4 Nov 2014 at 8:34

Attachments:

GoogleCodeExporter commented 9 years ago 
Ferdinand - thanks for the kind words! I was interested if there's another way 
to build ARM binary. But we'll use CodeSourcery then. 

This instruction was in fact contributed by another developer using the 
library, and I wonder why it's -DARCH="ARM" for the first two .c files and 
-DARCH="i586" for the rest...

Cheers,
Igor

Original comment by ser...@almworks.com on 4 Nov 2014 at 9:01

GoogleCodeExporter commented 9 years ago 
It is possible that there are other ways and i think i found one, using 
Codeblocks, but i stopped researching after successfully build the binarys :/

Jep that is strange. I will try an build only with arm architecture and will 
report my results.

Best Regards
Ferdi

Original comment by ferdinan...@gmail.com on 4 Nov 2014 at 9:09

GoogleCodeExporter commented 9 years ago 
Hello guys, we've made a build for linux-arm ourselves (attached). May I ask 
you to try this binary and let us know if it works?

Basically, put sqlite4java.jar with this binary into some directory without 
other files and run "java -jar sqlite4java -d"

Thanks!
Igor

Original comment by ser...@almworks.com on 2 Dec 2014 at 9:44

Attachments:

GoogleCodeExporter commented 9 years ago 
Im sorry but its not working with this lib :/

pi@raspberrypi ~ $ cd /var/sqlite/
pi@raspberrypi /var/sqlite $ ls
libsqlite4java-linux-arm.so  sqlite4java.jar
pi@raspberrypi /var/sqlite $ java -jar sqlite4java.jar -d
sqlite4java 392
141203:083354.155 FINE [sqlite] Internal: loading library
141203:083354.178 FINE [sqlite] Internal: 
java.library.path=/usr/java/packages/lib/arm:/lib:/usr/lib
141203:083354.180 FINE [sqlite] Internal: sqlite4java.library.path=null
141203:083354.182 FINE [sqlite] Internal: cwd=/var/sqlite/.
141203:083354.184 FINE [sqlite] Internal: default path=/var/sqlite
141203:083354.188 FINE [sqlite] Internal: forced path=null
141203:083354.191 FINE [sqlite] Internal: os.name=linux; os=linux
141203:083354.193 FINE [sqlite] Internal: os.arch=arm
141203:083354.198 FINE [sqlite] Internal: checking 
/var/sqlite/libsqlite4java-linux-arm.so
141203:083354.201 FINE [sqlite] Internal: trying to load sqlite4java-linux-arm 
from /var/sqlite/libsqlite4java-linux-arm.so
141203:083354.209 FINE [sqlite] Internal: cannot load sqlite4java-linux-arm 
from /var/sqlite/libsqlite4java-linux-arm.so: java.lang.UnsatisfiedLinkError: 
/var/sqlite/libsqlite4java-linux-arm.so: 
/var/sqlite/libsqlite4java-linux-arm.so: Kann die Shared-Object-Datei nicht 
öffnen: Datei oder Verzeichnis nicht gefunden
141203:083354.212 FINE [sqlite] Internal: checking 
/var/sqlite/libsqlite4java-linux.so
141203:083354.214 FINE [sqlite] Internal: checking /var/sqlite/libsqlite4java.so
141203:083354.217 FINE [sqlite] Internal: checking 
/var/sqlite/libsqlite4java-linux-arm-d.so
141203:083354.219 FINE [sqlite] Internal: checking 
/var/sqlite/libsqlite4java-linux-d.so
141203:083354.222 FINE [sqlite] Internal: checking 
/var/sqlite/libsqlite4java-d.so
141203:083354.224 FINE [sqlite] Internal: trying to load sqlite4java-linux-arm
141203:083354.235 FINE [sqlite] Internal: cannot load sqlite4java-linux-arm: 
java.lang.UnsatisfiedLinkError: no sqlite4java-linux-arm in java.library.path
141203:083354.250 FINE [sqlite] Internal: trying to load sqlite4java-linux
141203:083354.255 FINE [sqlite] Internal: cannot load sqlite4java-linux: 
java.lang.UnsatisfiedLinkError: no sqlite4java-linux in java.library.path
141203:083354.257 FINE [sqlite] Internal: trying to load sqlite4java
141203:083354.261 FINE [sqlite] Internal: cannot load sqlite4java: 
java.lang.UnsatisfiedLinkError: no sqlite4java in java.library.path
141203:083354.270 FINE [sqlite] Internal: trying to load sqlite4java-linux-arm-d
141203:083354.274 FINE [sqlite] Internal: cannot load sqlite4java-linux-arm-d: 
java.lang.UnsatisfiedLinkError: no sqlite4java-linux-arm-d in java.library.path
141203:083354.277 FINE [sqlite] Internal: trying to load sqlite4java-linux-d
141203:083354.288 FINE [sqlite] Internal: cannot load sqlite4java-linux-d: 
java.lang.UnsatisfiedLinkError: no sqlite4java-linux-d in java.library.path
141203:083354.290 FINE [sqlite] Internal: trying to load sqlite4java-d
141203:083354.294 FINE [sqlite] Internal: cannot load sqlite4java-d: 
java.lang.UnsatisfiedLinkError: no sqlite4java-d in java.library.path
Error: cannot load SQLite
java.lang.UnsatisfiedLinkError: /var/sqlite/libsqlite4java-linux-arm.so: 
/var/sqlite/libsqlite4java-linux-arm.so: Kann die Shared-Object-Datei nicht 
öffnen: Datei oder Verzeichnis nicht gefunden
        at java.lang.ClassLoader$NativeLibrary.load(Native Method)
        at java.lang.ClassLoader.loadLibrary1(ClassLoader.java:1957)
        at java.lang.ClassLoader.loadLibrary0(ClassLoader.java:1882)
        at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1843)
        at java.lang.Runtime.load0(Runtime.java:795)
        at java.lang.System.load(System.java:1061)
        at com.almworks.sqlite4java.Internal.tryLoadFromPath(Internal.java:340)
        at com.almworks.sqlite4java.Internal.loadLibraryX(Internal.java:117)
        at com.almworks.sqlite4java.SQLite.main(SQLite.java:368)
pi@raspberrypi /var/sqlite $ sudo java -jar sqlite4java.jar -d
sqlite4java 392
141203:083435.658 FINE [sqlite] Internal: loading library
141203:083435.674 FINE [sqlite] Internal: 
java.library.path=/usr/java/packages/lib/arm:/lib:/usr/lib
141203:083435.676 FINE [sqlite] Internal: sqlite4java.library.path=null
141203:083435.679 FINE [sqlite] Internal: cwd=/var/sqlite/.
141203:083435.681 FINE [sqlite] Internal: default path=/var/sqlite
141203:083435.685 FINE [sqlite] Internal: forced path=null
141203:083435.688 FINE [sqlite] Internal: os.name=linux; os=linux
141203:083435.690 FINE [sqlite] Internal: os.arch=arm
141203:083435.696 FINE [sqlite] Internal: checking 
/var/sqlite/libsqlite4java-linux-arm.so
141203:083435.699 FINE [sqlite] Internal: trying to load sqlite4java-linux-arm 
from /var/sqlite/libsqlite4java-linux-arm.so
141203:083435.708 FINE [sqlite] Internal: cannot load sqlite4java-linux-arm 
from /var/sqlite/libsqlite4java-linux-arm.so: java.lang.UnsatisfiedLinkError: 
/var/sqlite/libsqlite4java-linux-arm.so: 
/var/sqlite/libsqlite4java-linux-arm.so: Kann die Shared-Object-Datei nicht 
öffnen: Datei oder Verzeichnis nicht gefunden
141203:083435.710 FINE [sqlite] Internal: checking 
/var/sqlite/libsqlite4java-linux.so
141203:083435.713 FINE [sqlite] Internal: checking /var/sqlite/libsqlite4java.so
141203:083435.715 FINE [sqlite] Internal: checking 
/var/sqlite/libsqlite4java-linux-arm-d.so
141203:083435.718 FINE [sqlite] Internal: checking 
/var/sqlite/libsqlite4java-linux-d.so
141203:083435.720 FINE [sqlite] Internal: checking 
/var/sqlite/libsqlite4java-d.so
141203:083435.722 FINE [sqlite] Internal: trying to load sqlite4java-linux-arm
141203:083435.734 FINE [sqlite] Internal: cannot load sqlite4java-linux-arm: 
java.lang.UnsatisfiedLinkError: no sqlite4java-linux-arm in java.library.path
141203:083435.740 FINE [sqlite] Internal: trying to load sqlite4java-linux
141203:083435.752 FINE [sqlite] Internal: cannot load sqlite4java-linux: 
java.lang.UnsatisfiedLinkError: no sqlite4java-linux in java.library.path
141203:083435.754 FINE [sqlite] Internal: trying to load sqlite4java
141203:083435.758 FINE [sqlite] Internal: cannot load sqlite4java: 
java.lang.UnsatisfiedLinkError: no sqlite4java in java.library.path
141203:083435.767 FINE [sqlite] Internal: trying to load sqlite4java-linux-arm-d
141203:083435.771 FINE [sqlite] Internal: cannot load sqlite4java-linux-arm-d: 
java.lang.UnsatisfiedLinkError: no sqlite4java-linux-arm-d in java.library.path
141203:083435.781 FINE [sqlite] Internal: trying to load sqlite4java-linux-d
141203:083435.784 FINE [sqlite] Internal: cannot load sqlite4java-linux-d: 
java.lang.UnsatisfiedLinkError: no sqlite4java-linux-d in java.library.path
141203:083435.790 FINE [sqlite] Internal: trying to load sqlite4java-d
141203:083435.796 FINE [sqlite] Internal: cannot load sqlite4java-d: 
java.lang.UnsatisfiedLinkError: no sqlite4java-d in java.library.path
Error: cannot load SQLite
java.lang.UnsatisfiedLinkError: /var/sqlite/libsqlite4java-linux-arm.so: 
/var/sqlite/libsqlite4java-linux-arm.so: Kann die Shared-Object-Datei nicht 
öffnen: Datei oder Verzeichnis nicht gefunden
        at java.lang.ClassLoader$NativeLibrary.load(Native Method)
        at java.lang.ClassLoader.loadLibrary1(ClassLoader.java:1957)
        at java.lang.ClassLoader.loadLibrary0(ClassLoader.java:1882)
        at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1843)
        at java.lang.Runtime.load0(Runtime.java:795)
        at java.lang.System.load(System.java:1061)
        at com.almworks.sqlite4java.Internal.tryLoadFromPath(Internal.java:340)
        at com.almworks.sqlite4java.Internal.loadLibraryX(Internal.java:117)
        at com.almworks.sqlite4java.SQLite.main(SQLite.java:368)
pi@raspberrypi /var/sqlite $

Original comment by ferdinan...@gmail.com on 3 Dec 2014 at 8:35

GoogleCodeExporter commented 9 years ago 
Due to Google closing Google Code, we have moved sqlite4java project to 
BitBucket. New project home page: 
https://bitbucket.org/almworks/sqlite4java/overview

All issues have been transferred. Unfortunately, it wasn't possible to transfer 
Reporter, Votes and Watches. Please check the issues you are interested in at 
https://bitbucket.org/almworks/sqlite4java/issues?status=new&status=open

Note that the issue tracker on Google Code is no longer tracked and any further 
comments or new issues posted here will be lost when Google Code shuts down.

I apologize for the inconvenience.
Igor Sereda

Original comment by ser...@almworks.com on 28 Jun 2015 at 4:21