从DbVisualizer连接到H2服务器 [英] Connecting to H2 server from DbVisualizer
本文介绍了从DbVisualizer连接到H2服务器的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我已经按照以下方式配置了我的H2数据库：
I have configured my H2 database as follows:
@Configuration
@Profile({ Profiles.DEV })
public class DevDataSourceConfiguration {
@Bean(initMethod = "start", destroyMethod = "stop")
public Server h2WebServer() throws SQLException {
return Server.createWebServer("-web", "-webAllowOthers", "-webPort", "8082");
}
@Bean(initMethod = "start", destroyMethod = "stop")
@DependsOn("h2WebServer")
public Server h2Server() throws SQLException {
return Server.createTcpServer("-tcp", "-tcpAllowOthers", "-tcpPort", "9092");
}
@Bean
@DependsOn("h2Server")
public DataSource datasource() {
HikariDataSource ds = new HikariDataSource();
ds.setDriverClassName("org.h2.Driver");
ds.setJdbcUrl("jdbc:h2:tcp://localhost/~/bignibou");
return ds;
}
}
我现在正在尝试使用以下方法从DBVisualizer访问数据库以下jdbc URL： jdbc：h2：tcp：// localhost /〜/ bignibou ，我在dbvis日志中得到以下错误：
I am now trying to access my database from DBVisualizer using the following jdbc URL: jdbc:h2:tcp://localhost/~/bignibou and I get the following error in dbvis logs:
2015-05-17 17:02:24.544 WARN 595 [ExecutorRunner-pool-3-thread-11 - G.ￄﾃ] Could not setAutoCommit(true) for: bignibou
org.h2.jdbc.JdbcSQLException: Connection is broken: "unexpected status 16777216" [90067-176]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:344)
at org.h2.message.DbException.get(DbException.java:178)
at org.h2.message.DbException.get(DbException.java:154)
at org.h2.engine.SessionRemote.done(SessionRemote.java:621)
at org.h2.command.CommandRemote.prepare(CommandRemote.java:69)
at org.h2.command.CommandRemote.<init>(CommandRemote.java:46)
at org.h2.engine.SessionRemote.prepareCommand(SessionRemote.java:476)
at org.h2.engine.SessionRemote.setAutoCommitSend(SessionRemote.java:243)
at org.h2.engine.SessionRemote.setAutoCommit(SessionRemote.java:210)
at org.h2.jdbc.JdbcConnection.setAutoCommit(JdbcConnection.java:431)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at com.onseven.dbvis.h.B.C.ￄﾁ(Z:2206)
at com.onseven.dbvis.h.B.F$A.call(Z:2515)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
2015-05-17 17:02:24.546 INFO 595 [ExecutorRunner-pool-3-thread-11 - AbstractFacade.getCatalog] Could not getCatalog for: bignibou
org.h2.jdbc.JdbcSQLException: Connection is broken: "unexpected status 16777216" [90067-176]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:344)
at org.h2.message.DbException.get(DbException.java:178)
at org.h2.message.DbException.get(DbException.java:154)
at org.h2.engine.SessionRemote.done(SessionRemote.java:621)
at org.h2.command.CommandRemote.prepare(CommandRemote.java:69)
at org.h2.command.CommandRemote.<init>(CommandRemote.java:46)
at org.h2.engine.SessionRemote.prepareCommand(SessionRemote.java:476)
at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1188)
at org.h2.jdbc.JdbcConnection.getCatalog(JdbcConnection.java:598)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at com.onseven.dbvis.h.B.C.ￄﾁ(Z:2206)
at com.onseven.dbvis.h.B.F$A.call(Z:2515)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
编辑：这是将; trace_level_system_out = 3 添加到连接URL后得到的日志输出：
edit: Here is the log output I get after adding ;trace_level_system_out=3 to the connection url:
2015-05-26 12:25:13.601 INFO 159 [pool-3-thread-8 - Q.flush] 05-26 12:25:13 jdbc:
/**/Connection conn1 = DriverManager.getConnection("jdbc:h2:tcp://localhost/~/bignibou;trace_level_system_out=3", "", "");
2015-05-26 12:25:13.602 INFO 159 [pool-3-thread-8 - Q.flush] 05-26 12:25:13 jdbc:
/**/DatabaseMetaData dbMeta1 = conn1.getMetaData();
2015-05-26 12:25:13.602 INFO 159 [pool-3-thread-8 - Q.flush] 05-26 12:25:13 jdbc:
/**/conn1.setAutoCommit(true);
2015-05-26 12:25:13.602 INFO 159 [pool-3-thread-8 - Q.flush] 05-26 12:25:13 jdbc: SESSION_PREPARE_READ_PARAMS 0
2015-05-26 12:25:13.603 INFO 159 [pool-3-thread-8 - Q.flush] 05-26 12:25:13 jdbc: exception
2015-05-26 12:25:13.603 INFO 159 [pool-3-thread-8 - Q.flush] org.h2.jdbc.JdbcSQLException: Connection is broken: "unexpected status 16777216" [90067-176]
2015-05-26 12:25:13.603 INFO 159 [pool-3-thread-8 - Q.flush] at org.h2.message.DbException.getJdbcSQLException(DbException.java:344)
2015-05-26 12:25:13.603 INFO 159 [pool-3-thread-8 - Q.flush] at org.h2.message.DbException.get(DbException.java:178)
2015-05-26 12:25:13.603 INFO 159 [pool-3-thread-8 - Q.flush] at org.h2.message.DbException.get(DbException.java:154)
2015-05-26 12:25:13.603 INFO 159 [pool-3-thread-8 - Q.flush] at org.h2.engine.SessionRemote.done(SessionRemote.java:621)
2015-05-26 12:25:13.603 INFO 159 [pool-3-thread-8 - Q.flush] at org.h2.command.CommandRemote.prepare(CommandRemote.java:69)
2015-05-26 12:25:13.603 INFO 159 [pool-3-thread-8 - Q.flush] at org.h2.command.CommandRemote.<init>(CommandRemote.java:46)
2015-05-26 12:25:13.603 INFO 159 [pool-3-thread-8 - Q.flush] at org.h2.engine.SessionRemote.prepareCommand(SessionRemote.java:476)
2015-05-26 12:25:13.603 INFO 159 [pool-3-thread-8 - Q.flush] at org.h2.engine.SessionRemote.setAutoCommitSend(SessionRemote.java:243)
2015-05-26 12:25:13.603 INFO 159 [pool-3-thread-8 - Q.flush] at org.h2.engine.SessionRemote.setAutoCommit(SessionRemote.java:210)
2015-05-26 12:25:13.604 INFO 159 [pool-3-thread-8 - Q.flush] at org.h2.jdbc.JdbcConnection.setAutoCommit(JdbcConnection.java:431)
2015-05-26 12:25:13.604 INFO 159 [pool-3-thread-8 - Q.flush] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
2015-05-26 12:25:13.604 INFO 159 [pool-3-thread-8 - Q.flush] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
2015-05-26 12:25:13.604 INFO 159 [pool-3-thread-8 - Q.flush] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
2015-05-26 12:25:13.604 INFO 159 [pool-3-thread-8 - Q.flush] at java.lang.reflect.Method.invoke(Method.java:497)
2015-05-26 12:25:13.604 INFO 159 [pool-3-thread-8 - Q.flush] at com.onseven.dbvis.h.B.C.ￄﾁ(Z:2206)
2015-05-26 12:25:13.604 INFO 159 [pool-3-thread-8 - Q.flush] at com.onseven.dbvis.h.B.F$A.call(Z:2515)
2015-05-26 12:25:13.604 INFO 159 [pool-3-thread-8 - Q.flush] at java.util.concurrent.FutureTask.run(FutureTask.java:266)
2015-05-26 12:25:13.604 INFO 159 [pool-3-thread-8 - Q.flush] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
2015-05-26 12:25:13.604 INFO 159 [pool-3-thread-8 - Q.flush] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
2015-05-26 12:25:13.604 INFO 159 [pool-3-thread-8 - Q.flush] at java.lang.Thread.run(Thread.java:745)
2015-05-26 12:25:13.604 WARN 159 [ExecutorRunner-pool-2-thread-2 - G.ￄﾃ] Could not setAutoCommit(true) for: bignibou
org.h2.jdbc.JdbcSQLException: Connection is broken: "unexpected status 16777216" [90067-176]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:344)
at org.h2.message.DbException.get(DbException.java:178)
at org.h2.message.DbException.get(DbException.java:154)
at org.h2.engine.SessionRemote.done(SessionRemote.java:621)
at org.h2.command.CommandRemote.prepare(CommandRemote.java:69)
at org.h2.command.CommandRemote.<init>(CommandRemote.java:46)
at org.h2.engine.SessionRemote.prepareCommand(SessionRemote.java:476)
at org.h2.engine.SessionRemote.setAutoCommitSend(SessionRemote.java:243)
at org.h2.engine.SessionRemote.setAutoCommit(SessionRemote.java:210)
at org.h2.jdbc.JdbcConnection.setAutoCommit(JdbcConnection.java:431)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at com.onseven.dbvis.h.B.C.ￄﾁ(Z:2206)
at com.onseven.dbvis.h.B.F$A.call(Z:2515)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
2015-05-26 12:25:13.605 INFO 159 [pool-3-thread-8 - Q.flush] 05-26 12:25:13 jdbc:
/**/conn1.isClosed();
2015-05-26 12:25:13.605 INFO 159 [pool-3-thread-8 - Q.flush] 05-26 12:25:13 jdbc:
/**/conn1.getAutoCommit();
2015-05-26 12:25:13.608 INFO 159 [ExecutorRunner-pool-2-thread-2 - Q.flush] 05-26 12:25:13 jdbc:
/**/dbMeta1.getSearchStringEscape();
2015-05-26 12:25:13.608 INFO 159 [pool-3-thread-8 - Q.flush] 05-26 12:25:13 jdbc:
/**/conn1.isClosed();
2015-05-26 12:25:13.608 INFO 159 [pool-3-thread-8 - Q.flush] 05-26 12:25:13 jdbc:
/**/conn1.getAutoCommit();
2015-05-26 12:25:13.608 INFO 159 [pool-3-thread-8 - Q.flush] 05-26 12:25:13 jdbc:
/**/conn1.getCatalog();
2015-05-26 12:25:13.608 INFO 159 [pool-3-thread-8 - Q.flush] 05-26 12:25:13 jdbc: SESSION_PREPARE_READ_PARAMS 1
2015-05-26 12:25:13.608 INFO 159 [pool-3-thread-8 - Q.flush] 05-26 12:25:13 jdbc: exception
2015-05-26 12:25:13.609 INFO 159 [pool-3-thread-8 - Q.flush] org.h2.jdbc.JdbcSQLException: Connection is broken: "unexpected status 16777216" [90067-176]
2015-05-26 12:25:13.609 INFO 159 [pool-3-thread-8 - Q.flush] at org.h2.message.DbException.getJdbcSQLException(DbException.java:344)
2015-05-26 12:25:13.609 INFO 159 [pool-3-thread-8 - Q.flush] at org.h2.message.DbException.get(DbException.java:178)
2015-05-26 12:25:13.609 INFO 159 [pool-3-thread-8 - Q.flush] at org.h2.message.DbException.get(DbException.java:154)
2015-05-26 12:25:13.609 INFO 159 [pool-3-thread-8 - Q.flush] at org.h2.engine.SessionRemote.done(SessionRemote.java:621)
2015-05-26 12:25:13.609 INFO 159 [pool-3-thread-8 - Q.flush] at org.h2.command.CommandRemote.prepare(CommandRemote.java:69)
2015-05-26 12:25:13.609 INFO 159 [pool-3-thread-8 - Q.flush] at org.h2.command.CommandRemote.<init>(CommandRemote.java:46)
2015-05-26 12:25:13.609 INFO 159 [pool-3-thread-8 - Q.flush] at org.h2.engine.SessionRemote.prepareCommand(SessionRemote.java:476)
2015-05-26 12:25:13.609 INFO 159 [pool-3-thread-8 - Q.flush] at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1188)
2015-05-26 12:25:13.609 INFO 159 [pool-3-thread-8 - Q.flush] at org.h2.jdbc.JdbcConnection.getCatalog(JdbcConnection.java:598)
2015-05-26 12:25:13.609 INFO 159 [pool-3-thread-8 - Q.flush] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
2015-05-26 12:25:13.609 INFO 159 [pool-3-thread-8 - Q.flush] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
2015-05-26 12:25:13.609 INFO 159 [pool-3-thread-8 - Q.flush] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
2015-05-26 12:25:13.609 INFO 159 [pool-3-thread-8 - Q.flush] at java.lang.reflect.Method.invoke(Method.java:497)
2015-05-26 12:25:13.609 INFO 159 [pool-3-thread-8 - Q.flush] at com.onseven.dbvis.h.B.C.ￄﾁ(Z:2206)
2015-05-26 12:25:13.610 INFO 159 [pool-3-thread-8 - Q.flush] at com.onseven.dbvis.h.B.F$A.call(Z:2515)
2015-05-26 12:25:13.610 INFO 159 [pool-3-thread-8 - Q.flush] at java.util.concurrent.FutureTask.run(FutureTask.java:266)
2015-05-26 12:25:13.610 INFO 159 [pool-3-thread-8 - Q.flush] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
2015-05-26 12:25:13.610 INFO 159 [pool-3-thread-8 - Q.flush] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
2015-05-26 12:25:13.610 INFO 159 [pool-3-thread-8 - Q.flush] at java.lang.Thread.run(Thread.java:745)
2015-05-26 12:25:13.610 INFO 159 [ExecutorRunner-pool-2-thread-2 - AbstractFacade.getCatalog] Could not getCatalog for: bignibou
org.h2.jdbc.JdbcSQLException: Connection is broken: "unexpected status 16777216" [90067-176]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:344)
at org.h2.message.DbException.get(DbException.java:178)
at org.h2.message.DbException.get(DbException.java:154)
at org.h2.engine.SessionRemote.done(SessionRemote.java:621)
at org.h2.command.CommandRemote.prepare(CommandRemote.java:69)
at org.h2.command.CommandRemote.<init>(CommandRemote.java:46)
at org.h2.engine.SessionRemote.prepareCommand(SessionRemote.java:476)
at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1188)
at org.h2.jdbc.JdbcConnection.getCatalog(JdbcConnection.java:598)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at com.onseven.dbvis.h.B.C.ￄﾁ(Z:2206)
at com.onseven.dbvis.h.B.F$A.call(Z:2515)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
2015-05-26 12:25:13.611 INFO 159 [pool-3-thread-8 - Q.flush] 05-26 12:25:13 jdbc:
/**/conn1.isClosed();
2015-05-26 12:25:13.611 INFO 159 [pool-3-thread-8 - Q.flush] 05-26 12:25:13 jdbc:
/**/conn1.getAutoCommit();
2015-05-26 12:25:13.611 INFO 159 [pool-3-thread-8 - Q.flush] 05-26 12:25:13 jdbc:
/**/Statement stat1 = conn1.createStatement();
2015-05-26 12:25:13.611 INFO 159 [pool-3-thread-8 - Q.flush] 05-26 12:25:13 jdbc:
/**/ResultSet rs1 = stat1.executeQuery("call schema()");
2015-05-26 12:25:13.611 INFO 159 [pool-3-thread-8 - Q.flush] 05-26 12:25:13 jdbc: SESSION_PREPARE_READ_PARAMS 2
编辑2 ：我也注意到了这一点（在应用程序控制台日志中）：
edit 2: I also noticed this (in the application console logs):
05-26 12:25:13 database: connecting session #14 to /Users/julien/bignibou
05-26 12:25:13 jdbc[14]:
/*SQL */SET TRACE_LEVEL_SYSTEM_OUT 3;
05-26 12:29:04 jdbc[13]:
/*SQL */ROLLBACK;
05-26 12:29:04 jdbc[14]:
/*SQL */ROLLBACK;
05-26 12:29:04 database: disconnecting session #14
05-26 12:29:04 database: disconnected session #14
05-26 12:29:04 database: disconnecting session #13
05-26 12:29:04 database: disconnected session #13
推荐答案
- 最新H2稳定发行版：1.3.176。
- 最新dbVisualizer H2驱动程序：1.3.176。 >
- Latest H2 stable release: 1.3.176.
- Latest dbVisualizer H2 driver: 1.3.176.
可能您正在使用H2的beta版本（1.4.x），但在客户端/服务器通讯中存在一些错误（不匹配的版本不应为这是一个问题，因为客户端和服务器会协商使用哪个协议版本）尝试使用H2的最新Beta版本还是使用H2的最新稳定版本。
Probably you are using a the beta release of H2 (1.4.x) with some bug in the client/server communication (mismatching versions should not be a problem because the client and server negotiate which protocol version to use) try using the latest beta release from H2 or use the latest stable release of H2.
这篇关于从DbVisualizer连接到H2服务器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
