Главная » Языки программирования

Java oracle jdbc drivers

На чтение 12 мин
Содержание
  1. Java oracle jdbc drivers
  2. Guidelines
  3. Refer to these documents for more information
  4. Oracle Database 23c Free — Developer Release (23.2.0.0) JDBC Driver & UCP Downloads
  5. Oracle Database 19c (19.19.0.0) JDBC Driver & UCP Downloads — Long Term Release
  6. Oracle Database 21c (21.10.0.0) JDBC Driver & UCP Downloads — Innovation Release
  7. Java oracle jdbc drivers
  8. 1.1 Overview of Oracle JDBC Drivers
  9. Java oracle jdbc drivers
  10. Guidelines
  11. Refer to these documents for more information
  12. Oracle Database 23c Free — Developer Release (23.2.0.0) JDBC Driver & UCP Downloads
  13. Oracle Database 19c (19.19.0.0) JDBC Driver & UCP Downloads — Long Term Release
  14. Oracle Database 21c (21.10.0.0) JDBC Driver & UCP Downloads — Innovation Release

Java oracle jdbc drivers

Get all new and older versions of Oracle JDBC drivers from Maven Central Repository and refer to Maven Central Guide for details.

Guidelines

  • For connections to Oracle Autonomous Database, refer to Java Connectivity to ADB-S for more details.
  • The best practice is use the latest version of the Oracle JDBC driver that supports the JDK and Database version that you use and is compatible with your support requirements. Refer to the section ‘Release Specific Questions’ under JDBC FAQ for more details.
  • 19c is a Long Term Release with a premier support until April 2024 and extended support until April 2027. This is the recommended version.
  • 21c is an Innovation Release with a premier support until April 2024. Refer to page#6 of Lifetime Support Policy for more details.
  • Oracle Database 23c Free is a community supported release of the Oracle Database family. Please go to the Oracle Database Free Community Forum for help, feedback, and enhancement requests.
  • To check the version of the Oracle JDBC driver, use java -jar ojdbcX.jar (eg., java -jar ojdbc8.jar or java -jar ojdbc11.jar).
  • You can also get the older release and quarterly updates of Oracle JDBC drivers from Oracle JDBC Drivers Archive

Refer to these documents for more information

Oracle Database 23c Free — Developer Release (23.2.0.0) JDBC Driver & UCP Downloads

Supports Oracle Database versions — 23c, 21c, 19c, 18c, and 12.2. Learn more about new features available in Oracle Database 23c Free—Developer Release. Note: The Oracle Database 23c Free Developer Release should not be used in production because SRs will not be available and patches will not be delivered.

  1. Oracle JDBC driver except classes for NLS support in Oracle Object and Collection types.
  2. (6,971,601 bytes) — (SHA1: a19cc23a15caea09f4883e938907129354239e75)
  1. Oracle JDBC driver except classes for NLS support in Oracle Object and Collection types.
  2. (6,844,991 bytes) — (SHA1: 49acfb33ee776e43d2085e2fcc838778202a9128)
  1. Universal Connection Pool (UCP) to be used with ojdbc11.jar
  2. (1,513,648 bytes) — (SHA1: 0638ee573f2b7bf873702fae533f291099ac7681)
  1. Universal Connection Pool (UCP) to be used with ojdbc8.jar
  2. (1,471,956 bytes) — (SHA1: 1b5300b30d54d091f7af7dc9070681c62fdad04c)
  1. This archive contains ojdbc11.jar, ucp11.jar, Reactive Streams Ingest (rsi.jar), companion jars 1 , JDBC, UCP, RSI Javadoc, and their Readmes. Refer to README.txt in the zip for details.
  2. (26,562,560 bytes) — (SHA1: 41204e77573e9d36397016a18b0abc932580c44f)
  1. This archive contains ojdbc8.jar, ucp.jar, Reactive Streams Ingest (rsi.jar), companion jars 1 , JDBC, UCP, RSI Javadoc, and their Readmes. Refer to README.txt in the zip for details.
  2. (25,907,200 bytes) — (SHA1: fed6c77364cb34cdd2e8236ec0a292a77d736e8d)
Читайте также:  Python программа для виндовс

1- The companion jars consist of oraclepki.jar, orai18n.jar, ons.jar, simplefan.jar, xdb.jar, xmlparserv2.jar, and xmlparserv2_sans_jaxp_services.jar, dms.jar

Oracle Database 19c (19.19.0.0) JDBC Driver & UCP Downloads — Long Term Release

  1. Oracle JDBC driver except classes for NLS support in Oracle Object and Collection types.
  2. (4,535,376 bytes) — (SHA1: e172880a3b3e34efdc167874108f43a5063473ed)
  1. Oracle JDBC driver except classes for NLS support in Oracle Object and Collection types.
  2. (4,502,465 bytes) — (SHA1: eb90c858f6b8856123d01b8fadd0d57b8505cc2a)
  1. Universal Connection Pool (UCP)
  2. (1,695,327 bytes) — (SHA1: 04c2f3be53e392796737e0ea27494a730a929130)
  1. This archive contains ojdbc10.jar, ucp.jar, companion jars 1 , diagnosability jars 2 , JDBC, UCP, RSI Javadoc, and their Readmes. Refer to README.txt in the zip for details.
  2. (45,189,120 bytes) — (SHA1: 0a43a27c70625d6515c330182ae5eb8f09d109d3)
  1. This archive contains ojdbc8.jar, ucp.jar, companion jars 1 , diagnosability jars 2 , JDBC, UCP, RSI Javadoc, and their Readmes. Refer to README.txt in the zip for details.
  2. (44,492,800 bytes) — (SHA1: ea3e976d4c225f557f9f3e9b0f727b25efaab4a0)

Oracle Database 21c (21.10.0.0) JDBC Driver & UCP Downloads — Innovation Release

  1. Oracle JDBC driver except classes for NLS support in Oracle Object and Collection types.
  2. (5,246,781 bytes) — (SHA1: 7dbf9190eb3a8b76cea50ce214b4cc91fb498fc6)
  1. Oracle JDBC driver except classes for NLS support in Oracle Object and Collection types.
  2. (5,154,257 bytes) — (SHA1: b570dea1f4f9ca021a313462e2c58d77ab16b2ae)
  1. Universal Connection Pool to be used with ojdbc11.jar
  2. (1,807,381 bytes) — (SHA1: c06599882a54e819f18612bcb25c1f6157c379dd)
  1. Universal Connection Pool to be used with ojdbc8.jar
  2. (1,806,407 bytes) — (SHA1: 2cf7a2f0a6233bfb9f1f8b64c0c259efab9a7265)
  1. This archive contains ojdbc11.jar, ucp.jar, Reactive Streams Ingest (rsi.jar), companion jars 1 , diagnosability jars 2 , JDBC, UCP, RSI Javadoc, their Readmes, and Bugs-fixed-in-217.txt. Refer to README.txt in the zip for details.
  2. (52,858,880 bytes) — (SHA1: 521c56bdcea96b0fa46bbe3b720acff806269436)
  1. This archive contains ojdbc8.jar, ucp.jar, Reactive Streams Ingest (rsi.jar), companion jars 1 , diagnosability jars 2 , JDBC, UCP, RSI Javadoc, and their Readmes. Refer to README.txt in the zip for details.
  2. (49,336,320 bytes) — (SHA1: 732721eabd4ec964e19649f40bb5e5f4463b5cb7)

Источник

Java oracle jdbc drivers

Java Database Connectivity (JDBC) is a Java standard that provides the interface for connecting from Java to relational databases. JDBC is based on the X/Open SQL Call Level Interface (CLI). JDBC 4.0 complies with the SQL 2003 standard.

The JDBC standard is defined and implemented through the standard java.sql interfaces. This enables individual providers to implement and extend the standard with their own JDBC drivers. This chapter provides an overview of the Oracle implementation of JDBC, covering the following topics:

1.1 Overview of Oracle JDBC Drivers

In addition to supporting the standard JDBC application programming interfaces (APIs), Oracle drivers have extensions to support Oracle-specific data types and to enhance performance.

Читайте также:  Php if var like

Oracle provides the following JDBC drivers:

    Thin driver The JDBC Thin driver is a pure Java, Type IV driver that can be used in applications. It is platform-independent and does not require any additional Oracle software on the client-side. The JDBC Thin driver communicates with the server using Oracle Net Services to access Oracle Database. The JDBC Thin driver enables a direct connection to the database by providing an implementation of Oracle Net Services on top of Java sockets. The driver supports the TCP/IP protocol and requires a TNS listener on the TCP/IP sockets on the database server.

Note: Oracle recommends you to use the Thin driver unless you have a feature that is supported only by a specific driver.

  • Accessing a remote database server from an Oracle Database instance acting as a middle tier
  • Accessing an Oracle Database session from inside another, such as from a Java stored procedure

The use of JDBC Thin driver from a client application or from inside a server does not affect the code.

Note: The server-side internal driver does not support the cancel and setQueryTimeout methods of the Statement class.

The following figure illustrates the architecture of Oracle JDBC drivers and Oracle Database.

Figure 1-1 Architecture of Oracle JDBC Drivers and Oracle Database

Related Topics

Источник

Java oracle jdbc drivers

Get all new and older versions of Oracle JDBC drivers from Maven Central Repository and refer to Maven Central Guide for details.

Guidelines

  • For connections to Oracle Autonomous Database, refer to Java Connectivity to ADB-S for more details.
  • The best practice is use the latest version of the Oracle JDBC driver that supports the JDK and Database version that you use and is compatible with your support requirements. Refer to the section ‘Release Specific Questions’ under JDBC FAQ for more details.
  • 19c is a Long Term Release with a premier support until April 2024 and extended support until April 2027. This is the recommended version.
  • 21c is an Innovation Release with a premier support until April 2024. Refer to page#6 of Lifetime Support Policy for more details.
  • Oracle Database 23c Free is a community supported release of the Oracle Database family. Please go to the Oracle Database Free Community Forum for help, feedback, and enhancement requests.
  • To check the version of the Oracle JDBC driver, use java -jar ojdbcX.jar (eg., java -jar ojdbc8.jar or java -jar ojdbc11.jar).
  • You can also get the older release and quarterly updates of Oracle JDBC drivers from Oracle JDBC Drivers Archive

Refer to these documents for more information

Oracle Database 23c Free — Developer Release (23.2.0.0) JDBC Driver & UCP Downloads

Supports Oracle Database versions — 23c, 21c, 19c, 18c, and 12.2. Learn more about new features available in Oracle Database 23c Free—Developer Release. Note: The Oracle Database 23c Free Developer Release should not be used in production because SRs will not be available and patches will not be delivered.

  1. Oracle JDBC driver except classes for NLS support in Oracle Object and Collection types.
  2. (6,971,601 bytes) — (SHA1: a19cc23a15caea09f4883e938907129354239e75)
  1. Oracle JDBC driver except classes for NLS support in Oracle Object and Collection types.
  2. (6,844,991 bytes) — (SHA1: 49acfb33ee776e43d2085e2fcc838778202a9128)
  1. Universal Connection Pool (UCP) to be used with ojdbc11.jar
  2. (1,513,648 bytes) — (SHA1: 0638ee573f2b7bf873702fae533f291099ac7681)
  1. Universal Connection Pool (UCP) to be used with ojdbc8.jar
  2. (1,471,956 bytes) — (SHA1: 1b5300b30d54d091f7af7dc9070681c62fdad04c)
  1. This archive contains ojdbc11.jar, ucp11.jar, Reactive Streams Ingest (rsi.jar), companion jars 1 , JDBC, UCP, RSI Javadoc, and their Readmes. Refer to README.txt in the zip for details.
  2. (26,562,560 bytes) — (SHA1: 41204e77573e9d36397016a18b0abc932580c44f)
  1. This archive contains ojdbc8.jar, ucp.jar, Reactive Streams Ingest (rsi.jar), companion jars 1 , JDBC, UCP, RSI Javadoc, and their Readmes. Refer to README.txt in the zip for details.
  2. (25,907,200 bytes) — (SHA1: fed6c77364cb34cdd2e8236ec0a292a77d736e8d)
Читайте также:  Media query in css file

1- The companion jars consist of oraclepki.jar, orai18n.jar, ons.jar, simplefan.jar, xdb.jar, xmlparserv2.jar, and xmlparserv2_sans_jaxp_services.jar, dms.jar

Oracle Database 19c (19.19.0.0) JDBC Driver & UCP Downloads — Long Term Release

  1. Oracle JDBC driver except classes for NLS support in Oracle Object and Collection types.
  2. (4,535,376 bytes) — (SHA1: e172880a3b3e34efdc167874108f43a5063473ed)
  1. Oracle JDBC driver except classes for NLS support in Oracle Object and Collection types.
  2. (4,502,465 bytes) — (SHA1: eb90c858f6b8856123d01b8fadd0d57b8505cc2a)
  1. Universal Connection Pool (UCP)
  2. (1,695,327 bytes) — (SHA1: 04c2f3be53e392796737e0ea27494a730a929130)
  1. This archive contains ojdbc10.jar, ucp.jar, companion jars 1 , diagnosability jars 2 , JDBC, UCP, RSI Javadoc, and their Readmes. Refer to README.txt in the zip for details.
  2. (45,189,120 bytes) — (SHA1: 0a43a27c70625d6515c330182ae5eb8f09d109d3)
  1. This archive contains ojdbc8.jar, ucp.jar, companion jars 1 , diagnosability jars 2 , JDBC, UCP, RSI Javadoc, and their Readmes. Refer to README.txt in the zip for details.
  2. (44,492,800 bytes) — (SHA1: ea3e976d4c225f557f9f3e9b0f727b25efaab4a0)

Oracle Database 21c (21.10.0.0) JDBC Driver & UCP Downloads — Innovation Release

  1. Oracle JDBC driver except classes for NLS support in Oracle Object and Collection types.
  2. (5,246,781 bytes) — (SHA1: 7dbf9190eb3a8b76cea50ce214b4cc91fb498fc6)
  1. Oracle JDBC driver except classes for NLS support in Oracle Object and Collection types.
  2. (5,154,257 bytes) — (SHA1: b570dea1f4f9ca021a313462e2c58d77ab16b2ae)
  1. Universal Connection Pool to be used with ojdbc11.jar
  2. (1,807,381 bytes) — (SHA1: c06599882a54e819f18612bcb25c1f6157c379dd)
  1. Universal Connection Pool to be used with ojdbc8.jar
  2. (1,806,407 bytes) — (SHA1: 2cf7a2f0a6233bfb9f1f8b64c0c259efab9a7265)
  1. This archive contains ojdbc11.jar, ucp.jar, Reactive Streams Ingest (rsi.jar), companion jars 1 , diagnosability jars 2 , JDBC, UCP, RSI Javadoc, their Readmes, and Bugs-fixed-in-217.txt. Refer to README.txt in the zip for details.
  2. (52,858,880 bytes) — (SHA1: 521c56bdcea96b0fa46bbe3b720acff806269436)
  1. This archive contains ojdbc8.jar, ucp.jar, Reactive Streams Ingest (rsi.jar), companion jars 1 , diagnosability jars 2 , JDBC, UCP, RSI Javadoc, and their Readmes. Refer to README.txt in the zip for details.
  2. (49,336,320 bytes) — (SHA1: 732721eabd4ec964e19649f40bb5e5f4463b5cb7)

Источник

Оцените статью
© 2023 Программирование