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.1 JDBC 1.x Type Mappings

< BACKCONTINUE >

A.1 JDBC 1.x Type Mappings

Table A-1 lists the mappings between the JDBC 1.x types and the compatible Oracle types.

Table A-1. JDBC 1.x type mappings

Java type

Oracle type

boolean

NUMBER

byte

NUMBER

short

NUMBER

int

NUMBER

long

NUMBER

float

NUMBER

double

NUMBER

java.lang.String

CHAR

java.lang.String

VARCHAR2

java.lang.String

LONG

byte[]

RAW

byte[]

RAW

byte[]

LONGRAW

java.sql.Date

DATE

java.sql.Time

DATE

java.sql.Timestamp

DATE

java.math.BigDecimal

NUMBER

java.math.BigDecimal

NUMBER

< BACKCONTINUE >

Index terms contained in this section

boolean datatype byte datatypes byte[] type CHAR datatype datatypes      Java and Oracle type mappings             JDBC 1.x             JOracle types double datatype float datatype (Java) int datatype (Java) java.lang.String type java.math.BigDecimal type java.sql.Date type java.sql.Time type java.sql.Timestamp type LONG datatype LONGRAW type RAW type short datatype strings       JDBC 1.x, mapping to Oracle types Time datatype Timestamp datatype VARCHAR2 database type

Related

Категории