Shulou(Shulou.com)05/31 Report--

How to understand a variety of database default drivers, URL, ports, many novices are not very clear about this, in order to help you solve this problem, the following editor will explain in detail for you, people with this need can come to learn, I hope you can gain something.

Today, we mainly summarize the default ports and URL of various databases, reviewing the past and learning the new.

1. Oracle

(1) driver: oracle.jdbc.driver.OracleDriver

(2) URL:jdbc:oracle:thin:@:dbname

Note: machine_name: the name of the machine where the database resides. If it is local, it is 127.0.0.1 or localhost. If it is a remote connection, it is the remote IP address.

(3) port: Port number. Default is 1521.

Of course, Oracle has other hidden ports, which are recorded in the $ORACLE_HOMEinstallportlist.ini file.

Enterprise Manager Console HTTP Port (orcl) = 1158

Enterprise Manager proxy port (orcl) = 3938

Enterprise Manager Console HTTP Port (mynewccs) = 5500

Enterprise Manager proxy port (mynewccs) = 1830

Enterprise Manager Console HTTP Port (myicd) = 5501

Enterprise Manager proxy port (myicd) = 1831

2. SQL Server

(1) driver: com.microsoft.jdbc.sqlserver.SQLServerDriver

(2) URL:jdbc:microsoft:sqlserver://;DatabaseName=

Note: machine_name: the name of the machine where the database resides. If it is local, it is 127.0.0.1 or localhost. If it is a remote connection, it is the remote IP address.

(3) port: Port number. Default is 1433.

3. MySQL

(1) driver: org.gjt.mm.mysql.Driver

(2) URL:jdbc:mysql:///dbname

Note: machine_name: the name of the machine where the database resides. If it is local, it is 127.0.0.1 or localhost. If it is a remote connection, it is the remote IP address.

(3) port: Port number. Default is 3306.

4. Pointbase

PointBase is a set of small databases developed by Bruce Scott, one of the founders of oracle. PointBase is a small database written entirely in java with a small size (the database server engine is only 1m) and client files add up to less than 1m, so it can often be used as a project demonstration.

(1) driver: com.pointbase.jdbc.jdbcUniversalDriver

(2) URL:jdbc:pointbase:server:///dbname

Note: machine_name: the name of the machine where the database resides. If it is local, it is 127.0.0.1 or localhost. If it is a remote connection, it is the remote IP address.

(3) port: Port number. Default is 9092.

5. DB2

(1) driver: com.ibm.db2.jdbc.app.DB2Driver

(2) URL:jdbc:db2:///dbname

Note: machine_name: the name of the machine where the database resides. If it is local, it is 127.0.0.1 or localhost. If it is a remote connection, it is the remote IP address.

(3) port: Port number. Default is 5000.

6. NOSQL database

(1) MongoDB

Port: default port number, 27017

(2) Redis

Port: default port number, 6379

(3) memcached

Port: default port number, 11211

Is it helpful for you to read the above content? If you want to know more about the relevant knowledge or read more related articles, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.