各数据库的JDBC连接串

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))";

 

1.2.3 KDB

String url = "jdbc:inspur: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=kac))";