javaJDBC连接参数

来源：互联网发布：漫威电影顺序知乎编辑：程序博客网时间：2024/06/05 19:28

1 连接 MySQL

jdbc.driverName = com.mysql.jdbc.Driverjdbc.url = jdbc:mysql://ip:3306/databasename?useUnicode=true&characterEncoding=UTF8jdbc.username= xxxjdbc.password = xxx

2 连接 Oracle

jdbc.driverName = oracle.jdbc.OracleDriverjdbc.url = jdbc:oracle:thin:@ip:1521:orcljdbc.username = xxxjdbc.password = xxx

3 连接 SQL Server

jdbc.driverName = com.microsoft.sqlserver.jdbc.SQLServerDriverjdbc.url = jdbc:sqlserver://ip:1433;DataBaseName=xxxjdbc.username = xxxjdbc.password = xxx

4 连接 DB2

jdbc.driverName = com.ibm.db2.jcc.DB2Driverjdbc.url = jdbc:db2://ip:50000/databaseName:currentSchema=databaseName;jdbc.username = xxxjdbc.password = xxx

5 连接 Teradata

jdbc.driverName = com.teradata.jdbc.TeraDriverjdbc.url = jdbc:teradata://127.0.0.1/TMODE=ANSI,CHARSET=UTF8jdbc.username = xxxjdbc.password = xxx

6 连接 hive

jdbc.driverName = org.apache.hive.jdbc.HiveDriverjdbc.url = jdbc:hive2://127.0.0.1:100000/databasejdbc.username = xxxjdbc.password = xxx

阅读全文

0 0