如何根据我的SQuirrel配置找到嵌入式h2数据库？ [英] How can I locate an embedded h2 db based on my SQuirrel configuration?

问题描述

我有一个简单的h2数据库示例，我假设它是一个存储在单个文件中的数据库。但是我在哪里可以找到该文件？我想使用Squirrel等SQL客户端连接到该数据库。该文件默认放置在哪里？

I have a simple h2 database example, I assume it is a database that is stored in a single file. But where do I find this file? I'd like to connect to that db using SQL clients like Squirrel. Where is this file placed by default?

    <property name="eclipselink.jdbc.platform"
        value="org.eclipse.persistence.platform.database.H2Platform" />
    <property name="javax.persistence.jdbc.driver" value="org.h2.Driver" />
    <property name="javax.persistence.jdbc.url" value="jdbc:h2:~/myDB;FILE_LOCK=NO" />
    <property name="javax.persistence.jdbc.user" value="sa" />
    <property name="javax.persistence.jdbc.password" value="sa" />

推荐答案

基于以下值：

jdbc:h2:~/myDB;FILE_LOCK=NO"

似乎您的数据库文件位于您的主目录中，该文件名为 myDB

It appears that your database file is located in your home directory in a file called myDB

〜表示您的主目录。

这篇关于如何根据我的SQuirrel配置找到嵌入式h2数据库？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！