jdbc:oracle:thin:[user/password]@[host][:port]:SID
jdbc:oracle:thin:[user/password]@//[host][:port]/SID
user - The login user name defined in the Oracle server.
password - The password for the login user.
host - The host name where Oracle server is running.
Default is 127.0.0.1 - the IP address of localhost.
port - The port number where Oracle is listening for connection.
Default is 1521.
SID - System ID of the Oracle server database instance.
SID is a required value. By default, Oracle Database 10g Express
Edition creates one database instance called XE.
예)
jdbc:oracle:thin:Herong/TopSecret@localhost:1521:XE
jdbc:oracle:thin:Herong/TopSecret@:1521:XE
jdbc:oracle:thin:Herong/TopSecret@//localhost:1521/XE
jdbc:oracle:thin:Herong/TopSecret@//:1521/XE
jdbc:oracle:thin:Herong/TopSecret@//localhost/XE
jdbc:oracle:thin:Herong/TopSecret@///XE
참고 URL: http://www.herongyang.com/JDBC/Oracle-JDBC-Driver-Connection-URL.html
'오라클' 카테고리의 다른 글
| 오라클 정리-유저 롤/권한설정 (0) | 2012.12.14 |
|---|---|
| oracle 정리-테이블스페이스 (0) | 2012.12.14 |
| 정규표현식 치환(regexp_replace) (0) | 2012.05.31 |
| 소계 계산(rollup) (0) | 2012.05.31 |
| 분석함수 (0) | 2012.05.31 |