数据库驱动类名及URL

mysql

url="jdbc:mysql://"+ip+":"+port+"/"+databaseName+"?useUnicode=true&characterEncoding=utf-8&useSSL=false";
sourceDriver= "com.mysql.jdbc.Driver";

postgresql

url="jdbc:postgresql://"+ip+":"+port+"/"+databaseName;
sourceDriver= "org.postgresql.Driver";

注：url相关配置
//指定默认数据库模式为public
currentSchema=public
//JDBC写入postgresql时数据类型出现错误
//例如出现报错column is of type timestamp without time zone but expression is of type character varying，取出SQL放到数据库正常执行
stringtype=unspecified
//完整示例
url="jdbc:postgresql://HOST:5432/postgres?currentSchema=public&stringtype=unspecified";

oracle

//1.service_name
url="jdbc:oracle:thin:@//"+ip+":"+port+"/"+service_name;
sourceDriver= "oracle.jdbc.driver.OracleDriver";
//2.SID
url="jdbc:oracle:thin:@"+ip+":"+port+":"+SID;
sourceDriver= "oracle.jdbc.driver.OracleDriver";
//驱动类名的另一种写法，和前者作用相同
sourceDriver= "oracle.jdbc.OracleDriver";

注：
//service_name查询语句
select value from v$parameter where name='service_names';
//SID查询语句
select value from v$parameter where name='instance_name';

sqlserver

url="jdbc:sqlserver://"+ip+":"+port+";databaseName="+databaseName;
sourceDriver="com.microsoft.sqlserver.jdbc.SQLServerDriver";

greenplum

url="jdbc:postgresql://"+ip+":"+port+"/"+databaseName;
sourceDriver= "org.postgresql.Driver";

db2

url="jdbc:db2://"+ip+":"+port+"/"+databaseName;
sourceDriver= "com.ibm.db2.jcc.DB2Driver";

hive

url="jdbc:hive2://"+ip+":"+port+"/"+databaseName;
sourceDriver= "org.apache.hive.jdbc.HiveDriver";

influxdb

url="http://"+ip+":"+port;

mongodb

 url=ip+":"+port;

数据库连接方式

Class.forName(sourceDriver);
DriverManager.getConnection(url, username, password);
//influxdb和mongodb使用数据源工具类:InfluxDBUtil和MongoUtil