Development/Database

JDBC Connection String for DBMSs

zennken 2008. 10. 7. 21:52

ALTIBASE
jdbc:Altibase://<address>:<port_number>/<database_name>
dirver file name: Altibase.jar

ORACLE
jdbc:oracle:<drivertype>:<username/password>@<database>
<database>:
* //<host>:<port>/<service>
* <host>:<port>:<SID>
* <TNSName>

String url = "jdbc:oracle:thin:@192.168.3.38:" + port + ":orcl";
Default port: 1521

SID: select instance from v$thread;
DB Name: select name from v$database;

DB2
jdbc:db2://[serverName][:port][/DBName]
Default port 50000

The IBM® Data Server Driver for JDBC and SQLJ
--------------------------------------------------------------------------------------------
Driver package name  Level of JDBC support  Minimum level of SDK for Java required
--------------------------------------------------------------------------------------------
db2jcc.jar and sqlj.zip JDBC 3.0 and earlier  1.4.2
db2jcc4.jar and sqlj4.zip1  JDBC 4.0 and earlier  6

MS-SQL
jdbc:sqlserver://[serverName[\instanceName][:portNumber]][;property=value[;property=value]]
port: 1433
sqljdbc.jar

MySQL
jdbc:mysql://<host_name>:<port_number>/<database_name>
Port: 3306