Skip to main content

Search

Welcome to Tibero GTS!

How to Set Up JAVA Gateway for DBLink (tibero to altibase)

Document TypeㅣTechnical Information

CategoryㅣInterface/Integration

Applicable Product Versionㅣ6FS07

Document NumberㅣTIITI027

 

Overview

ALTIBASE, like MS-SQL SERVER and Sybase ASE, can use the DBLink feature provided by TIBERO RDBMS through JAVA GATEWAY.
 
This document guides you through the tbdsn.tbr configuration and tbgw execution after installing JAVA GATEWAY to use TIBERO TO ALTIBASE DBLink.
Note
You can find the JAVA GATEWAY installation method in the article ‘JAVA gateway installation method for dblink (tibero to altibase)’.
 
This document is based on the following conditions.
  • Tibero : 6 FS07_CS_2005
  • Altibase: 7.1.0.8.0
 
 

Method

1. Add Configuration in $TB_HOME/client/config/tbdsn.tbr

During testing for this document, the environment settings (IP:PORT:DBNAME) were confirmed as below. These details may vary depending on your installation environment.
  • Tibero server info: 192.168.16.240:8629:tibero
  • Altibase server info: 192.168.16.150:20300:mydb
 
Contents of $TB_HOME/client/config/tbdsn.tbr
tibero=(
 (INSTANCE=(HOST=192.168.16.240)
 (PORT=8629)
 (DB_NAME=tibero)
 )
)

#Additional content#
alti=(
 (GATEWAY=(LISTENER=
 (HOST=192.168.16.240)
 (PORT=9093))
 (TARGET=192.168.16.150:20300:mydb) #ALTIBASE connection info (IP:PORT:DBNAME)
 (TX_MODE=LOCAL)
 )
)

 

2. Run /tbgw

After completing the Gateway installation and environment setup, run the Java gateway.
Check the process to confirm that the Java gateway is running properly.
  • When the Java gateway runs, a folder named log is created. For troubleshooting, you can go to this folder to analyze the cause.
$ ./tbgw

-------------------------------
Name : TmaxData JAVA GATEWAY
Database: 7
Port : 9093
-------------------------------

$ ps -ef | grep gw
tibero1 3151 1 6 15:19 pts/0 00:00:00 java -Xms128m -Xmx512m -
Dlog4j.configuration=jgwlog.properties -classpath ./lib/commons-daemon-1.0.6.jar:./lib/commonspool.jar:./lib/commons-collections.jar:./lib/log4j1.2.15.jar:./lib/tbgateway.jar:./lib/Altibase.jar:./lib/sqljdbc.jar:./lib/sqljdbc4.jar:./lib/jconn3.jar:./lib/postgresql-8.4-
701.jdbc3.jar:. com.tmax.tibero.gateway.main.GatewayMain CONFIG=./jgw.cfg
tibero1 3167 2043 0 15:19 pts/0 00:00:00 grep --color=auto gw
 
 
 

Related to