Raspberry Pi

Issue #68 new

Former user created an issue 2014-10-25

Originally reported on Google Code with ID 68

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!

Reported by ferdinand.brunauer on 2014-10-25 11:22:49

Comments (10)

Former user Account Deleted
```
Same here :/
```
Reported by ceisserer on 2014-11-04 20:15:39
- 2014-11-04T20:15:39+00:00

Former user Account Deleted

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

Reported by ferdinand.brunauer on 2014-11-04 20:20:02

<hr> * Attachment: libsqlite4java-linux-arm.so

2014-11-04T20:20:02+00:00

Former user Account Deleted

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

Reported by sereda@almworks.com on 2014-11-04 20:27:53 - Status changed: Accepted

2014-11-04T20:27:53+00:00

Former user Account Deleted

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

Reported by ferdinand.brunauer on 2014-11-04 20:34:04

<hr> * Attachment: RELEASE

2014-11-04T20:34:04+00:00

Former user Account Deleted

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

Reported by sereda@almworks.com on 2014-11-04 21:01:36

2014-11-04T21:01:36+00:00

Former user Account Deleted

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

Reported by ferdinand.brunauer on 2014-11-04 21:09:50

2014-11-04T21:09:50+00:00

Former user Account Deleted

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

Reported by sereda@almworks.com on 2014-12-02 21:44:54

<hr> * Attachment: libsqlite4java-linux-arm.so

2014-12-02T21:44:54+00:00

Former user Account Deleted

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 $

Reported by ferdinand.brunauer on 2014-12-03 08:35:16

2014-12-03T08:35:16+00:00

Igor Sereda
- attached libsqlite4java-linux-arm (1).so
- attached RELEASE
- attached libsqlite4java-linux-arm (2).so
- 2015-06-28T16:26:30+00:00
Igor Sereda
- assigned issue to
  
  Jonathan Hamm
- edited description
- 2018-11-10T19:11:34+00:00
Log in to comment

Assignee: Jonathan Hamm

Type: bug

Priority: minor

Status: new

Votes: 0

Watchers: 1