1、oracle:
driver="oracle.jdbc.driver.OracleDriver"
url="jdbc:oracle:thin:@localhost:1521/空间名"/
例如:
url = jdbc:oracle:thin:@localhost:1521/ORCL2
2、sqlserver 2000:
driver="com.microsoft.jdbc.sqlserver.SQLServerDriver"
url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=数据库名"
3、sqlserver 2005:
driver="com.microsoft.sqlserver.jdbc.SQLServerDriver"
url="jdbc:sqlserver://localhost:1433;DatabaseName=数据库名"/
4、mysql:
driver="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/数据库名?[后接参数]"
例如:
url=jdbc:mysql://localhost:3306/i5?useUnicode=true&characterEncoding=UTF-8&serverTimezone=CTT&zeroDateTimeBehavior=convertToNull
5、db2:
driver="com.ibm.db2.jdbc.app.DB2Driver"
url="jdbc:db2://localhost:5000/数据库名"sybase: driver="com.sybase.jdbc.SybDriver"
6、impala
driver=org.apache.hive.jdbc.HiveDriver
url=jdbc:hive2://localhost:3308/edecathlon;auth=noSasl
或者
driver=com.cloudera.impala.jdbc41.Driver
url=jdbc:impala://xxxx:21050/databasename
7.gbase
driver = com.gbase.jdbc.Driver
url = jdbc:gbase://localhost:5258/userdata?useOldAliasMetadataBehavior=true