转:各种数据库默认端口总结,防止连接失效,特备份。
Oracle
driver |
oracle.jdbc.driver.OracleDriver |
url |
jdbc:oracle:thin:@ip:port:dbname |
port |
1521 |
SQL Server
driver |
com.microsoft.jdbc.sqlserver.SQLServerDriver |
url |
jdbc:microsoft:sqlserver://ip:port;DatabaseName=<dbname> |
port |
1433 |
MySQL
driver |
org.gjt.mm.mysql.Driver |
url |
jdbc:mysql://ip:port/dbname |
port |
3306 |
PointBase
driver |
com.pointbase.jdbc.jdbcUniversalDriver |
url |
jdbc:pointbase:server://ip:port/dbname |
port |
9092 |
DB2
driver |
com.ibm.db2.jdbc.app.DB2Driver |
url |
jdbc:db2://ip:port/dbname |
port |
5000 |
MongoDB
默认端口:27017
Redis
默认端口:6379
memcached
默认端口:11211