Database port number and other configurations, database port number Configuration

Database port number and other configuration (transfer), Database port number Configuration

I. Oracle

Driver: oracle. jdbc. OracleDriver

URL: jdbc: oracle: thin: @

Port_number: port number. The default value is 1521.

Ii. SQL Server

Driver: com. microsoft. jdbc. sqlserver. SQLServerDriver

URL: jdbc: microsoft: sqlserver: //

Port_number: port number. The default value is 1433.

Iii. MySQL

Driver: com. mysql. jdbc. Driver

URL: jdbc: mysql: //

Port_number: port number. The default value is 3306.

4. pointbase

Driver: com. pointbase. jdbc. jdbcUniversalDriver

URL: jdbc: pointbase: server: //

Port_number: port number. The default value is 9092.

 

V. DB2

Driver: com. ibm. db2.jdbc. app. DB2Driver

URL: jdbc: db2: //

Port_number: port number. The default value is 5000.

 

6. postgersql

Driver: org. postgresql. Driver

URL: jdbc: postgresql: //

Port_number: port number. The default value is 5432.

 

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