I/F Driver change

This chapter explains I/F Driver change uisng JDBC, ODBC, DB Link, etc.

JDBC

Tibero 6

• Comply with JDBC 4.0 SPEC. (JDK 1.6 or higher)

• JDBC File : $TB_HOME/client/lib/jar/tibero6-jdbc.jar

Tibero 7

• Comply with JDBC 4.0 SPEC. (JDK 1.7 or higher)

• JDBC File : $TB_HOME/client/lib/jar/tibero7-jdbc.jar

Tibero URL Setting

Tibero 6,7

Single : jdbc:tibero:thin:@192.168.11.49:8629:tibero
TAC : "jdbc:tibero:thin:@(description=
(failover=on)(load_balance=on)
(address_list=(address=(host=192.168.11.49)(port=8629))
(address=(host=192.168.11.50)(port=8629))
)(DATABASE_NAME=tibero7))”

---

ODBC and OLE DB

Install Tibero 7 OCBC and OLE DB and change the existing drivers. The ODBC Driver is used for the oracle to Tibero DB Link, so replacement is necessary.

Connection String(ODBC)

The DSN method is the same, and if it is a Windows-based IP/PORT connection method, changes are required as follows.

Tibero 6

DRIVER={Tibero 6 ODBC Driver};SERVER=127.0.0.1;PORT=8629;UID=tibero;PWD=tmax;

Tibero 7

DRIVER={Tibero 7 ODBC Driver};SERVER=127.0.0.1;PORT=8629;DB=tb7;UID=tibero;
PWD=tmax;

Add DB Name corresponding to clients as DB Name check is stricter in Tibero 6 .

It operates in DSN mode by referring the TB_SID environment variable on UNIX (including Linux) even when specifying the IP/PORT using SQL Driver Connect.

Connection String(OLE DB)

The DSN method is the same, and if it is a Windows-based IP/PORT connection method, changes are required as follows.

Tibero 6

Provider=tbprov.Tbprov;Data Source='127.0.0.1,8629';User ID=tibero;Password=tmax;

Tibero 7

Provider=tbprov.Tbprov;Data Source='127.0.0.1,8629,tb7';
User ID=tibero;Password=tmax;

Add DB Name corresponding to clients as DB Name check is stricter in Tibero 6 .

---

Others (DB Link, EXTERNAL, etc.)

DB Link

If using Gateway, boot after changing to the Gateway provided by Tibero 7.

$TB_HOME/client/bin/

External Procedure

If using the Agent for JAVA External Procedure, boot after switching to the Agent provided by Tibero 7.

External Library (JAR) Reference

Open the following files of Tibero 6, apply the necessary settings for external library references to Tibero 7, and import the related libraries.

Tibero 6

$TB_HOME/bin/psmjavac
$TB_HOME/client/bin/tbjavaepa

Tibero 7

$TB_HOME/bin/psmjavac
$TB_HOME/client/bin/tbjavaepa