Introduction to WebLogic JDBC| Weblogic JDBC Introduction

Introduction to WebLogic JDBC

  • The Java Database Connectivity (JDBC) specification:
–Is a platform- and vendor-independent mechanism for accessing and updating a database
–Provides transparency from proprietary vendor issues
–Requires the use of a driver
  • JDBC drivers are supplied by WebLogic Server or by your database vendor.

JDBC Data Sources:

Data sources:

  • Enable database connectivity to be managed by the application server
  • Are obtained by applications from the server’s JNDI tree
  • Use a dynamic pool of reusable database connections

Data Source Scope:

  • Each data source configuration or “module” is persisted as a separate XML document.
    • –Stored in the domain’s config/jdbc directory
    –Available to all applications in the domain
    •  Application-specific modules are:
    –Deployed as part of Java Platform, Enterprise Edition (Java EE) enterprise applications
    –Accessible only by the containing application

    Multi-Tier Architecture:

    •  In the multi-tier model, commands are sent to a “middle tier” of services, which then sends the commands to the DBMS.
  • The system modules that are created with the console or WLST are:
  •  The DBMS processes the commands and sends the results back to the middle tier, which then sends them to the client.

    WebLogic JDBC Drivers:

    •  Oracle and third-party drivers are included in the WLS installation for many popular database products:
    –Oracle 9i, 10g, and 11g
    –Sybase Adaptive Server
    –Microsoft SQL Server
    –IBM DB2
    –Informix
    –MySQL
    –PointBase
    •  By default, these drivers are added to the server’s classpath.
     

    •