Re: sqlite4java Raspberry Pi

[Robinson Mesino]

Hi guys,

I get the solution.

1) Download file libsqlite4java-linux-armv5te.so

2) Rename to libsqlite4java-linux-arm.so

3) Ready to use, work OK

root@raspberrypi:~/sqlite4java# java -jar sqlite4java.jar -d

sqlite4java 282

130411:220826.626 FINE [sqlite] Internal: loading library

130411:220826.644 FINE [sqlite] Internal: java.library.path=/usr/java/packages/lib/arm:/lib:/usr/lib

130411:220826.646 FINE [sqlite] Internal: sqlite4java.library.path=null

130411:220826.650 FINE [sqlite] Internal: cwd=/root/sqlite4java/.

130411:220826.653 FINE [sqlite] Internal: default path=/root/sqlite4java

130411:220826.656 FINE [sqlite] Internal: forced path=null

130411:220826.660 FINE [sqlite] Internal: os.name=linux; os=linux

130411:220826.663 FINE [sqlite] Internal: os.arch=arm

130411:220826.670 FINE [sqlite] Internal: trying to load sqlite4java-linux-arm from /root/sqlite4java/libsqlite4java-linux-arm.so

130411:220826.677 INFO [sqlite] Internal: loaded sqlite4java-linux-arm from /root/sqlite4java/libsqlite4java-linux-arm.so

130411:220826.706 INFO [sqlite] Internal: loaded sqlite 3.7.10, wrapper 0.2

SQLite 3.7.10

Compile-time options: ENABLE_COLUMN_METADATA ENABLE_FTS3 ENABLE_FTS3_PARENTHESIS ENABLE_MEMORY_MANAGEMENT OMIT_DEPRECATED OMIT_LOAD_EXTENSION TEMP_STORE=1 THREADSAFE=1

El jueves, 11 de abril de 2013 12:06:48 UTC-5, Robinson Mesino escribió:

Hi guys,

Exists some version for raspberry pi (.so)??

[ser...@almworks.com]

Hi Robinson,

 

Awesome, thanks for sharing!

 

Igor

--
You received this message because you are subscribed to the Google Groups "sqlite4java" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sqlite4java...@googlegroups.com.
To post to this group, send email to sqlit...@googlegroups.com.
Visit this group at http://groups.google.com/group/sqlite4java?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

[crea...@gmail.com]

Thanks for your possible solution. But it doesnt work with my application.

Here is the output of "java -jar libsqlite4java.jar -d":

pi@raspberrypi ~/targad $ java -jar sqlite4java.jar -d
sqlite4java 282
130913:191155.467 FINE [sqlite] Internal: loading library
130913:191155.484 FINE [sqlite] Internal: java.library.path=/usr/java/packages/lib/arm:/usr/lib/arm-linux-gnueabihf/jni:/lib/arm-linux-gnueabihf:/usr/lib/arm-linux-gnueabihf:/usr/lib/jni:/lib:/usr/lib
130913:191155.488 FINE [sqlite] Internal: sqlite4java.library.path=null
130913:191155.491 FINE [sqlite] Internal: cwd=/home/pi/targad/.
130913:191155.494 FINE [sqlite] Internal: default path=/home/pi/targad
130913:191155.497 FINE [sqlite] Internal: forced path=null
130913:191155.501 FINE [sqlite] Internal: os.name=linux; os=linux
130913:191155.504 FINE [sqlite] Internal: os.arch=arm
130913:191155.513 FINE [sqlite] Internal: trying to load sqlite4java-linux-arm from /home/pi/targad/libsqlite4java-linux-arm.so
130913:191155.520 FINE [sqlite] Internal: cannot load sqlite4java-linux-arm from /home/pi/targad/libsqlite4java-linux-arm.so: java.lang.UnsatisfiedLinkError: /home/pi/targad/libsqlite4java-linux-arm.so: /home/pi/targad/libsqlite4java-linux-arm.so: cannot open shared object file: No such file or directory
130913:191155.526 FINE [sqlite] Internal: trying to load sqlite4java-linux-arm
130913:191155.536 FINE [sqlite] Internal: cannot load sqlite4java-linux-arm: java.lang.UnsatisfiedLinkError: no sqlite4java-linux-arm in java.library.path
130913:191155.539 FINE [sqlite] Internal: trying to load sqlite4java-linux
130913:191155.547 FINE [sqlite] Internal: cannot load sqlite4java-linux: java.lang.UnsatisfiedLinkError: no sqlite4java-linux in java.library.path
130913:191155.550 FINE [sqlite] Internal: trying to load sqlite4java
130913:191155.558 FINE [sqlite] Internal: cannot load sqlite4java: java.lang.UnsatisfiedLinkError: no sqlite4java in java.library.path
130913:191155.561 FINE [sqlite] Internal: trying to load sqlite4java-linux-arm-d
130913:191155.569 FINE [sqlite] Internal: cannot load sqlite4java-linux-arm-d: java.lang.UnsatisfiedLinkError: no sqlite4java-linux-arm-d in java.library.path
130913:191155.572 FINE [sqlite] Internal: trying to load sqlite4java-linux-d
130913:191155.580 FINE [sqlite] Internal: cannot load sqlite4java-linux-d: java.lang.UnsatisfiedLinkError: no sqlite4java-linux-d in java.library.path
130913:191155.583 FINE [sqlite] Internal: trying to load sqlite4java-d
130913:191155.591 FINE [sqlite] Internal: cannot load sqlite4java-d: java.lang.UnsatisfiedLinkError: no sqlite4java-d in java.library.path
Error: cannot load SQLite
java.lang.UnsatisfiedLinkError: /home/pi/targad/libsqlite4java-linux-arm.so: /home/pi/targad/libsqlite4java-linux-arm.so: cannot open shared object file: No such file or directory
        at java.lang.ClassLoader$NativeLibrary.load(Native Method)
        at java.lang.ClassLoader.loadLibrary1(ClassLoader.java:1935)
        at java.lang.ClassLoader.loadLibrary0(ClassLoader.java:1860)
        at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1821)
        at java.lang.Runtime.load0(Runtime.java:792)
        at java.lang.System.load(System.java:1059)
        at com.almworks.sqlite4java.Internal.tryLoadFromPath(Internal.java:337)
        at com.almworks.sqlite4java.Internal.loadLibraryX(Internal.java:117)
        at com.almworks.sqlite4java.SQLite.main(SQLite.java:368)

But the file /home/pi/targad/libsqlite4java-linux-arm.so exists and is originally the libsqlite4java-linux-armv5te.so.

Maybe this could also be helpful:

pi@raspberrypi ~/targad $ file /home/pi/targad/libsqlite4java-linux-arm.so
/home/pi/targad/libsqlite4java-linux-arm.so: ELF 32-bit LSB shared object, ARM, version 1 (SYSV), dynamically linked, stripped

The owner of the file is pi - so there shouldnt be some problems with the chmod or so... I already googled but couldnt find something that could help me.

[are...@gmail.com]

Same here.

I'm using  Oracle ejre.

Arek Marud

[dbu...@gmail.com]

Same issue.

Ugly hack for the moment:

//exe = "sqlite3"

//db = "my.db"

//script = "INSERT INTO MY_TABLE values (...)"

               

final String[] cmd = {exe, db, script};

final Process process = Runtime.getRuntime().exec(cmd);

int exit =  process.waitFor();

if (exit != 0) {

    // Something failed
}

[darren.g...@gmail.com]

I am facing this exact problem, not sure i understand the "hack"

Can someone please help?