D80149GC20_les07.pdf - Unauthorized reproduction or...

  • No School
  • AA 1
  • weweapo3
  • 48

This preview shows page 1 - 5 out of 48 pages.

7 Configuring JDBC Copyright © 2016, Oracle and/or its affiliates. All rights reserved. Innocent Matinya ([email protected]ฺcom) has a non-transferable license to use this Student Guideฺ Unauthorized reproduction or distribution prohibitedฺ Copyright© 2019, Oracle and/or its affiliatesฺ
Image of page 1
Objectives After completing this lesson, you should be able to configure: A generic data source A GridLink data source Copyright © 2016, Oracle and/or its affiliates. All rights reserved. Oracle WebLogic Server 12 c : Administration I 7 - 2 Innocent Matinya ([email protected]ฺcom) has a non-transferable license to use this Student Guideฺ Unauthorized reproduction or distribution prohibitedฺ Copyright© 2019, Oracle and/or its affiliatesฺ
Image of page 2
JDBC: Overview The Java Database Connectivity (JDBC) API: Is a platform and vendor-independent mechanism for accessing and using a database Provides transparency from proprietary vendor issues Requires the use of a driver (a Java class) Requires the use of a driver JDBC drivers are supplied with the WebLogic Server installation or by your database vendor. Get connection Get connection SQL statements Application Code Database Driver Database calls The JDBC API is the way in Java code to work with the database Structured Query Language (SQL). It builds on Open Database Connectivity (ODBC), so developers familiar with ODBC find it easy to use. Copyright © 2016, Oracle and/or its affiliates. All rights reserved. By using JDBC, a Java application can access virtually any relational database and run on any platform with a Java Virtual Machine (JVM). That is, with JDBC, it is not necessary to write one program to access a Sybase database, another to access an Oracle database, another to access an IBM DB2 database, and so on. You can write a single program by using the JDBC API. Because the application is written in Java, you need not write different applications to run on different platforms, such as Windows and Linux. JDBC li h d t b ti b i d i h i th t t l t th JDBC accomplishes database connections by using a driver mechanism that translates the JDBC calls to native database calls. Although most available drivers are fully written in Java (Type 4 drivers), and are thus platform independent, some drivers (Type 2) use native libraries and are targeted to specific platforms. Oracle WebLogic Server 12 c : Administration I 7 - 3 Innocent Matinya ([email protected]ฺcom) has a non-transferable license to use this Student Guideฺ Unauthorized reproduction or distribution prohibitedฺ Copyright© 2019, Oracle and/or its affiliatesฺ
Image of page 3
WebLogic JDBC Drivers Oracle and third-party drivers for many databases are included in the WebLogic Server installation: Oracle 11 g and 12 c Sybase Mi ft SQL S Microsoft SQL Server IBM DB2 Informix MySQL By default, these drivers are added to the server’s CLASSPATH . To use other drivers, you must update the server’s CLASSPATH .
Image of page 4
Image of page 5

You've reached the end of your free preview.

Want to read all 48 pages?

  • Fall '19

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture