H2数据库连接方式速查表
来源:互联网 发布:mac散热在哪 编辑:程序博客网 时间:2024/04/28 09:40
转至官方文档
Topic
URL Format and Examples
Embedded (local) connection
jdbc:h2:[file:][<path>]<databaseName>
jdbc:h2:~/test
jdbc:h2:file:/data/sample
jdbc:h2:file:C:/data/sample (Windows only)
In-memory (private)
jdbc:h2:mem:
In-memory (named)
jdbc:h2:mem:<databaseName>
jdbc:h2:mem:test_mem
Server mode (remote connections) using TCP/IP
jdbc:h2:tcp://<server>[:<port>]/[<path>]<databaseName>
jdbc:h2:tcp://localhost/~/test
jdbc:h2:tcp://dbserv:8084/~/sample jdbc:h2:tcp://localhost/mem:test
Server mode (remote connections) using SSL/TLS
jdbc:h2:ssl://<server>[:<port>]/<databaseName>
jdbc:h2:ssl://localhost:8085/~/sample;
Using encrypted files
jdbc:h2:<url>;CIPHER=[AES|XTEA]
jdbc:h2:ssl://localhost/~/test;CIPHER=AES
jdbc:h2:file:~/secure;CIPHER=XTEA
File locking methods
jdbc:h2:<url>;FILE_LOCK={FILE|SOCKET|NO}
jdbc:h2:file:~/private;CIPHER=XTEA;FILE_LOCK=SOCKET
Only open if it already exists
jdbc:h2:<url>;IFEXISTS=TRUE
jdbc:h2:file:~/sample;IFEXISTS=TRUE
Don't close the database when the VM exits
jdbc:h2:<url>;DB_CLOSE_ON_EXIT=FALSE
Execute SQL on connection
jdbc:h2:<url>;INIT=RUNSCRIPT FROM '~/create.sql'
jdbc:h2:file:~/sample;INIT=RUNSCRIPT FROM '~/create.sql'\\;RUNSCRIPT FROM '~/populate.sql'
User name and/or password
jdbc:h2:<url>[;USER=<username>][;PASSWORD=<value>]
jdbc:h2:file:~/sample;USER=sa;PASSWORD=123
Debug trace settings
jdbc:h2:<url>;TRACE_LEVEL_FILE=<level 0..3>
jdbc:h2:file:~/sample;TRACE_LEVEL_FILE=3
Ignore unknown settings
jdbc:h2:<url>;IGNORE_UNKNOWN_SETTINGS=TRUE
Custom file access mode
jdbc:h2:<url>;ACCESS_MODE_DATA=rws
Database in a zip file
jdbc:h2:zip:<zipFileName>!/<databaseName>
jdbc:h2:zip:~/db.zip!/test
Compatibility mode
jdbc:h2:<url>;MODE=<databaseType>
jdbc:h2:~/test;MODE=MYSQL
Auto-reconnect
jdbc:h2:<url>;AUTO_RECONNECT=TRUE
jdbc:h2:tcp://localhost/~/test;AUTO_RECONNECT=TRUE
Automatic mixed mode
jdbc:h2:<url>;AUTO_SERVER=TRUE
jdbc:h2:~/test;AUTO_SERVER=TRUE
Page size
jdbc:h2:<url>;PAGE_SIZE=512
Changing other settings
jdbc:h2:<url>;<setting>=<value>[;<setting>=<value>...]
jdbc:h2:file:~/sample;TRACE_LEVEL_SYSTEM_OUT=3
- H2数据库连接方式速查表
- H2数据库连接失败
- H2数据库连接缓慢,无响应
- H2数据库启动方式
- hibernate辅导教程H2数据库连接 URL说明
- H2数据库自定义函数方式
- H2 连接方式、简单使用
- 数据库连接方式
- 数据库连接方式
- 数据库连接方式
- 数据库连接方式
- 数据库连接方式
- 数据库连接方式
- 数据库连接方式
- H2
- H2
- H2
- ASP数据库连接方式大全
- Android与服务器端数据交互(http协议整合struts2+android)
- c++多线程例(事件同步对象,变量共享)
- Oracle内建函数(greatest, least, to_single_byte)
- 文本匹配
- 一个简单的线程池
- H2数据库连接方式速查表
- Learning XPath
- Jar 主类
- SQL server 2000创建数据库角色以及向数据库角色添加用户的命令
- MapReduce 具有部分代数性质的整体度量的立方体生成
- hibernate查询也要提交事务
- loadrunner编写脚本
- What’s the difference between a class variable and an instance variable?
- Tiptop GP中如何opendialog