当JDBC中没有明确的内容时,h2的默认用户名和密码是什么? [英] What is the default username and password for h2 when there's nothing explicit in JDBC?
本文介绍了当JDBC中没有明确的内容时,h2的默认用户名和密码是什么?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我从一个程序创建了一个H2数据库,但未在JDBC URL中指定任何用户或密码.
From a program, I created a H2 database without specifying any user or password in the JDBC URL.
现在,我正在尝试使用脚本工具访问该数据库.该文档说在默认情况下使用-user sa
.那是行不通的,如果我添加-password sa
或删除-user
,它仍然行不通.我想念什么?
Now I'm trying to access that database with the Script tool. The doc says to use -user sa
in the default case. That doesn't work, and it still doesn't work if I either add -password sa
or remove -user
. What am I missing?
/opt/h2/bin java -cp h2-1.3.161.jar org.h2.tools.Script -url jdbc:h2:/data/jug/jas-coref.h2 -user sa -password sa -script /data/jug/ris-start.sql
Exception in thread "main" org.h2.jdbc.JdbcSQLException: Wrong user name or password [28000-161]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
at org.h2.message.DbException.get(DbException.java:169)
at org.h2.message.DbException.get(DbException.java:146)
at org.h2.message.DbException.get(DbException.java:135)
at org.h2.engine.Engine.validateUserAndPassword(Engine.java:301)
at org.h2.engine.Engine.createSessionAndValidate(Engine.java:146)
at org.h2.engine.Engine.createSession(Engine.java:121)
at org.h2.engine.Engine.createSession(Engine.java:28)
at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:285)
at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:110)
at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:94)
at org.h2.Driver.connect(Driver.java:72)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at org.h2.tools.Script.execute(Script.java:152)
at org.h2.tools.Script.execute(Script.java:133)
at org.h2.tools.Script.runTool(Script.java:101)
at org.h2.tools.Script.main(Script.java:51)
推荐答案
好吧,那没多久.
答案是-user ""
.
这篇关于当JDBC中没有明确的内容时,h2的默认用户名和密码是什么?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文