Raspi: Cannot create PoolableConnectionFactory (Error opening connection)

[externus]

Hi, I get following error messages on my raspi with osmc.

`INFO: Loading database 'data/cache/default.db'...
Jan 08, 2019 11:49:58 PM org.andresoviedo.google_drive_ftp_adapter.Main main
SEVERE: Error loading app
org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Co nnection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Error opening connection)
at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(Dat aSourceUtils.java:80)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java: 382)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:45 6)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:46 4)
at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplat e.java:472)
at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplat e.java:477)
at org.andresoviedo.google_drive_ftp_adapter.model.SQLiteCache.(SQ LiteCache.java:78)
at org.andresoviedo.google_drive_ftp_adapter.GoogleDriveFtpAdapter.(GoogleDriveFtpAdapter.java:33)
at org.andresoviedo.google_drive_ftp_adapter.Main.main(Main.java:52)
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableCon nectionFactory (Error opening connection)
at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFacto ry(BasicDataSource.java:1549)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSou rce.java:1388)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource .java:1044)
at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(D ataSourceUtils.java:111)
at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(Dat aSourceUtils.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(Driv erConnectionFactory.java:38)
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(Poolable ConnectionFactory.java:582)
at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(Bas icDataSource.java:1556)
at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFacto ry(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

Exception in thread "main" java.awt.AWTError: Assistive Technology not found: or g.GNOME.Accessibility.AtkWrapper
at java.awt.Toolkit.loadAssistiveTechnologies(Toolkit.java:807)
at java.awt.Toolkit.getDefaultToolkit(Toolkit.java:886)
at sun.swing.SwingUtilities2.getSystemMnemonicKeyMask(SwingUtilities2.ja va:2020)
at javax.swing.plaf.basic.BasicLookAndFeel.initComponentDefaults(BasicLo okAndFeel.java:1158)
at javax.swing.plaf.metal.MetalLookAndFeel.initComponentDefaults(MetalLo okAndFeel.java:431)
at javax.swing.plaf.basic.BasicLookAndFeel.getDefaults(BasicLookAndFeel. java:148)
at javax.swing.plaf.metal.MetalLookAndFeel.getDefaults(MetalLookAndFeel. java:1577)
at javax.swing.UIManager.setLookAndFeel(UIManager.java:539)
at javax.swing.UIManager.setLookAndFeel(UIManager.java:579)
at javax.swing.UIManager.initializeDefaultLAF(UIManager.java:1349)
at javax.swing.UIManager.initialize(UIManager.java:1459)
at javax.swing.UIManager.maybeInitialize(UIManager.java:1426)
at javax.swing.UIManager.getDefaults(UIManager.java:659)
at javax.swing.UIManager.getString(UIManager.java:805)
at javax.swing.UIManager.getString(UIManager.java:822)
at javax.swing.JOptionPane.showMessageDialog(JOptionPane.java:608)
at org.andresoviedo.google_drive_ftp_adapter.Main.main(Main.java:59)
`

[BananaLoaf]

Check out this issue, there is a fix for that
@andresoviedo Can you add default arm support?

[andresoviedo]

Hi @BananaLoaf I don't have a Rapsberry and I don't have much time to emulate one.

So, if you want to contribute, could you please change the sqlite-jdbc maven dependency in pom.xml with latest version and rebuild package so you can test it? You can try with this one:

<dependency>
  <groupId>org.xerial</groupId>
  <artifactId>sqlite-jdbc</artifactId>
  <version>3.25.2</version>
</dependency>

If it works, please give us your feedback so I can upgrade it. Many thanks

[andresoviedo]

Duplicate of #24

[andresoviedo]

Duplicate of #12