137.

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

< BACK

CONTINUE >

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

< BACK

CONTINUE >

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