Intro-Using Java with Oracle db(notes)

http://db11.cse.cuhk.edu.hk/doc/appdev.111/b28765/introduction.htm#sthref10

 

CLI: Call Level Interface-JDBC is based on the X/Open Sql CLI

 

The core Java class lib provide the JDBC APIs, java.sql and javax.sql.

 

Oracle DB: client-side app development by JDBC Thin Driver and OCI Driver(Oracle Call Interface) and the oracle.sql and oracle.jdbc packages (classes, interfaces -- access and modify oracle data types and use Oracle performance extensions for JDBC with greater flex. in a Java app)

 

JDBC Thin Driver: commu with server using SQL*Net to access db.

a pure java implementation of Oracle network protocols (two-task common/TTC, SQL*Net)

supports TCP/IP.

JDBC OCI Driver: 

Packages: 

oracle.sql: direct access to data in SQL format.

oracle.jdbc: key classes and interfaces 

-------------------------------------------------------------------------

JDeveloper:

JDeveloper provides functions and features to do the following:

• Create a connection to a database

• Browse database objects

• Create, edit, or delete database objects

• Create and edit PL/SQL functions, procedures, and packages