search

andresoviedo / google-drive-ftp-adapter

Google Drive FTP Adapter to connect to google drive through the FTP protocol
GNU Lesser General Public License v3.0
395 stars 93 forks source link

Raspi: Cannot create PoolableConnectionFactory (Error opening connection) #41

Closed externus closed 5 years ago

externus commented 5 years ago

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 commented 5 years ago

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

andresoviedo commented 5 years ago

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 commented 5 years ago

Duplicate of #24

andresoviedo commented 5 years ago

Duplicate of #12