PhidgetSBC3 jdbc -> sqlite driver problems

Supporting Java SE version 7 and up
jasonbrice
Fresh meat
Posts: 2
Joined: Fri Jun 12, 2015 8:43 am
Contact:

PhidgetSBC3 jdbc -> sqlite driver problems

Postby jasonbrice » Fri Jun 12, 2015 9:44 am

I've got a pretty simple java test program that creates a local sqlite database and writes some data to it (essentially the sample code for the Xerial driver here: https://github.com/xerial/sqlite-jdbc).

On Windows, it runs fine. On the PhidgetSBC3, it crashes the Java application.

It seems that there is not currently a working implementation of a JDBC SQLite driver for the ARM architecture... I've tried using all implementations of JDBC/SQLite I can find, and always get some variation of a hard crash, or an unsatisfied link exception (looking for some version of a native sqlite.so library).

Has anyone successfully written to a SQLite database from Java using this device?

jasonbrice
Fresh meat
Posts: 2
Joined: Fri Jun 12, 2015 8:43 am
Contact:

Re: PhidgetSBC3 jdbc -> sqlite driver problems

Postby jasonbrice » Tue Jun 16, 2015 3:56 pm

The issue is apparently that many (all?) of the "Java" jdbc projects out there are really thin wrappers over native libraries. Because Xerial (and others) don't reference the correct native library for SQLite (which, I believe, on a phidgets SBC gets stored at /usr/lib/arm-linux-gnueabi/libsqlite3.so.0.8.6).

So the whole thing crashes. Ugh.

I've logged an issue here --> https://github.com/xerial/sqlite-jdbc/issues/38. And asked a SO question here --> http://stackoverflow.com/questions/30807728/how-can-i-connect-to-a-sqlite-data-source-using-jdbc-on-debian-arm.

At some point I will attempt my own Phigets SBC-specific JDBC library... in the meantime plz reply if anyone figures out a more practical solution...


Return to “Java”

Who is online

Users browsing this forum: No registered users and 1 guest