Using sqlite with Java on raspberry pi

Question

I created a small sqlite database code in java.

Below is the database connection code,

Class.forName("org.sqlite.JDBC");

objConnection=DriverManager.getConnection("jdbc:sqlite:/etc/javaData/Test.db");

In this code, an exception is thrown in the second line for getConnection (). I am trying to use this code for raspberry pi. How to fix the exception associated with this

An exception

SQLITE addDeviceInfo()-[SQLITE] SQL Exception occured. RetryCount:1 (MAX Retry: 2) ErrorCode: 27154 Exception Message: Error opening connection Stack Trace: java.sql.SQLException: Error opening connection
  at org.sqlite.core.CoreConnection.open(CoreConnection.java:140)
  at org.sqlite.core.CoreConnection.<init>(CoreConnection.java:66)
  at org.sqlite.jdbc3.JDBC3Connection.<init>(JDBC3Connection.java:21)
  at org.sqlite.jdbc4.JDBC4Connection.<init>(JDBC4Connection.java:23)
  at org.sqlite.SQLiteConnection.<init>(SQLiteConnection.java:45)
  at org.sqlite.JDBC.createConnection(JDBC.java:114)
  at org.sqlite.JDBC.connect(JDBC.java:88)
  at java.sql.DriverManager.getConnection(DriverManager.java:571)
  at java.sql.DriverManager.getConnection(DriverManager.java:215)
  at kmbt.DCA.SQLite.DCASQLiteUtility.getSQliteConnection(DCASQLiteUtility.java:152)
  at kmbt.DCA.SQLite.ManagedDeviceSetting.SQLite_ManagedDeviceSettingManager.addDeviceInfo(SQLite_ManagedDeviceSettingManager.java:981)
  at kmbt.DCA.DCAChildProcessMng.InitManagedDeviceInfo(DCAChildProcessMng.java:5726)
  at kmbt.DCA.DCAChildProcessMng.InitSQLite(DCAChildProcessMng.java:4387)
  at kmbt.DCA.DCAChildProcessMng.start(DCAChildProcessMng.java:365)
  at kmbt.DCA.DCAChildProcess.main(DCAChildProcess.java:23)
 Caused by: java.lang.Exception: Error loading native library: /org/sqlite/native/Linux/arm/libsqlitejdbc.so
  at org.sqlite.SQLiteJDBCLoader.loadSQLiteNativeLibrary(SQLiteJDBCLoader.java:243)  at org.sqlite.SQLiteJDBCLoader.initialize(SQLiteJDBCLoader.java:65)
  at org.sqlite.core.NativeDB.load(NativeDB.java:53)
  at org.sqlite.core.CoreConnection.open(CoreConnection.java:136)
  ... 14 more

Answer 1

, , , - . , , , /etc. , /etc , . , , - r/w. , , root.

, .

- EDIT -

, , :

Error loading native library: /org/sqlite/native/Linux/arm/libsqlitejdbc.so

ARM- sqlite. : SQLite pi : Sqlite4java Pi

Answer 2

java.lang.Exception: Error loading native library: /org/sqlite/native/Linux/arm/libsqlitejdbc.so

sqlite-jdbc-3.8.6.jar, , /org/sqlite/native/Linux/ arm folder → sqlite .

pi: https://bitbucket.org/kidmose/sqlite-jdbc/commits/cb7a7ef62c034938e8ecb737b148e5c80877c083

pi@raspberry ~/sqlite-jdbc $ export JAVA_HOME=/usr/lib/jvm/jdk-7-oracle-armhf/
pi@raspberry ~/sqlite-jdbc $ chmod 755 ./amalgamation_version.sh
pi@raspberry ~/sqlite-jdbc $ make

.

: https://pidome.wordpress.com/2013/10/01/java-goes-hard-on-the-raspberry-pi-so-does-pidome/