Oracle JDBC 연결

Oracle DB 또한 MariaDB를 연결 한 것과 과정은 동일하나 JDK 버전을 알 필요가 있다.

JDK1.8(java 8 버전) 이면 OracleDB12버전을 받아줘야한다.

​

OracleDB 별 JDBC버전

https://stackoverflow.com/questions/30928813/supported-jdbc-jdk-versions-for-oracle-11g

Supported JDBC, JDK versions for Oracle 11g

We are upgrading our DB from oracle 10g to 11g. I hope our current JDK1.6 will support this. What will be ideal JDBC versions for Oracle 11g ? Currently we are using ojdbc.14.jar , will it suppo...

stackoverflow.com

OracleDB

https://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html

Oracle Database Software Downloads | Oracle Technology Network | Oracle

Downloads Oracle Database Software Downloads You must accept the OTN License Agreement to download this software. Accept License Agreement | Decline License Agreement Oracle Database 19c (19.3) Microsoft Windows x64 (64-bit) ZIP (2.9 GB)  See All Linux x86-64 ZIP (2.8 GB) | RPM (2.5 GB)  See All Ora...

www.oracle.com

​

OJDBC(JDK1.8(java 8) 이면 7버전을 받아주자)

https://www.oracle.com/technetwork/database/features/jdbc/jdbc-drivers-12c-download-1958347.html

Oracle Database 12c Release 1 JDBC Driver Downloads

Oracle Database 12.1.0.1 JDBC Driver & UCP Downloads You must accept the OTN License Agreement to download this software. Accept License Agreement | Decline License Agreement Oracle Database 12c Release 1 (12.1.0.1) JDBC Drivers & UCP Downloads Zipped JDBC Driver and Companion JARs ojdbc-full.tar.gz...

www.oracle.com

​

드라이버

oracle.jdbc.driver.OracleDriver

​

URL

jdbc:oracle:driver_type:[username/password]@[//]host_name[:port][/XE]

ex) jdbc:oracle:thin:@localhost:1521:xe