오라클 Jdbc 설정방법

참조:http://blog.naver.com/kkson50?Redirect=Log&logNo=120157753363

데이타베이스별로 JDBC DriverName을 설정하는 방법 모음입니다.

I need information of oracle.

Driver name is "oracle.jdbc.driver.OracleDriver"  do not change anyword.

Uri is "jdbc:oracle:thin:@//127.0.0.1:1521/dbname" you must chang IP and dbname.

add  java oracle connection tip:

another Uri = "jdbc:oracle:thin:@(DESCRIPTION="
+"(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1) (PORT=1521)) )"
+"(CONNECT_DATA=(SERVICE_NAME=dbname)))";

Database	Driver Name	Sample URL	Notes
DB2	com.ibm.db2.jcc.DB2Driver	jdbc:db2://127.0.0.1:50000/dbname
Derby	org.apache.derby.jdbc.ClientDriver	jdbc:derby://127.0.0.1/testdb	client/server
	org.apache.derby.jdbc.EmbeddedDriver	jdbc:derby:path-to-hsql-db-files;create=true	embedded
FrontBase	jdbc.FrontBase.FBJDriver	jdbc:FrontBase://127.0.0.1/dbname
HSQLDB	org.hsqldb.jdbcDriver	jdbc:hsqldb:hsql://127.0.0.1	client/server
		jdbc:hsqldb: file:/path-to-hsql-db-files	embedded
H2	org.h2.Driver	jdbc:h2:mem:myTestMem;MVCC=TRUE	embedded in-memory
Ingres	com.ingres.jdbc.IngresDriver	jdbc:ingres://127.0.0.1:II7/dbname
MySQL	com.mysql.jdbc.Driver	jdbc:mysql://127.0.0.1/dbname
OpenBase	com.openbase.jdbc.ObDriver	jdbc:openbase://127.0.0.1/dbname
Oracle (10i, 9i, 8i, 8)	oracle.jdbc.driver.OracleDriver	jdbc:oracle:thin:@//127.0.0.1:1521/dbname
PostgreSQL (7.4, 8.*)	org.postgresql.Driver	jdbc:postgresql://127.0.0.1:5432/dbname
SQLite 3.*	org.sqlite.JDBC	jdbc:sqlite:path_to_dbfile	driver fromzentus.com
SQLServer	com.microsoft.sqlserver.jdbc.SQLServerDriver	jdbc:sqlserver://127.0.0.1;databaseName=dbname	Microsoft Driver
	com.microsoft.jdbc.sqlserver.SQLServerDriver	jdbc:microsoft:sqlserver://127.0.0.1;databaseName=dbname;SelectMethod=cursor	Microsoft Driver, SQL Server prior to 2005
	net.sourceforge.jtds.jdbc.Driver	jdbc:jtds:sqlserver://127.0.0.1:5000/dbname	jTDS Driver
Sybase	com.sybase.jdbc3.jdbc.SybDriver	jdbc:sybase:Tds:127.0.0.1:5000/dbname	Sybase driver
	net.sourceforge.jtds.jdbc.Driver	jdbc:jtds:sybase://127.0.0.1:5000/dbname;useLOBs=false;TDS=4.2

[출처] JDBC DriverName 설정방법 (총 13개 DBMS별)|작성자 까만손오공