1 JDBC配置
1.1 单实例数据库
1.1.1 tibero
1.1.1.1 jar包:
$TB_HOME/client/lib/jar/
Tibero5-jdbc-dbg.jar #测试使用
Tibero5-jdbc.jar
Tibero5-jdbc-14.jar #应用使用的JDK是1.4时,使用此jar包
1.1.1.2 URL:
Class.forName("com.tmax.tibero.jdbc.TbDriver");
conn = DriverManager.getConnection("jdbc:tibero:thin:@IP:port:db_name","user", "password");
1.1.2 updb:
1.1.2.1 JAR包:
$UP_HOME/client/lib/jar/目录下
upright6-jdbc-14-dbg.jar
upright6-jdbc-14.jar
upright6-jdbc-dbg.jar
upright6-jdbc.jar
1.1.2.2 URL:
Class.forName("com.updb.jdbc.UpDriver");
Connection conn =
DriverManager.getConnection("jdbc:upright:thin:@ip:port:db_name","user","passwd");
1.1.3 KDB:
1.1.3.1 jar包:
$KD_HOME/client/lib/jar/
Inspur11-jdbc-dbg.jar #测试使用
Inspur11-jdbc.jar
Inspur11-jdbc-14.jar #应用使用的JDK是1.4时,使用此jar包
1.1.3.2 URL:
Class.forName("com.inspur.jdbc.KdDriver");
conn = DriverManager.getConnection("jdbc:inspur:thin:@IP:port:db_name","user", "password");
1.1.4 ORACLE
1.1.4.1 jar包:
$ORACLE_HOME/jdbc/lib/ojdbc6.jar #oracle11g
$ORACLE_HOME/jdbc/lib/ojdbc4.jar #oracle10g
1.1.4.2 URL:
class.forName("Oracle.jdbc.driver.OracleDriver");
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:
@IP:PORT:service_name","USERNAME","PASSWORD");
1.2 集群模式
1.2.1 tibero
String url = "jdbc:tibero:thin:@(DESCRIPTION=(FAILOVER=ON)(LOAD_BALANCE=ON)(ADDRESS_LIST=(ADDRESS=(HOST=192.168.126.222)(PORT=18629))(ADDRESS=(HOST=192.168.16.101)(PORT=18629)))(DATABASE_NAME=tac))";
1.2.2 updb
String url = "jdbc:updb:thin:@(DESCRIPTION=(FAILOVER=ON)(LOAD_BALANCE=ON)(ADDRESS_LIST=(ADDRESS=(HOST=192.168.126.222)(PORT=18629))(ADDRESS=(HOST=192.168.16.101)(PORT=18629)))(DATABASE_NAME=uac))";