This database supports multiple connection modes and connection settings. This is achieved using different database URLs.Settings in the URLs are not case sensitive.
Topic URL Format and ExamplesEmbedded (local) connectionjdbc:h2:[file:][<path>]<databaseName>jdbc:h2:~/testjdbc:h2:file:/data/samplejdbc: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) usingTCP/IPjdbc:h2:tcp://<server>[:<port>]/[<path>]<databaseName>jdbc:h2:tcp://localhost/~/testjdbc:h2:tcp://dbserv:8084/~/sample jdbc:h2:tcp://localhost/mem:test
Server mode (remote connections) usingSSL/TLSjdbc:h2:ssl://<server>[:<port>]/<databaseName>jdbc:h2:ssl://secureserv:8085/~/sample;
Using encrypted filesjdbc:h2:<url>;CIPHER=[AES|XTEA]jdbc:h2:ssl://secureserv/~/testdb;CIPHER=AESjdbc: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=TRUEjdbc:h2:file:~/sample;IFEXISTS=TRUE
Don't close the database when the VMexits jdbc:h2:<url>;DB_CLOSE_ON_EXIT=FALSE
Execute SQL on connectionjdbc: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=TRUEjdbc:h2:tcp://localhost/~/test;AUTO_RECONNECT=TRUE
Automatic mixed mode jdbc:h2:<url>;AUTO_SERVER=TRUEjdbc: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 Documentation文档的37页。
