blocks|key|2176311|text|H2仍然在运行(我可以保证)。您需要为多个用户(如->+)使用TCP连接。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2176312|<property+name="javax.persistence.jdbc.url"+value="jdbc:h2:tcp://localhost/C:\Database\Data\production;"/>|code-block|syntax|javascript|2176313|或|2176314|DriverManager.getConnection("jdbc:h2:tcp://localhost/server~/dbname","username","password");|2176315|这也意味着您需要以TCP模式启动服务器。亲爱的，这在文档中是非常直接的。|2176316|强制终止进程(javaw.exe+for+Windows)，并确保任何可能启动该进程的应用程序都被关闭。你有一个主动锁。|2176317|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|S|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|U|8|@]|9|@]|A|$]]|$1|M|3|N|5|6|7|V|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

H2 is still running (I can guarantee it). You need to use a TCP connection for multiple users such as ->

<pre><code>&lt;property name="javax.persistence.jdbc.url" value="jdbc:h2:tcp://localhost/C:\Database\Data\production;"/&gt;
</code></pre>

OR

<pre><code>DriverManager.getConnection("jdbc:h2:tcp://localhost/server~/dbname","username","password");
</code></pre>

It also means you need to start the server in TCP mode. Honesetly, it is pretty straight forward in the documentation.

Force kill the process (javaw.exe for Windows), and make sure that any application that might have started it is shut down. You have an active lock.

blocks|key|354145|text|您还可以从H2控制台访问"Preferences“选项卡，并通过按”关机“按钮关闭所有活动会话。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|354146|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

You can also visit the "Preferences" tab from the H2 Console and shutdown all active sessions by pressing the shutdown button.

blocks|key|354155|text|我使用h2db和一个测试T24+tafj应用程序，我也遇到了同样的问题，但我设法通过识别运行h2的应用程序(当我试图建立数据库连接时启动)来解决这个问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|354156|ps+aux%7Cgrep+java|code-block|syntax|javascript|354157|将提供的产出如下：|354158|sysadmin+22755++3.2++0.1+5189724+64008+pts/3+++Sl+++08:28+++0:00+/usr/java/default/bin/java+-server+-Xmx2048M+-XX:MaxPermSize=256M+-cp+h2-1.3.175.jar:/r14tafj/TAFJ/dbscripts/h2/TAFJFunctions.jar+org.h2.tools.Server+-tcp+-tcpAllowOthers+-baseDir+/r14tafj/t24/data|354159|现在，用它的进程id来终止它：|354160|kill+-9+22755|354161|最后，删除锁文件：|354162|rm+-f+dbname.lock.db|354163|entityMap^0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|W|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|X|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|Y|8|@]|9|@]|A|$]]|$1|M|3|N|5|D|7|Z|8|@]|9|@]|A|$E|F]]|$1|O|3|P|5|6|7|10|8|@]|9|@]|A|$]]|$1|Q|3|R|5|D|7|11|8|@]|9|@]|A|$E|F]]|$1|S|3|-4|5|6|7|12|8|@]|9|@]|A|$]]]|T|$]]

I'm using h2db with a test T24 tafj application, I had the same problem but I managed to resolve it by identifying the application that is running h2 (launched when I attempted to setup a database connection).

<pre><code>ps aux|grep java
</code></pre>

will give output as: 

<pre><code>sysadmin 22755 3.2 0.1 5189724 64008 pts/3 Sl 08:28 0:00 /usr/java/default/bin/java -server -Xmx2048M -XX:MaxPermSize=256M -cp h2-1.3.175.jar:/r14tafj/TAFJ/dbscripts/h2/TAFJFunctions.jar org.h2.tools.Server -tcp -tcpAllowOthers -baseDir /r14tafj/t24/data
</code></pre>

now kill this with its process id:

<pre><code>kill -9 22755
</code></pre>

and at last remove the lock file:

<pre><code>rm -f dbname.lock.db
</code></pre>

blocks|key|163438|text|我在一个web应用程序中运行ORMLite时遇到了类似的问题。最初，我在url中使用服务器模式的语法被困住了。上面的答案对此有所帮助。然后，我遇到了类似的用户/密码错误，这更容易理解。我不需要关闭任何东西或者删除任何文件。以下代码起作用：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|163439|protected+ConnectionSource+getConnectionSource()+throws+SQLException+{
++++String+databaseUrl+=+"jdbc:h2:tcp://localhost/~/test";
++++return+new+JdbcConnectionSource(databaseUrl,"sa","sa");
}|code-block|syntax|javascript|163440|若要在通配符上的服务器模式下使用H2，我在standalone.xml中修改了connection-url。|163441|<datasource+jndi-name="java:jboss/datasources/ExampleDS"+pool-+name="ExampleDS"+enabled="true"+use-java-context="true">
+++++<connection-url>jdbc:h2:tcp://localhost/~/test</connection-url>
+++++++++++++++…
</datasource>|163442|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

I ran into similar problems running with ORMLite from a web application. I initially got stuck on the syntax to use server mode in the url. The answers above helped with that. Then I had the similar user/password error which was easier to figure out. I did not have to shut anything down or erase any files. The following code worked: 

<pre><code>protected ConnectionSource getConnectionSource() throws SQLException {
 String databaseUrl = "jdbc:h2:tcp://localhost/~/test";
 return new JdbcConnectionSource(databaseUrl,"sa","sa");
}
</code></pre>

To use H2 in server mode on wildfly, I Modifed connection-url in standalone.xml

<pre><code>&lt;datasource jndi-name="java:jboss/datasources/ExampleDS" pool- name="ExampleDS" enabled="true" use-java-context="true"&gt;
 &lt;connection-url&gt;jdbc:h2:tcp://localhost/~/test&lt;/connection-url&gt;
 …
&lt;/datasource&gt;
</code></pre>

blocks|key|354199|text|遇到了类似的问题，对我来说，解决方案是在与之关联的文件上运行fuser+-k+'filename.db'。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|354200|希望这能有所帮助！|354201|entityMap^0|U|M|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@$9|K|A|L|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|M|8|@]|D|@]|E|$]]|$1|H|3|-4|5|6|7|N|8|@]|D|@]|E|$]]]|I|$]]

Ran into a similar issue the solution for me was to run <code>fuser -k 'filename.db'</code> on the file that had a lock associated with it.

Hope this helps!

blocks|key|2176449|text|简单的步骤:转到任务管理器并终止java进程。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2176450|那就开始你的表演|2176451|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

Simple step: Go to the task manager and kill the java process

then start your apllication

blocks|key|163949|text|我也有同样的问题。在Intellj中，当我想使用h2数据库时，当我的程序运行时，我得到了相同的错误。为了解决这个问题，我将连接url改为|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|163950|spring.datasource.url=jdbc:h2:file:~/ipinbarbot|code-block|syntax|javascript|163951|至：|163952|spring.datasource.url=jdbc:h2:~/ipinbarbot;DB_CLOSE_ON_EXIT=FALSE;AUTO_SERVER=TRUE|163953|然后我的问题就消失了。现在我可以连接到"ipinbarbot“数据库时，我的程序是。如果您使用Hibernate，也不要忘记有：|163954|spring.jpa.hibernate.ddl-auto+=+update|163955|古德勒克|163956|entityMap^0|O|2|0|0|0|0|0|0|0|4|0^^$0|@$1|2|3|4|5|6|7|W|8|@$9|X|A|Y|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|Z|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|10|8|@]|D|@]|E|$]]|$1|M|3|N|5|H|7|11|8|@]|D|@]|E|$I|J]]|$1|O|3|P|5|6|7|12|8|@]|D|@]|E|$]]|$1|Q|3|R|5|H|7|13|8|@]|D|@]|E|$I|J]]|$1|S|3|T|5|6|7|14|8|@$9|15|A|16|B|C]]|D|@]|E|$]]|$1|U|3|-4|5|6|7|17|8|@]|D|@]|E|$]]]|V|$]]

I had the same problem.
in Intellj, when i want to use h2 database when my program was running i got the same error.
For solve this problem i changed the connection url from

<pre><code>spring.datasource.url=jdbc:h2:file:~/ipinbarbot
</code></pre>

to:

<pre><code>spring.datasource.url=jdbc:h2:~/ipinbarbot;DB_CLOSE_ON_EXIT=FALSE;AUTO_SERVER=TRUE
</code></pre>

And then my problem gone away. now i can connect to "ipinbarbot" database when my program is.
If you use Hibernate, also don't forget to have:

<pre><code>spring.jpa.hibernate.ddl-auto = update
</code></pre>

goodluck

blocks|key|163501|text|您也可以删除文件的h2文件数据库和问题将消失。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|163502|jdbc:+h2+:~/dbname意味着名为db的文件h2数据库将在用户主目录(~/意味着用户主目录，我希望您在Linux上工作)中创建。|163503|在我的本地机器中，它现在位于:+/home/jack/dbname.mv.db中，我不知道为什么文件的名称是dbname.mv.db，而不是dbname。可能是h2默认设置。我删除此文件：|163504|rm+~/dbname.mv.db+|code-block|syntax|javascript|163505|或：|163506|cd+~/+
rm+dbname.mv.db+|163507|数据库dbname将与所有数据一起删除。经过新的数据库后，一切都会好起来的。|163508|entityMap^0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|T|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|U|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|V|8|@]|9|@]|A|$I|J]]|$1|K|3|L|5|6|7|W|8|@]|9|@]|A|$]]|$1|M|3|N|5|H|7|X|8|@]|9|@]|A|$I|J]]|$1|O|3|P|5|6|7|Y|8|@]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|R|$]]

You can also delete file of the h2 file database and problem will disappear.

jdbc:h2:~/dbname means that file h2 database with name db name will be created in the user home directory(~/ means user home directory, I hope you work on Linux). 

In my local machine its present in: /home/jack/dbname.mv.db I don't know why file has a name dbname.mv.db instead a dbname. 
May be its a h2 default settings. 
I remove this file: 

<pre><code>rm ~/dbname.mv.db 
</code></pre>

OR: 

<pre><code>cd ~/ 
rm dbname.mv.db 
</code></pre>

Database dbname will be removed with all data. After new data base init all will be ok.

blocks|key|2176520|text|我从上面的Saman+Salehi那里得到了线索。我的usecase:为客户端负载平衡准备REST应用程序(运行两个JVM实例REST)。这里，我的MVC应用程序将调用这个具有ActiveMQ后端数据的REST应用程序。当我在eclipse中运行两个REST应用程序实例并尝试使用以下配置同时运行两个实例时，我遇到了问题|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2176521|spring.datasource.url=jdbc:h2:file:./Database;
spring.jpa.properties.hibernate.hbm2ddl.auto=update|code-block|syntax|javascript|2176522|加入DB_CLOSE_ON_EXIT=FALSE;AUTO_SERVER=TRUE后|2176523|spring.datasource.url=jdbc:h2:file:./Database;DB_CLOSE_ON_EXIT=FALSE;AUTO_SERVER=TRUE|2176524|这两个实例都在运行并显示在Eureka仪表板中。|2176525|当VM退出时不要关闭数据库:+jdbc:h2:;DB_CLOSE_ON_EXIT=FALSE|2176526|多个进程可以访问同一个数据库，而不必手动启动服务器;AUTO_SERVER=TRUE。|2176527|进一步阅读：http://www.h2database.com/html/features.html|offset|length|2176528|entityMap|0|LINK|mutability|MUTABLE|url|http://www.h2database.com/html/features.html^0|0|0|0|0|0|0|0|6|18|0|0^^$0|@$1|2|3|4|5|6|7|12|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|13|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|14|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|15|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|16|8|@]|9|@]|A|$]]|$1|M|3|N|5|6|7|17|8|@]|9|@]|A|$]]|$1|O|3|P|5|6|7|18|8|@]|9|@]|A|$]]|$1|Q|3|R|5|6|7|19|8|@]|9|@$S|1A|T|1B|1|1C]]|A|$]]|$1|U|3|-4|5|6|7|1D|8|@]|9|@]|A|$]]]|V|$W|$5|X|Y|Z|A|$10|11]]]]

I got clue from Saman Salehi above.
My usecase:
Preparing REST application for client-side load balancing(running two JVM instances of REST). Here my MVC application will call this REST application that has ActiveMQ backend for DATA.
I had the problem when I ran two instances of REST application in eclipse and trying to run both instances at the same time with the following configuration

<pre><code>spring.datasource.url=jdbc:h2:file:./Database;
spring.jpa.properties.hibernate.hbm2ddl.auto=update
</code></pre>

After adding DB_CLOSE_ON_EXIT=FALSE;AUTO_SERVER=TRUE

<pre><code>spring.datasource.url=jdbc:h2:file:./Database;DB_CLOSE_ON_EXIT=FALSE;AUTO_SERVER=TRUE
</code></pre>

Both instances are running and showing in Eureka dasboard.

Don't close the database when the VM exits : jdbc:h2:;DB_CLOSE_ON_EXIT=FALSE

Multiple processes can access the same database without having to start the server manually ;AUTO_SERVER=TRUE 

Further reading:
<a href="http://www.h2database.com/html/features.html" rel="noreferrer">http://www.h2database.com/html/features.html</a>

blocks|key|163533|text|这个问题的答案是线程“=>”org.h2.jdbc.JdbcSQLException:+org.h2.jdbc.JdbcSQLException中的异常可能已经在使用：“被另一个进程锁定”。可能的解决方案:关闭所有其他连接；使用服务器模式90020-161|type|unstyled|depth|inlineStyleRanges|entityRanges|data|163534|关闭浏览器中的所有选项卡，其中打开的h2数据库也退出h2引擎从您的pc|163535|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

answer for this question => Exception in thread "main" org.h2.jdbc.JdbcSQLException: Database may be already in use: "Locked by another process". Possible solutions: close all other connection(s); use the server mode [90020-161]

close all tab from your browser where open h2 database also Exit h2 engine from your pc

blocks|key|164015|text|我在日食中面临着这个问题。我所做的是，从任务管理器中杀死正在运行的java进程。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|164016|​|164017|📷|atomic|offset|length|164018|164019|对我起作用了。|164020|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://developer.qcloudimg.com/http-save/yehe-900000/1a466e161378d3b86d726f9fc5800de7.png|imageAlt^0|0|0|0|1|0|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|V|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|W|8|@]|9|@$G|X|H|Y|1|Z]]|A|$]]|$1|I|3|C|5|6|7|10|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|11|8|@]|9|@]|A|$]]|$1|L|3|-4|5|6|7|12|8|@]|9|@]|A|$]]]|M|$N|$5|O|P|Q|A|$R|S|T|-4]]]]

I was facing this issue in eclipse . What I did was, killed the running java process from the task manager.

<a href="https://i.stack.imgur.com/Sv9ZE.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Sv9ZE.png" alt="enter image description here"></a>

It worked for me.

blocks|key|354394|text|对于InteliJ:在数据库视图中右击数据库，然后选择“断开连接”。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|354395|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

For InteliJ: right lick on your database in the database view and choose &quot;Disconnect&quot;.

blocks|key|354410|text|如果在应用程序使用单个数据库(h2)的多个端口中运行相同的应用程序，那么在url中添加AUTO_SERVER=TRUE，如下所示：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|354411|jdbc:h2:file:C:/simple-commerce/price;DB_CLOSE_ON_EXIT=FALSE;AUTO_RECONNECT=TRUE;AUTO_SERVER=TRUE|code-block|syntax|javascript|354412|entityMap^0|17|G|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|P|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|Q|8|@]|D|@]|E|$]]]|L|$]]

If you are running same app into multiple ports where app uses single database (h2), then add <code>AUTO_SERVER=TRUE</code> in the url as follows:
<pre><code>jdbc:h2:file:C:/simple-commerce/price;DB_CLOSE_ON_EXIT=FALSE;AUTO_RECONNECT=TRUE;AUTO_SERVER=TRUE
</code></pre>

blocks|key|164046|text|在application.properties文件中>将数据源编辑为：|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|164047|spring.datasource.url=jdbc:h2:file:C:/temp/test;DB_CLOSE_ON_EXIT=FALSE;AUTO_SERVER=TRUE|code-block|syntax|javascript|164048|快乐编码！|164049|entityMap^0|1|M|0|0|0|5|0^^$0|@$1|2|3|4|5|6|7|O|8|@$9|P|A|Q|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|R|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|S|8|@$9|T|A|U|B|C]]|D|@]|E|$]]|$1|M|3|-4|5|6|7|V|8|@]|D|@]|E|$]]]|N|$]]

In your application.properties file &gt; edit the datasource into:
<pre><code>spring.datasource.url=jdbc:h2:file:C:/temp/test;DB_CLOSE_ON_EXIT=FALSE;AUTO_SERVER=TRUE
</code></pre>
Happy coding!

blocks|key|163562|text|标识H2进程id并终止它。对于mac|type|unstyled|depth|inlineStyleRanges|entityRanges|data|163563|ps+-ef%7Cgrep+h2|blockquote|163564|那就获取进程标识并杀死它。|163565|杀灭-9+PID|163566|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$]]|$1|E|3|F|5|6|7|M|8|@]|9|@]|A|$]]|$1|G|3|H|5|D|7|N|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|O|8|@]|9|@]|A|$]]]|J|$]]

Identify the H2 process id and kill it. For mac
<blockquote>
ps -ef|grep h2
</blockquote>
Then get the process id and kill it.
<blockquote>
kill -9 PID
</blockquote>

blocks|key|2176690|text|我试图删除dbname.lock.db文件，但它是自动重新创建的。我如何解锁数据库以使用我的Java程序？|type|blockquote|depth|inlineStyleRanges|entityRanges|data|2176691|只需添加FILE_LOCK=NO;即可。FILE_LOCK=NO不做dbname.lock.db。|unstyled|offset|length|style|CODE|2176692|spring.datasource.url=jdbc:h2:file:./testdb/h2;DB_CLOSE_ON_EXIT=false;FILE_LOCK=NO;|code-block|syntax|javascript|2176693|FILE_LOCK参考这的详细信息。|2176694|使用NO方法可以强制数据库根本不创建锁文件。|2176695|entityMap|0|LINK|mutability|MUTABLE|url|http://www.h2database.com/html/features.html#database_file_locking^0|0|4|D|K|C|Y|E|0|0|B|1|0|0|0^^$0|@$1|2|3|4|5|6|7|Z|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|10|8|@$E|11|F|12|G|H]|$E|13|F|14|G|H]|$E|15|F|16|G|H]]|9|@]|A|$]]|$1|I|3|J|5|K|7|17|8|@]|9|@]|A|$L|M]]|$1|N|3|O|5|D|7|18|8|@]|9|@$E|19|F|1A|1|1B]]|A|$]]|$1|P|3|Q|5|6|7|1C|8|@]|9|@]|A|$]]|$1|R|3|-4|5|D|7|1D|8|@]|9|@]|A|$]]]|S|$T|$5|U|V|W|A|$X|Y]]]]

<blockquote>
I tried to delete the dbname.lock.db file but it is automatically re-created.
How can I unlock the database to use it from my Java program?
</blockquote>
Just add <code>FILE_LOCK=NO;</code>. <code>FILE_LOCK=NO</code> doesn't make <code>dbname.lock.db</code>.
<pre><code>spring.datasource.url=jdbc:h2:file:./testdb/h2;DB_CLOSE_ON_EXIT=false;FILE_LOCK=NO;
</code></pre>
The detail for FILE_LOCK reference <a href="http://www.h2database.com/html/features.html#database_file_locking" rel="nofollow noreferrer">this</a>.
<blockquote>
Using the method NO forces the database to not create a lock file at all
</blockquote>

blocks|key|354573|text|根据H2数据库教程，您可以在三种不同的模式下运行H2数据库：|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|354574|服务器模式：|ordered-list-item|354575|jdbc:h2:tcp://localhost/~/test|style|CODE|354576|在服务器模式(也称为客户机/服务器模式)中使用H2+db时，所有数据都通过TCP/IP传输。在应用程序可以在服务器模式下使用H2数据库之前，您需要在同一台或另一台计算机中启动H2+DB。|354577|嵌入式模式：|354578|jdbc:h2:~/test|354579|嵌入式模式下的H2+db会更快，但是它的缺点是没有其他进程可以访问数据库。在上面的连接字符串中，数据将保存到用户主目录下的“test”文件夹中。|354580|混合模式：|354581|混合模式结合了嵌入式模式和服务器模式的一些特点。连接到H2+db的第一个应用程序在嵌入式模式下运行，但同时启动服务器，以便其他应用程序可以并发地访问相同的数据，甚至来自不同的进程。|354582|jdbc:h2:/data/test;AUTO_SERVER=TRUE|354583|当使用自动混合模式时，可以使用DB为所有应用程序共享JDBC。默认情况下，服务器使用任何免费的TCP端口。可以使用AUTO_SERVER_PORT=9090手动设置端口。|354584|entityMap|0|LINK|mutability|MUTABLE|url|http://www.mastertheboss.com/jbossas/jboss-datasource/h2-database-tutorial/^0|2|7|0|0|0|0|U|0|0|0|0|E|0|0|0|0|0|Z|0|0^^$0|@$1|2|3|4|5|6|7|18|8|@]|9|@$A|19|B|1A|1|1B]]|C|$]]|$1|D|3|E|5|F|7|1C|8|@]|9|@]|C|$]]|$1|G|3|H|5|6|7|1D|8|@$A|1E|B|1F|I|J]]|9|@]|C|$]]|$1|K|3|L|5|6|7|1G|8|@]|9|@]|C|$]]|$1|M|3|N|5|F|7|1H|8|@]|9|@]|C|$]]|$1|O|3|P|5|6|7|1I|8|@$A|1J|B|1K|I|J]]|9|@]|C|$]]|$1|Q|3|R|5|6|7|1L|8|@]|9|@]|C|$]]|$1|S|3|T|5|F|7|1M|8|@]|9|@]|C|$]]|$1|U|3|V|5|6|7|1N|8|@]|9|@]|C|$]]|$1|W|3|X|5|6|7|1O|8|@$A|1P|B|1Q|I|J]]|9|@]|C|$]]|$1|Y|3|Z|5|6|7|1R|8|@]|9|@]|C|$]]|$1|10|3|-4|5|6|7|1S|8|@]|9|@]|C|$]]]|11|$12|$5|13|14|15|C|$16|17]]]]

According <a href="http://www.mastertheboss.com/jbossas/jboss-datasource/h2-database-tutorial/" rel="nofollow noreferrer">H2 Database Tutorial</a> you can run the H2 Database in three different modes:
<ol>
<li>Server mode:</li>
</ol>
<code>jdbc:h2:tcp://localhost/~/test</code>
When using H2 db in server mode (also known as client/server mode) all data is transferred over TCP/IP. Before application can use H2 Database in server mode, you need to start the H2 DB within the same or another machine.
<ol start="2">
<li>Embedded mode:</li>
</ol>
<code>jdbc:h2:~/test</code>
H2 db in embedded mode will be faster but the downside of it is that no other process can access the Database. In the above connection string, the Data will be saved into the ‘test’ folder, under the user’s home directory.
<ol start="3">
<li>Mixed mode:</li>
</ol>
The mixed mode combines some features of the embedded and the server mode. The first application connecting to the H2 db does that in embedded mode, but at the same time it starts a server so that other applications can concurrently access the same data, even from different processes.
<code>jdbc:h2:/data/test;AUTO_SERVER=TRUE</code>
When using automatic mixed mode, you can share the JDBC URL for all applications using the DB. By default the server uses any free TCP port. The port can be set manually using AUTO_SERVER_PORT=9090.

I am trying to use the H2 database from a Java application. 

I created the database and its tables through the H2 Console and then I try to connect from Java using 

<pre><code>Connection con = DriverManager.getConnection("jdbc:h2:~/dbname", "username", "password");
</code></pre>

However I receive the following error:

<blockquote>
 Exception in thread "main" org.h2.jdbc.JdbcSQLException: Database may be already in use: "Locked by another process". Possible solutions: close all other connection(s); use the server mode [90020-161]
</blockquote>

I tried to delete the <code>dbname.lock.db</code> file but it is automatically re-created.

How can I unlock the database to use it from my Java program?

H2 database error: Database may be already in use: "Locked by another process"

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我正在尝试使用来自Java应用程序的H2数据库。我通过H2控制台创建了数据库及其表，然后尝试使用Connection con = DriverManager.getConnection("jdbc:h2:~/dbname", "username", "password");但是，我收到以下错误：线程“主”org.h2....

问H2数据库错误:数据库可能已经在使用：“被另一个进程锁定”
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问H2数据库错误:数据库可能已经在使用：“被另一个进程锁定”EN