h2
启动h2数据库服务器=>实际上启动驱动jar包;cd D:\java\saiku-server\tomcat9\myapp\saiku-webapp\WEB-INF\libd:java -classpath h2-1.4.188.jar org.h2.tools.Server -?
启动h2数据库web控制台java -classpath h2-1.4.188.jar org.h2.tools.Console -web提示:Web Console server running at http : // 192.168.6.69:8082 (only local connections)
在查询框里输入select * from 'account'点击run=>可以看到查询结果。这里注意表名要带上双引号,否则会报如下错误。Table 'DAYS' not found; SQL statement:select * from days [42102-188] 42S02/42102 (Help)org.h2.jdbc.JdbcSQLException: Table 'DAYS' not found; SQL statement:select * from days [42102-188] at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
tcp方式启动h2:java -classpath h2-1.4.188.jar org.h2.tools.Server -tcp提示TCP server running at tcp : //192.168.6.69:9092 (only local connections)
指定端口启动java -classpath h2-1.4.188.jar org.h2.tools.Server -tcp -tcpPort 9092匿名ssl方式启动java -classpath h2-1.4.188.jar org.h2.tools.Server -tcp -tcpPort 9092 -tcpAllowOthers -tcpSSLssl双向认证启动,用得比较少,需要先生成证书,这里不叙述。