database:oracle:jdbc

차이

문서의 선택한 두 판 사이의 차이를 보여줍니다.

차이 보기로 링크

--- database:oracle:jdbc [2020/07/02 13:46]
kwon37xi
+++ database:oracle:jdbc [2020/07/05 13:03]
kwon37xi
@@ 줄 1: / 줄 1: @@
 ====== Oracle JDBC Driver ======
-  * https://mvnrepository.com/artifact/oracle/oracle-jdbc
+  * https://mvnrepository.com/artifact/com.oracle.database.jdbc
+    * JDK 버전에 따라 선택해야 한다.
+    * [[https://mvnrepository.com/artifact/com.oracle.database.jdbc/ojdbc6|ojdbc6]] : JDK 6,7,8
+    * [[https://mvnrepository.com/artifact/com.oracle.database.jdbc/ojdbc8|ojdbc8]] : JDK 8,9,11
+    * [[https://mvnrepository.com/artifact/com.oracle.database.jdbc/ojdbc10|ojdbc10]] : JDK 10, 11
   * [[https://www.oracle.com/kr/database/technologies/appdev/jdbc.html|JDBC Drivers]]
+  * [[http://www.orafaq.com/wiki/JDBC|JDBC - Oracle FAQ]]
 ===== 기본 설정 =====
   * Driver class : ''oracle.jdbc.driver.OracleDriver''
   * 기본 JDBC Url 형태 : ''jdbc:oracle:thin:@localhost:1521:<sid>''
+===== Connection Properties =====
+  * JDBC URL로 설정하지는 못하고, Connection Pool 에서 connection properties 로 설정할 수 있는 값.
+  * 정확한 공식 문서를 찾지 못했음.
+    * [[https://d2.naver.com/helloworld/1321|JDBC Internal - 타임아웃의 이해]] 참조
+    * [[https://docs.oracle.com/cd/E21454_01/html/821-2594/cnfg_oracle-env_r.html|Oracle Adapter Environment Properties - Configuring Environment Components for Oracle Java CAPS Database Adapters]]
+    * [[https://docs.oracle.com/cd/E57185_01/ESTUG/apbs02s23.html|oracle.jdbc.ReadTimeout]]
+  * ''oracle.net.CONNECT_TIMEOUT'' : Connection timeout millis, 예) ''1000''(1초)
+  * ''oracle.jdbc.ReadTimeout'' : Read timout millis, 예) ''60000''(1분)

database/oracle/jdbc.txt · 마지막으로 수정됨: 2020/07/31 14:21 저자 kwon37xi