Rapsberry - Update sqlite libraries to support ARM processors

[joussy]

Hi,

Thanks for your great work, this project is definitly useful!

I'm trying to run your adapter on debian. When I start your application I have got the following output:

java -jar google-drive-ftp-adapter-jar-with-dependencies.jar /etc/google-drive-adapter/config

Implementation-Title:Google Drive FTP Adapter Implementation-Version:1.2.3 Archiver-Version:Plexus Archiver Built-By:andres Specification-Title:Google Drive FTP Adapter Implementation-Vendor-Id:org.andresoviedo Created-By:Apache Maven 3.3.9 Build-Jdk:1.8.0_45-internal Specification-Version:1.2.3 Manifest-Version:1.0 Main-Class:org.andresoviedo.apps.gdrive_ftp_adapter.Main 2017-01-08 13:57:53,942 INFO main Main - Program info: {Archiver-Version=Plexus Archiver, Implementation-Title=Google Drive FTP Adapter, Specification-Version=1.2.3, Implementation-Version=1.2.3, Created-By=Apache Maven 3.3.9, Manifest-Version=1.0, Specification-Title=Google Drive FTP Adapter, Implementation-Vendor-Id=org.andresoviedo, Built-By=andres, Build-Jdk=1.8.0_45-internal, Main-Class=org.andresoviedo.apps.gdrive_ftp_adapter.Main} 2017-01-08 13:57:53,962 INFO main Main - Started with args '[/etc/google-drive-adapter/config]'... 2017-01-08 13:57:53,963 INFO main Main - Loading configuration... 2017-01-08 13:57:53,967 INFO main Main - Loading properties from classpath... 2017-01-08 13:57:53,970 INFO main Main - Properties loaded: '{}' 2017-01-08 13:57:53,972 INFO main Main - Loading properfiles file 'configuration.properties'... 2017-01-08 13:57:53,975 WARN main Main - Exception loading file 'configuration.properties'. 2017-01-08 13:57:53,996 INFO main Main - Properfiles loaded: '{}' 2017-01-08 13:57:53,998 INFO main Main - Loading properfiles file '/etc/google-drive-adapter/config'... 2017-01-08 13:57:54,001 INFO main Main - Properfiles loaded: '{ftp.pass=user, port=1821, os.illegalCharacters=\/|[\x00-\x1F\x7F]|`|\?|*|\|\<|>|||\"|\:, ftp.user=user, ftp.anonymous.enabled=false, account=default, log4j.fileId=}' 2017-01-08 13:57:54,026 INFO main Main - Property 'log4j.configuration' was not specified in application properties. Using defaults. 2017-01-08 13:57:54,029 INFO main Main - Configuring log4j from 'classpath:/log4j.xml' 2017-01-08 13:57:54,111 INFO main Main - Creating application with configuration '{ftp.pass=user, port=1821, os.illegalCharacters=\/|[\x00-\x1F\x7F]|`|\?|*|\|\<|>|||\"|\:, log4j.fileId=, account=default, ftp.anonymous.enabled=false, ftp.user=user}' 2017-01-08 13:57:54,340 INFO main SQLiteCache - Loading database 'data/default/gdrive.db'... Exception in thread "main" org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Error opening connection) at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:382) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:456) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:464) at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:472) at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:477) at org.andresoviedo.apps.gdrive_ftp_adapter.model.SQLiteCache.(SQLiteCache.java:99) at org.andresoviedo.apps.gdrive_ftp_adapter.GDriveFtpAdapter.(GDriveFtpAdapter.java:34) at org.andresoviedo.apps.gdrive_ftp_adapter.Main.main(Main.java:64) Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Error opening connection) at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549) at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044) at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111) at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77) ... 8 more Caused by: java.sql.SQLException: Error opening connection at org.sqlite.SQLiteConnection.open(SQLiteConnection.java:179) at org.sqlite.SQLiteConnection.(SQLiteConnection.java:105) at org.sqlite.JDBC.createConnection(JDBC.java:113) at org.sqlite.JDBC.connect(JDBC.java:87) at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38) at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582) at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556) at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545) ... 12 more Caused by: java.lang.Exception: Error loading native library: /org/sqlite/native/Linux/arm/libsqlitejdbc.so at org.sqlite.SQLiteJDBCLoader.loadSQLiteNativeLibrary(SQLiteJDBCLoader.java:241) at org.sqlite.SQLiteJDBCLoader.initialize(SQLiteJDBCLoader.java:63) at org.sqlite.NativeDB.load(NativeDB.java:50) at org.sqlite.SQLiteConnection.open(SQLiteConnection.java:175) ... 19 more

The application has created the folders data/default/ but the folders are empty. I've tried to run the application as an administrator and a normal user but I end up with the same result.

Thanks for your help !

[joussy]

I found out what the issue was: sqlite-jdbc old versions didn't have build rules for ARM (http://stackoverflow.com/a/29647774). I've changed the version of the dependency (3.7.15-M1) with the latest one (3.15.1) and it solved the problem !

[andresoviedo]

Thanks for your feedback @joussy