HSQLDB-这是主数据库文件 [英] HSQLDB - which is the main database file

问题描述

我在嵌入式模式下使用HSQLDB.

I am using HSQLDB in the embedded mode.

jdbc:hsqldb:file:abc\\TESTDB;

创建数据库后，文件夹 abc 具有以下文件:

After creating the database, the folder abc has the following files:

TESTDB.lck TESTDB.script TESTDB.log TESTDB.properties

我的应用程序正常运行

但是我的问题是上面列出的文件中哪个是主数据库文件?

But my question is which is the main database file amongst the above-listed files?

还是主数据库文件存储在其他位置?

Or is the main database file stored in some other location?

推荐答案

.script 包含创建表，更改表和插入数据的所有语句.当您在内存中使用hsqldb时，将创建此文件.(所以我说这是您的数据库)否则，如其他人已经说过的那样，数据库将存储在 .data 中.

.script contains all the statements to create the tables, alter them and insert the data. This file is created when you use hsqldb in memory. (so I'd say this is your database) Otherwise the database is stored in .data as other people already said

.lck 是hsqldb通过其了解数据库是否已被进程锁定的锁定文件.通常，只有在程序运行时才具有此文件，并且在停止程序时会自动将其删除.

.lck is the lock file by which hsqldb knows whether the database is locked by a process. Usually you have this file only while your program is running and it is automatically deleted when you stop the programm.

.log 包含例如正在运行的事务的内部日志语句以及一些提交或回滚点.

.log contains internal log statements of running transactions for example and some commit or rollback points.

.properties 包含用于初始化hsqldb的属性(如果您不知道自己在做什么，最好不要在此进行任何更改).请勿将其与持久性单元配置相混淆.

.properties contains the properties with which hsqldb is initialized (better don't change anything there if you don't know what you are doing). This is not to be confused with and persistence unit configuration.

亲切的问候

这篇关于HSQLDB-这是主数据库文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！