h2 mysql mode,H2数据库连接方式速查表

Topic

URL Format and Examples

jdbc:h2:[file:][]

jdbc:h2:~/test

jdbc:h2:file:/data/sample

jdbc:h2:file:C:/data/sample (Windows only)

jdbc:h2:mem:

jdbc:h2:mem:test_mem

jdbc:h2:tcp://[:]/[]

jdbc:h2:tcp://localhost/~/test

jdbc:h2:tcp://dbserv:8084/~/sample jdbc:h2:tcp://localhost/mem:test

jdbc:h2:ssl://[:]/

jdbc:h2:ssl://localhost:8085/~/sample;

jdbc:h2:;CIPHER=[AES|XTEA]

jdbc:h2:ssl://localhost/~/test;CIPHER=AES

jdbc:h2:file:~/secure;CIPHER=XTEA

jdbc:h2:;FILE_LOCK={FILE|SOCKET|NO}

jdbc:h2:file:~/private;CIPHER=XTEA;FILE_LOCK=SOCKET

jdbc:h2:;IFEXISTS=TRUE

jdbc:h2:file:~/sample;IFEXISTS=TRUE

jdbc:h2:;INIT=RUNSCRIPT FROM '~/create.sql'

jdbc:h2:file:~/sample;INIT=RUNSCRIPT FROM '~/create.sql'\\;RUNSCRIPT FROM '~/populate.sql'

jdbc:h2:[;USER=][;PASSWORD=]

jdbc:h2:file:~/sample;USER=sa;PASSWORD=123

jdbc:h2:;TRACE_LEVEL_FILE=

jdbc:h2:file:~/sample;TRACE_LEVEL_FILE=3

jdbc:h2:;IGNORE_UNKNOWN_SETTINGS=TRUE

jdbc:h2:;ACCESS_MODE_DATA=rws

jdbc:h2:zip:!/

jdbc:h2:zip:~/db.zip!/test

jdbc:h2:;MODE=

jdbc:h2:~/test;MODE=MYSQL

jdbc:h2:;AUTO_RECONNECT=TRUE

jdbc:h2:tcp://localhost/~/test;AUTO_RECONNECT=TRUE

jdbc:h2:;AUTO_SERVER=TRUE

jdbc:h2:~/test;AUTO_SERVER=TRUE

jdbc:h2:;PAGE_SIZE=512

jdbc:h2:;=[;=...] jdbc:h2:file:~/sample;TRACE_LEVEL_SYSTEM_OUT=3