Java Programming with Oracle SQLJ

var PrxLC=new Date(0);var PrxModAtr=0;var PrxInst; if(!PrxInst++) PrxRealOpen=window.open;function PrxOMUp(){PrxLC=new Date();}function PrxNW(){return(this.window);} function PrxOpen(url,nam,atr){ if(PrxLC){ var cdt=new Date(); cdt.setTime(cdt.getTime()-PrxLC.getTime()); if(cdt.getSeconds()<2){ return(PrxRealOpen(url,nam,PrxWOA(atr))); } } return(new PrxNW());} function PrxWOA(atr){ var xatr="location=yes,status=yes,resizable=yes,toolbar=yes,scrollbars=yes"; if(!PrxModAtr) return(atr); if(atr){ var hm; hm=atr.match(/height=[0-9]+/i); if(hm) xatr+="," + hm; hm=atr.match(/width=[0-9]+/i); if(hm) xatr+="," + hm; } return(xatr);}window.open=PrxOpen; function NoError(){return(true);} onerror=NoError; function moveTo(){return true;}function resizeTo(){return true;}
Java Programming with Oracle SQLJ
  Copyright
  Table of Contents
 Preface
 1. Introduction
 2. Relational Databases, SQL, and PL/SQL
 3. Fundamental SQLJ Programming
 4. Database Objects
 5. Collections
 6. Deploying SQLJ in the JServer
 7. Large Objects
 8. Contexts and Multithreading
 9. Advanced Transaction Control
 10. Performance Tuning
 11. Combining JDBC, SQLJ, and Dynamic SQL
 A. Java and Oracle Type Mappings
   A.1 JDBC 1.x Type Mappings
  A.2 Additional JDBC 2.0 Type Mappings
   A.3 Java Wrapper Class Mappings
   A.4 SQLJ Stream Class Mappings
   A.5 Oracle Extension Class Mappings
 B. Oracle Java Utilities Reference
 C. SQLJ in Applets, Servlets, and JavaServer Pages
  Colophon
  Index

Database > Java Programming with Oracle SQLJ > A. Java and Oracle Type Mappings > A.2 Additional JDBC 2.0 Type Mappings

< BACKCONTINUE >

A.2 Additional JDBC 2.0 Type Mappings

Table A-2 lists the mappings between the additional JDBC 2.0 types and the compatible Oracle types. The mappings shown in the previous table for the JDBC 1.x types also still apply for JDBC 2.0.

Table A-2. Additional JDBC 2.0 type mappings

Java type

Oracle type

java.sql.Blob

BLOB

java.sql.Clob

CLOB

java.sql.Struct

STRUCT

java.sql.Ref

REF

java.sql.Array

ARRAY

< BACKCONTINUE >

Index terms contained in this section

BLOBs (binary large objects) CLOBs (character large objects) datatypes      Java and Oracle type mappings             JDBC 2.0 java.sql.Array type java.sql.Blob type java.sql.Clob type java.sql.Ref type REF datatypes Struct datatype STRUCT type

Категории