JDBC, JDK, and Oracle Database Certification and Availability FAQs
Q1: ¾î¶² version ÀÇ JDK ¿Í ¾î¶² version ÀÇ JDBC driver ¸¦ °°ÀÌ »ç¿ëÇØ¾ß Çϳª¿ä ?
´ÙÀ½ JDK ¿Í JDBC Certification Matrix ¸¦ Âü°íÇÏ½Ã¸é µË´Ï´Ù.
JDK Driver File Name JDBC Version--- ---------------- ------------
1.1 classes111.zip 7.3.4 - 1.2 classes12.zip 8.1.6 - 1.3 classes12.zip 9.2 - 1.4 ojdbc14.zip 9.2 -
Q2: ¾î¶² version ÀÇ JDBC driver ¿Í ¾î¶² version ÀÇ database ¸¦ °°ÀÌ »ç¿ëÇØ¾ß Çϳª¿ä ?
JDBC --> Oracle DB------------------
Backward Compatibility
JDBC Thin drivers ´Â database ÀÌÀü version Áß support µÇ´Â version °ú certified µÇ¾î ÀÖ½À´Ï´Ù.support µÇ´Â database ´Â http://metalink.oracle.com ¿¡ °¡¼Å¼ Certify and Availability ºÎºÐÀ» Âü°íÇϽñ⠹ٶø´Ï´Ù.
¿¹¸¦ µé¾î 9.2 JDBC Thin drivers ´Â 9.2.x, 9.0.1.x, 8.1.7 database ¿Í certified µÇ¾î ÀÖ½À´Ï´Ù. 9.2 JDBC Thin drivers ´Â support µÇÁö ¾Ê´Â 8.0.x °ú 7.x°°Àº database ¿Í´Â certified µÇ¾î ÀÖÁö ¾Ê½À´Ï´Ù.
Forward Compatibility
JDBC product ´Â forward compatibility ¸¦ Áö¿øÇÏÁö ¾Ê½À´Ï´Ù. ±×·¯³ª »õ·Î¿î oracle products (¿¹¸¦ µé¾î 9iAS) °°Àº °æ¿ì ¶§·Î´Â ¿À·¡µÈ JDBC client side drivers ¸¦ Áö¿øÇÒ ¼öµµ ÀÖ½À´Ï´Ù.ƯÁ¤ ¹®¼¸¦ Âü°íÇؼ compatibility ¿¡ °üÇÑ Á¤º¸¸¦ ã¾Æ º¸½Ã±â ¹Ù¶ø´Ï´Ù.
Âü°í : Bulletin No. 17703 ¸¦ º¸½Ã¸é µµ¿òÀÌ µÇ½Ç °ÍÀÔ´Ï´Ù.
Oracle ¹öÁ¯º° »ç¿ë JDBC
8i 8.1.7.1 JDBC Driversjdk 1.2 classes12.zip (1,892 kb)jdk 1.1 classes111.zip (1,741 kb)
9i 9.0.1.4 (release 1) JDBC Driversjdk 1.2 and jdk 1.3 classes12.zip (1,144 kb)jdk 1.1 classes111.zip (9,886 bytes)
9i 9.2.0.5 (release 2) JDBC Driversjdk 1.4 ojdbc14.jar (1,200 kb)jdk 1.2 and jdk 1.3 classes12.zip (1,232 kb)jdk 1.1 classes111.zip (1,063 kb)
10g 10.1.0.4 JDBC Driversjdk 1.4 ojdbc14.jar (1,410 kb)jdk 1.2 and jdk 1.3 classes12.jar (1,474 kb)
10g 10.2.0.1.0 (release 2) JDBC Driversjdk 1.4 ojdbc14.jar (1,536 kb)jdk 1.2 and jdk 1.3 classes12.jar (1,590 kb)
Q3: ¾î¶² version ÀÇ JDK ¸¦ ¾î¶² version ÀÇ Oracle database ¿Í °°ÀÌ »ç¿ëÇÒ ¼ö ÀÖ³ª¿ä ?
JDK version °ú Oracle database version Àº °ü·ÃÀÌ ¾ø½À´Ï´Ù. Q1 °ú Q2 ¸¦ Âü°í ÇϽñ⠹ٶø´Ï´Ù.
Q4: classes13.zip À̶ó´Â ÆÄÀÏÀÌ ÀÖ½À´Ï±î ?
¾ø½À´Ï´Ù. ´ë½Å¿¡ classes12.zip ¸¦ »ç¿ëÇϽñ⠹ٶø´Ï´Ù. ÀÌ ÆÄÀÏÀº JDK 1.3 ¿Í JDBC v8.1.7 ÀÌ»ó°ú certified µÇ¾î ÀÖ½À´Ï´Ù.
Q5: Oracle JDBC driver ´Â ¾îµð¿¡¼ download ¹ÞÀ» ¼ö ÀÖ³ª¿ä ?´ÙÀ½¿¡¼ ±¸ÇÒ ¼ö ÀÖ½À´Ï´Ù:
- http://otn.oracle.com -> ¿ÞÂÊ download ¸Þ´º -> ¿À¸¥ÂÊ ÇÏ´Ü¿¡ Oracle JDBC driver ¼±ÅÃ- Oracle Enterprise Edition (client) installation disk
http://www.oracle.com/technology/software/index.html
http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html
oracle.com¿¡ ȸ¿ø ¾ÆÀ̵𰡠ÇÊ¿äÇÕ´Ï´Ù ^^
Q6: JDBC 3.0 µµ Áö¿øÇϳª¿ä ?JDBC 9.2 °¡ ÀϺΠÁö¿øÇÏ°í 10i ¿¡¼ ¿ÏÀüÈ÷ Áö¿øÇÏ°Ô µÉ °ÍÀÔ´Ï´Ù.
Q7: JDK 1.3 À» Áö¿øÇϳª¿ä ?
JDBC version 8.1.7 À̻󿡼 classes12.zip ÆÄÀÏÀ» »ç¿ëÇÏ½Ã¸é µË´Ï´Ù.
Q8: platform º°·Î JDBC thin driver ¸¦ down ¹ÞÀ» ¼ö ÀÖ´Â °÷ÀÌ ÀÖ³ª¿ä ? (OTN ¿¡´Â Solaris ¿Í NT ¿ë¸¸ ÀÖ´øµ¥¿ä.)
JDBC Thin driver ´Â platform °ú »ó°ü¾øÀÌ »ç¿ëÇÏ½Ç ¼ö ÀÖ½À´Ï´Ù.Solaris ¿ëÀ» down ¹ÞÀ¸¼Å¼ ¾î¶² UNIX OS ¿¡¼µç »ç¿ë °¡´ÉÇÕ´Ï´Ù. ¸¶Âù°¡Áö·Î Windows ¿ëÀ» ¹ÞÀ¸½Ã¸é ¾î¶² Windows OS ¿¡¼µµ »ç¿ë°¡´É ÇÕ´Ï´Ù.¿À¶óŬ¿¡¼´Â °¡Àå ÃֽŠversion ÀÇ JDBC Thin driver ¸¦ »ç¿ëÇÏ½Ã±æ ±ÇÀåÇÕ´Ï´Ù. Thin driver ´Â database version ÀÌ support µÇ´Â ÇÑ ÀÌÀü version °ú backwardscompatibility ¸¦ Á¦°øÇÕ´Ï´Ù.
Q9: ¾î¶² type ÀÇ driver °¡ ÀÖ½À´Ï±î ?
Oracle ´ÙÀ½ 3 type ÀÇ driver À» Á¦°øÇÕ´Ï´Ù:
¨Í JDBC Thin DriverOracle JDBC Thin driver ´Â 'Type IV' ÀÔ´Ï´Ù. (native protocol, 100% Pure Java)JDBC Thin driver Àº Java Socket À» »ç¿ëÇؼ Á÷Á¢ Oracle Server ·Î Á¢¼Ó ÇÕ´Ï´Ù.
two-tier ³ª three-tier ȯ°æ¿¡¼ Java applets À» °³¹ßÇÒ¶§ ¸¹ÀÌ »ç¿ëµÇ¸ç Java applications À» °³¹ßÇÒ¶§µµ »ç¿ëµË´Ï´Ù.
JDBC Thin driver ´Â ÀÚü³»¿¡ Oracle's SQL*Net/Net8 TCP/IP ¸¦ ±¸ÇöÇÏ°í ÀÖ½À´Ï´Ù.
¸ðµÎ Java ·Î ¸¸µé¾îÁ® Àֱ⠶§¹®¿¡ platform ¿¡ »ó°ü¾øÀÌ »ç¿ëÇÏ½Ç ¼ö ÀÖ½À´Ï´Ù. applet ¿¡¼ »ç¿ëÇϽǶ§¿¡´Â client browser °¡ ¹Ýµå½Ã Java sockets À» Áö¿øÇØ¾ß ÇÕ´Ï´Ù.
JDBC Thin driver ¸¦ ÀÌ¿ëÇϱâÀ§Çؼ client ÂÊ¿¡ ¼³Ä¡ÇؾßÇÒ Oracle software ´Â ¾ø½À´Ï´Ù. Java applet ÀÌ ½ÇÇàµÉ¶§ µ¿½Ã¿¡ browser ·Î download µË´Ï´Ù.client ¿¡¼ browser ·Î URL À» Ãļ Java applet tag °¡ µé¾î ÀÖ´Â HTML page¸¦ È£ÃâÇÏ°Ô µË´Ï´Ù. ±× applet archive ´Â JDBC class ÆÄÀϵéÀ» ¹Ýµå½Ã Æ÷ÇÔÇØ¾ß ÇÕ´Ï´Ù. web server °¡ client ·Î JDBC Thin driver ¿Í Java applet À» º¸³»ÁÖ¸é JDBC Thin driver ´Â Java Sockets À» ÀÌ¿ëÇؼ database ¿¡ Á÷Á¢ Á¢¼ÓÇÏ°Ô µË´Ï´Ù.
¨Î JDBC OCI DriverJDBC OCI driver ´Â Oracle database ¿Í µ¿ÀÛÇÏ´Â OCI (Oracle Call Interface)À» »ç¿ëÇؼ JDBC interfaces ¸¦ 'Type II' (native-API, partly Java) ·Î ±¸ÇöÇÑ °ÍÀÔ´Ï´Ù.
JDBC OCI driver ´Â OCI library ¾È¿¡ ÀÖ´Â C entry points ¸¦ È£ÃâÇϱâ À§ÇØ native methods ¸¦ »ç¿ëÇϱ⠶§¹®¿¡ platform-specific ÇÕ´Ï´Ù. ¶ÇÇÑ Net8 À» Æ÷ÇÔÇÏ´Â Oracle client ¸¦ ¼³Ä¡ÇØ¾ß »ç¿ë°¡´ÉÇÕ´Ï´Ù.
JDBC OCI driver ´Â OCI ¸¦ ÅëÇØ Oracle databases ¿Í µ¿ÀÛÇϱ⠶§¹®¿¡ IPC, named pipes, TCP/IP, ±×¸®°í SPX/IPX µî ¼³Ä¡µÈ ¸ðµç Net8 adapters ¸¦ Áö¿øÇÕ´Ï´Ù.
JDBC OCI driver ´Â C code ¸¦ Æ÷ÇÔÇÏ°í Àֱ⠶§¹®¿¡ applet ¿¡¼ »ç¿ë±â¿¡´Â ºÎÀûÇÕÇÕ´Ï´Ù. ´ë½Å Java applications À̳ª OAS ¿Í °°Àº Java middle tier ¿¡¼´Â »ç¿ëÇϱ⿡ ÀûÇÕÇÕ´Ï´Ù. JDBC OCI driver ´Â ´ÙÀ½°ú °°Àº ȯ°æ¿¡¼ »ç¿ë°¡´ÉÇÕ´Ï´Ù.
* two-tier ȯ°æ¿¡¼ client ¿¡¼ Java application ¸¦ ½ÇÇàÇÒ¶§* three-tier ȯ°æ¿¡¼ middle tier ¿¡¼ Java application ¸¦ ½ÇÇàÇÒ¶§* three-tier ȯ°æ¿¡¼ middle tier ¿¡¼ Java servlet À» ½ÇÇàÇÒ¶§
¨Ï JDBC Server Driver (KPRB)
JDBC Server driver ´Â server ÂÊ¿¡¼¸¸ »ç¿ëÇÏ½Ç ¼ö ÀÖ½À´Ï´Ù.JDBC Server driver ´Â Oracle JServer ¾È¿¡ ±¸ÇöµÇ¾î ÀÖÀ¸¸çOracle9i server side-Java engine °ú ±ä¹ÐÈ÷ ¿¬°áµÇ¾î ÀÖ½À´Ï´Ù.JDBC Server driver ´Â Oracle9i ¾È¿¡ ÀÖ´Â SQL engine À» ÇÊ¿ä·Î ÇÏ´Â (¿¹¸¦ µé¾î Java stored procedures ) ¾î¶² Java program °úµµ »ç¿ë°¡´ÉÇÕ´Ï´Ù.
JDBC Server driver ´Â Oracle9i ¾È¿¡¼ ½ÇÇàµÇ´Â Java programs ÀÌ JDBC ¸¦ ÀÌ¿ëÇؼ SQL °ú PL/SQL ¿¡ Á¢±ÙÀ» Çã¿ëÇÕ´Ï´Ù.
ÀÌ JDBC Server driver ´Â client ¿¡¼ »ç¿ëµÇ´Â driver ¿Í °°Àº ±â´ÉÀ» Á¦°øÇÕ´Ï´Ù.
Q10: Oracle V7.3.4 ¿ë driver ´Â ¾îµð¼ ¾òÀ» ¼ö ÀÖ½À´Ï±î ? (OTN ¿¡¼´Â ãÀ» ¼ö ¾ø´õ±º¿ä.)
Oracle Enterprise Edition (7.3.4) installation disk ¾È¿¡ ÀÖ½À´Ï´Ù. ÇÏÁö¸¸ Oracle ¿¡¼´Â ´õÀÌ»ó ¹èÆ÷ÇÏÁö ¾Ê°í ÀÖ½À´Ï´Ù.
from http://211.106.111.113:8880/bulletin/list.jsp?seq=20142&pg=0&sort_by=last_updated&keyfield=subject&keyword=jdbc Á¤¸®ÇÔ
ÁÁÀº»ý°¢ ^^
ÁÁÀº»ý°¢ ^^