使用Java从磁盘备份和恢复sqlite到内存 [英] Backup and restore sqlite from disk to memory in Java

问题描述

我正在尝试将sqlite-File读入内存以获得更好的性能，在关闭我的应用程序时我想将其写回到hdd。

I'm trying to read a sqlite-File into memory for better performance, when closing my application I want to write it back to hdd.

我是在Java中使用 jdbc （3.7.2）驱动程序。

I'm using the jdbc (3.7.2) driver in Java.

根据文档，我的代码看起来像

According to the docs, my Code looks like

this._conn = DriverManager.getConnection("jdbc:sqlite:");
Statement stat  = this._conn.createStatement();
File dbFile = new File(this._config.GetDataBaseFile());
if (dbFile.exists()) {
    this._logger.AddInfo("File exists.");
    stat.executeUpdate("restore from " + dbFile.getAbsolutePath());
}

文件存在（及其有效的sqlite数据库）， this._conn 已打开，但如果我想在其上执行语句，则表示内部没有表或数据。它似乎没有恢复任何东西。

The file exists (and its a valid sqlite db), this._conn is open, but if I want to execute statements on it, it appears that there is no table nor data inside. It seems it doesn't restore anything.

有关如何进一步解决/调试的任何建议吗？

Any suggestions on how to solve/debug that further?

（顺便说一下 - 如果我在我的连接上使用 stat.executeUpdate（backup to test.db），它会备份我的空：memory：db ...）

(by the way - if I use stat.executeUpdate("backup to test.db")on my connection, it backups my empty :memory: db...)

推荐答案

引号和 stat.close（）无关紧要，根据链接：` https://bitbucket.org/xerial/sqlite-jdbc/wiki /用法'，我测试过。但是当文件路径包含空格时引用帮助。

The quotes and stat.close() don't matter, according to the link: `https://bitbucket.org/xerial/sqlite-jdbc/wiki/Usage', which I have tested. Quotes help when file path contains spaces, though.

我认为这可能是由于jdbc驱动程序。尝试使用Xerial的SQLite JDBC驱动程序，这对我来说很好。

I think it maybe due to the jdbc driver. Try Xerial's JDBC driver for SQLite, which works fine for me.

这篇关于使用Java从磁盘备份和恢复sqlite到内存的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！