Hitzui
commented
2 years ago Class of connection:
public class DataConnection {
Connection connection;
private final static String DB_NAME = "sondeo.db";
Logger logger = Logger.getLogger(getClass().getName());
public Connection getConnection() {
try {
connection = DriverManager.getConnection(readDB());
connection.setReadOnly(false);
} catch (SQLException e) {
logger.warning("Error: " + e.getMessage());
e.printStackTrace();
}
return this.connection;
}
private String readDB() throws SQLException {
logger.info("Reading an existing Database with SQLite");
String dbUrl = "jdbc:sqlite:";
if (Platform.isDesktop()) {
//dbUrl = dbUrl + ":resource:" + Objects.requireNonNull(SondeoApplication.class.getResource("/databases/" + DB_NAME)).toExternalForm();
dbUrl = dbUrl + DB_NAME;
} else {
try {
var resource = getClass().getClassLoader().getResource("databases/sondeo.db");
DriverManager.registerDriver(new SQLDroidDriver());
var privateStorage = Services.get(StorageService.class)
.flatMap(StorageService::getPrivateStorage)
.orElseThrow(() -> new IOException("Error: PrivateStorage not available"));
var publicStorage = Services.get(StorageService.class)
.flatMap(storageService -> storageService.getPublicStorage("Documents"))
.orElseThrow(() -> new IOException("error al leer la carpeta publica de Documents"));
File db = new File(publicStorage, DB_NAME);
/*if (resource != null) {
var file = new File(resource.getFile());
logger.info("Copying database " + DB_NAME + " to private storage");
logger.info("Resource: " + file.getAbsolutePath());
DBUtils.copyDatabase(file.getParent() + "/", publicStorage.getAbsolutePath(), DB_NAME);
DBUtils.copyDatabase(publicStorage.getAbsolutePath(), privateStorage.getAbsolutePath(), DB_NAME);
}*/
dbUrl = dbUrl + db.getAbsolutePath();
} catch (IOException ex) {
logger.warning("IO error " + ex.getMessage());
ex.printStackTrace();
}
}
logger.info("Path of url: " + dbUrl);
return dbUrl;
}
public DataConnection() {
try {
Class<?> c = null;
if (Platform.isAndroid()) {
c = Class.forName("org.sqldroid.SQLDroidDriver");
} else if (Platform.isIOS()) {
c = Class.forName("SQLite.JDBCDriver");
} else if (Platform.isDesktop()) {
c = Class.forName("org.sqlite.JDBC");
} else if (System.getProperty("os.arch").toUpperCase().contains("ARM")) {
c = Class.forName("org.sqldroid.SQLDroidDriver");
}
} catch (ClassNotFoundException e) {
System.out.println("Error class not found " + e);
}
}
}
mipastgt
ianopolous
Dear, it presents the following error when executing the application, being more specific, when loading the sqlite data, when generating the APK, it does not generate any error, in fact the application runs fine, the error occurs when making the connection to the base of data.