본 문서에서는 Tibero Java Gateway을 이용한 Tibero to PostgreSQL DB Link 설정 및 테스트 환경 구축을 위한 PostgreSQL 설치 방법을 안내합니다.
테스트 구성 환경
| OS | PostgreSQL | Java Gateway | Tibero |
| Version : Red Hat Enterprise Linux Server release 7.4IP : 192.168.0.180 | Version : PostgreSQL 12.3OS user : postgresDB name : testDB user : pgPort : 5432 | Port : 9099 | Version : Tibero 6 (DB 6.0 FS07_CS_1912)OS user : namDB name : tiberoDB user : namPort : 18629 |
DBLink 설정 및 확인
1. Java Gateway
1.1. tbJavaGW.zip 압축 해제
[nam@www:/home/nam/tibero6/client/bin]$ unzip tbJavaGW.zip
Archive: tbJavaGW.zip
creating: tbJavaGW/
creating: tbJavaGW/lib/
inflating: tbJavaGW/jgw.cfg
inflating: tbJavaGW/jgw_service.bat
inflating: tbJavaGW/jgwlog.properties
inflating: tbJavaGW/lib/commons-collections.jar
inflating: tbJavaGW/lib/commons-daemon-1.0.6.jar
inflating: tbJavaGW/lib/commons-pool.jar
inflating: tbJavaGW/lib/log4j-1.2.15.jar
inflating: tbJavaGW/lib/tbgateway.jar
inflating: tbJavaGW/tbgw
1.2. Java Gateway 설정
[nam@www:/home/nam/tibero6/client/bin/tbJavaGW]$ vi jgw.cfg
# Target database
DATABASE=POSTGRESQL
# Datasource class name for target database
# use with DATABASE=JDBC30 option.
#DATASOURCE_CLASS_NAME=com.tmax.tibero.jdbc.ext.TbDataSource
# XA datasource class name for target database
# use with DATABASE=JDBC30 option.
#XA_DATASOURCE_CLASS_NAME=com.tmax.tibero.jdbc.ext.TbXADataSource
# Listener port
LISTENER_PORT=9099
# Initial thread pool size
INIT_POOL_SIZE=10
# Max thread pool size
MAX_POOL_SIZE=100
# Max cursor cache size per thread
MAX_CURSOR_CACHE_SIZE=100
# Gateway Encoding-“ASCII”, “EUC-KR”, “MSWIN949”, “UTF-8”, “UTF-16”, “SHIFT-JIS”
ENCODING=MSWIN949
# Max length for Types.LONGVARCHAR
MAX_LONGVARCHAR=4K
# Max length for Types.LONGRAW
MAX_LONGRAW=4K
1.3. Postgres JDBC 업로드
아래 링크를 참고해 JDK 버전에 맞는 JDBC를 사용합니다.
https://jdbc.postgresql.org/download/
[nam@www:/home/nam/tibero6/client/bin/tbJavaGW/lib]$ ls -al
total 3028
drwxr-xr-x 2 nam dba 4096 Nov 4 13:44 .
drwxr-xr-x 4 nam dba 4096 Nov 5 09:46 ..
-rw-r–r– 1 nam dba 559366 Dec 8 2020 commons-collections.jar
-rw-r–r– 1 nam dba 24019 Dec 8 2020 commons-daemon-1.0.6.jar
-rw-r–r– 1 nam dba 42492 Dec 8 2020 commons-pool.jar
-rw-r–r– 1 nam dba 391834 Dec 8 2020 log4j-1.2.15.jar
-rw-r–r– 1 nam dba 906887 Nov 3 15:11 postgresql-42.2.8.jre7.jar
-rw-r–r– 1 nam dba 483205 Dec 8 2020 tbgateway.jar
1.4. tbgw 수정
[nam@www:/home/nam/tibero6/client/bin/tbJavaGW]$ vi tbgw
#! /bin/sh
#Classpath
commonsdaemon=./lib/commons-daemon-1.0.6.jar
commonspool=./lib/commons-pool.jar
commonscollections=./lib/commons-collections.jar
log4j=./lib/log4j-1.2.15.jar
msjdbc=./lib/sqljdbc.jar:./lib/sqljdbc4.jar
asejdbc=./lib/jconn3.jar
postgresqljdbc=./lib/postgresql-42.2.8.jre7.jar
gateway=./lib/tbgateway.jar
#log4j properties
#log4jfile must be exists on classpath
log4jfile=jgwlog.properties
#Main Class
mainclass=com.tmax.tibero.gateway.main.GatewayMain
configfile=./jgw.cfg
if [[ $# -gt 0 ]] && [[ $1 = “-v” ]] ; then
java -jar $gateway
else
java -Xms128m -Xmx512m -Dlog4j.configuration=$log4jfile -classpath
$commonsdaemon:$commonspool:$commonscollections:$log4j:$gateway:$msjdbc:$asejdbc:
$postgresqljdbc:. $mainclass CONFIG=$configfile $* &sleep 1
fi
1.5. tbgw 실행
[nam@www:/home/nam/tibero6/client/bin/tbJavaGW]$ ./tbgw
——————————-
Name : TmaxData JAVA GATEWAY
Database: 5
Port : 9099
——————————-
☞ “[Tibero] DBLINK 설정_Tibero to PostgreSQL (2)”에서 계속됩니다.
