Tibero to Mysql DBLINK搭建手册

Windows环境

*建议tibero6 FS07以后的版本

 

1. 解压 %TB_HOME%\client\bin\tbJavaGW.zip

 

2. tbJavaGW\lib下放入mysql jdbc驱动包 ， tbJavaGW下放入prunsrv.exe执行文件

 

3. jgw.cfg配置

# Target database
DATABASE=MYSQL

DATASOURCE_CLASS_NAME=com.mysql.jdbc.jdbc2.optional.MysqlDataSource

# Listener port
LISTENER_PORT=19093

# Initial thread pool size
INIT_POOL_SIZE=10

# Max thread pool size
MAX_POOL_SIZE=10

# Max cursor cache size per thread
MAX_CURSOR_CACHE_SIZE=100

# Gateway Encoding-"ASCII", "EUC-KR", "MSWIN949", "UTF-8", "UTF-16", "SHIFT-JIS"
ENCODING=UTF-8

 

4. jgw_service.bat配置

:: setting CLASSPATH
set JAVA_GATEWAY="%JGW_LIB_PATH%\tbgateway.jar"
set COMMONS_DAEMON="%JGW_LIB_PATH%\commons-daemon-1.0.6.jar"
set COMMONS_COLLECTIONS="%JGW_LIB_PATH%\commons-collections.jar"
set COMMONS_POOL="%JGW_LIB_PATH%\commons-pool.jar"
set LOG4J="%JGW_LIB_PATH%\log4j-1.2.15.jar"
set MSSQL_JDBC="%JGW_LIB_PATH%\sqljdbc.jar";"%JGW_LIB_PATH%\sqljdbc4.jar"
set SYBASE_JDBC="%JGW_LIB_PATH%\jconn3.jar"
set GREENPLUM_JDBC="%JGW_LIB_PATH%\postgresql-8.4-701.jdbc3.jar"
set MYSQL_JDBC="%JGW_LIB_PATH%\mysql-connector-java-5.1.34-bin.jar"
set JGW_CLASSPATH=%JAVA_GATEWAY%;%COMMONS_DAEMON%;%COMMONS_COLLECTIONS%;%COMMONS_POOL%;%LOG4J%;%MSSQL_JDBC%;%SYBASE_JDBC%;%GREENPLUM_JDBC%;%MYSQL_JDBC%

:: setting SERVICE values
set JGW_SRVC_NAME="TBGateway"
set JGW_SRVC_DISP_NAME="TmaxDataJavaGateway"
set JGW_SRVC_DESC="Service of JAVA Gateway for TmaxData."

:: setting PROCRUN variables
set PR_EXEC="%JGW_HOME_PATH%\prunsrv.exe"
set PR_STDOUT="%JGW_LOG_PATH%\jgw_service.out"
set PR_STDERR="%JGW_LOG_PATH%\jgw_service.err"
set PR_START_CLASS="com.tmax.tibero.gateway.main.GatewayMain"
set PR_START_METHOD="start"
set PR_START_PARAMS="CONFIG=.\jgw.cfg"
set PR_STOP_CLASS="com.tmax.tibero.gateway.main.GatewayMain"
set PR_STOP_METHOD="stop"
set PR_JVM_OPTIONS="-Dlog4j.configuration=file:jgwlog.properties"
set PR_LOG_LEVEL=ALL
set PR_LOG_PATH="%JGW_LOG_PATH%"

 

5. 注册gate服务

打开cmd, 执行 jgw_service.bat install

 

6. 启动gateway服务

 

7. 修改tbdsn.tbr文件后重启tibero

mysql_link_remote=(
                 (GATEWAY=(LISTENER=(HOST=localhost)
                                    (PORT=19093))
                          (TARGET=1.2.3.4:3306:herb)
                          (TX_MODE=LOCAL))
)

 

8. 进入tbsql 创建dblink

create public database link mysql connect to 'cuiwenhao' identified by 'cuiwenhao' using 'mysql_link_remote';