hsql 서버 설치 과정
1. download : http://sourceforge.net/projects/hsqldb/files/ 에서 zip 파일 다운로드
2. server에 zip 파일 복사
3. unzip hsqldb-2.3.0.zip (테스트 서버 : 10.10.18.21:/data/server/hsql/hsqldb-2.3.0/hsqldb)
4. 서버 실행 (디폴트 포트 : 9001)
database with files named "mydb.*" and the public name of "xdb".
java -cp ../lib/hsqldb.jar org.hsqldb.server.Server --database.0 file:mydb --dbname.0 xdb
(설정 정보)
+-----------------+-------------+----------+------------------------------+
| OPTION | TYPE | DEFAULT | DESCRIPTION |
+-----------------+-------------+----------+------------------------------|
| --help | - | - | displays this message |
| --address | name|number | any | server inet address |
| --port | number | 9001/544 | port at which server listens |
| --database.i | [type]spec | 0=test | name of database i |
| --dbname.i | alias | - | url alias for database i |
| --silent | true|false | true | false => display all queries |
| --trace | true|false | false | display JDBC trace messages |
| --tls | true|false | false | TLS/SSL (secure) sockets |
| --no_system_exit| true|false | false | do not issue System.exit() |
| --remote_open | true|false | false | can open databases remotely |
| --props | filepath | | file path of properties file |
+-----------------+-------------+----------+------------------------------+
5. iptable 수정
5.1 /etc/sysconfig/iptables
추가 : -A RH-Firewall-1-INPUT -m state --state NEW -m tcp -p tcp --dport 9001 -j ACCEPT
5.2 /etc/init.d/iptables restart
6. 로컬 연결 테스트 (C:\Users\mspark\Desktop\hsqldb-2.3.0\hsqldb\bin\runManagerSwing)
6.1 url : jdbc:hsqldb:hsql://10.10.18.21/xdb
7. hsql 서버 properties 작업
(설정 정보)
Value Default Description
server.database.0 file:test the catalog type, path and file name of the first database file to use
server.dbname.0 "" lowercase server alias for the first database file
server.database.n NO DEFAULT the catalog type, path and file name of the n'th database file in use
server.dbname.n NO DEFAULT lowercase server alias for the n'th database file
server.silent true no extensive messages displayed on console
server.trace false JDBC trace messages displayed on console
server.address NO DEFAULT IP address of server
server.tls false Whether to encrypt network stream. If this is set to true, then in normal situations you will also need to set properties system.javax.net.ssl.keyStore and system.javax.net.ssl.keyStorePassword, as documented elsewhere. The value of server.tls impacts the default value of server.port.
server.daemon false Whether the server is run as a daemon
server.remote_open false Allows opening a database path remotely when the first connection is made
테스트 서버
1. server.properties
server.database.0 = file:admin4;user=konan
server.dbname.0 = admin4
2. run server
java -cp ../hsqldb/lib/hsqldb.jar org.hsqldb.server.Server --props server.properties
3. DDL - runManagerSwing 사용시 한번에 하나의 query만 처리 가능
2. server에 zip 파일 복사
3. unzip hsqldb-2.3.0.zip (테스트 서버 : 10.10.18.21:/data/server/hsql/hsqldb-2.3.0/hsqldb)
4. 서버 실행 (디폴트 포트 : 9001)
database with files named "mydb.*" and the public name of "xdb".
java -cp ../lib/hsqldb.jar org.hsqldb.server.Server --database.0 file:mydb --dbname.0 xdb
(설정 정보)
+-----------------+-------------+----------+------------------------------+
| OPTION | TYPE | DEFAULT | DESCRIPTION |
+-----------------+-------------+----------+------------------------------|
| --help | - | - | displays this message |
| --address | name|number | any | server inet address |
| --port | number | 9001/544 | port at which server listens |
| --database.i | [type]spec | 0=test | name of database i |
| --dbname.i | alias | - | url alias for database i |
| --silent | true|false | true | false => display all queries |
| --trace | true|false | false | display JDBC trace messages |
| --tls | true|false | false | TLS/SSL (secure) sockets |
| --no_system_exit| true|false | false | do not issue System.exit() |
| --remote_open | true|false | false | can open databases remotely |
| --props | filepath | | file path of properties file |
+-----------------+-------------+----------+------------------------------+
5. iptable 수정
5.1 /etc/sysconfig/iptables
추가 : -A RH-Firewall-1-INPUT -m state --state NEW -m tcp -p tcp --dport 9001 -j ACCEPT
5.2 /etc/init.d/iptables restart
6. 로컬 연결 테스트 (C:\Users\mspark\Desktop\hsqldb-2.3.0\hsqldb\bin\runManagerSwing)
6.1 url : jdbc:hsqldb:hsql://10.10.18.21/xdb
7. hsql 서버 properties 작업
(설정 정보)
Value Default Description
server.database.0 file:test the catalog type, path and file name of the first database file to use
server.dbname.0 "" lowercase server alias for the first database file
server.database.n NO DEFAULT the catalog type, path and file name of the n'th database file in use
server.dbname.n NO DEFAULT lowercase server alias for the n'th database file
server.silent true no extensive messages displayed on console
server.trace false JDBC trace messages displayed on console
server.address NO DEFAULT IP address of server
server.tls false Whether to encrypt network stream. If this is set to true, then in normal situations you will also need to set properties system.javax.net.ssl.keyStore and system.javax.net.ssl.keyStorePassword, as documented elsewhere. The value of server.tls impacts the default value of server.port.
server.daemon false Whether the server is run as a daemon
server.remote_open false Allows opening a database path remotely when the first connection is made
테스트 서버
1. server.properties
server.database.0 = file:admin4;user=konan
server.dbname.0 = admin4
2. run server
java -cp ../hsqldb/lib/hsqldb.jar org.hsqldb.server.Server --props server.properties
3. DDL - runManagerSwing 사용시 한번에 하나의 query만 처리 가능
댓글
댓글 쓰기