#68 Raspberry Pi

[Anonymous]

Originally created by: ferdinan...@gmail.com

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!

[Anonymous]

Originally posted by: ceisse...@gmail.com

Same here :/

[Anonymous]

Originally posted by: ferdinan...@gmail.com

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 :)

[Anonymous]

Originally posted by: ser...@almworks.com

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

Status: Accepted

[Anonymous]

Originally posted by: ferdinan...@gmail.com

I used the CodeSourcery G++ Lite 2007q3-51 for ARM GNU/Linux
http://www.codesourcery.com/sgpp/lite/arm/portal/package1787/public/arm-none-linux-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

[Anonymous]

Originally posted by: ser...@almworks.com

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

[Anonymous]

Originally posted by: ferdinan...@gmail.com

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

[Anonymous]

Originally posted by: ser...@almworks.com

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

[Anonymous]

Originally posted by: ferdinan...@gmail.com

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 $