javaJDBC连接参数1 连接 MySQL
jdbc.driverName = sql.jdbc.Driver
jdbc.url = jdbc:mysql://ip:3306/databasename?useUnicode=true&characterEncoding=UTF8 jdbc.username= xxx
jdbc.password = xxx
2 连接 Oracle
jdbc.driverName = oracle.jdbc.OracleDriver
jdbc.url = jdbc:oracle:thin:@ip:1521:orcl
jdbc.username = xxx
jdbc.password = xxx
3 连接 SQL Server
jdbc.driverName = com.microsoft.sqlserver.jdbc.SQLServerDriver
jdbc.url = jdbc:sqlserver://ip:1433;DataBaseName=xxx
jdbc.username = xxx
jdbc.password = xxx
4 连接 DB2
jdbc.driverName = com.ibm.db2.jcc.DB2Driver
jdbc.url = jdbc:db2://ip:50000/databaseName:currentSchema=databaseName;
jdbc.username = xxx
jdbc.password = xxx
5 连接 Teradata
jdbc.driverName = adata.jdbc.TeraDriver
jdbc.url = jdbc:teradata://127.0.0.1/TMODE=ANSI,CHARSET=UTF8
jdbc.username = xxx
jdbc.password = xxx
6 连接 hive
jdbc.driverName = org.apache.hive.jdbc.HiveDriver
java的jdbc连接数据库
jdbc.url = jdbc:hive2://127.0.0.1:100000/database
jdbc.username = xxx
jdbc.password = xxx

版权声明:本站内容均来自互联网,仅供演示用,请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198,我们将在24小时内删除。