mysql中使用h2_h2数据库使用及相关操作

2、启动

cd  H2\bin   h2.bat/.sh 启动

3、如需启动远程访问

h2.bat -webAllowOthers -webPort 8012 -tcpAllowOthers -tcpPort 8013 【端口自选】

4、异常处理

(1)、版本不同---解决方法 更换相同版本   1.3版本下载     1.4版本下载

07-18 16:39:32 jdbc: exception

org.h2.jdbc.JdbcSQLException: Connection is broken: "unexpected status 16842752" [90067-173]

at org.h2.message.DbException.getJdbcSQLException(DbException.java:331)

at org.h2.message.DbException.get(DbException.java:171)

at org.h2.message.DbException.get(DbException.java:148)

at org.h2.engine.SessionRemote.done(SessionRemote.java:594)

at org.h2.command.CommandRemote.prepare(CommandRemote.java:65)

at org.h2.command.CommandRemote.(CommandRemote.java:45)

at org.h2.engine.SessionRemote.prepareCommand(SessionRemote.java:449)

at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1142)

at org.h2.jdbc.J