142.

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;}
closeJava Programming with Oracle SQLJ
  Copyright
  Table of Contents
 openPreface
 open1. Introduction
 open2. Relational Databases, SQL, and PL/SQL
 open3. Fundamental SQLJ Programming
 open4. Database Objects
 open5. Collections
 open6. Deploying SQLJ in the JServer
 open7. Large Objects
 open8. Contexts and Multithreading
 open9. Advanced Transaction Control
 open10. Performance Tuning
 open11. Combining JDBC, SQLJ, and Dynamic SQL
 closeA. 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
 openB. Oracle Java Utilities Reference
 openC. SQLJ in Applets, Servlets, and JavaServer Pages
  Colophon
  Index

Database > Java Programming with Oracle SQLJ > A. Java and Oracle Type Mappings > A.5 Oracle Extension Class Mappings

< BACKCONTINUE >

A.5 Oracle Extension Class Mappings

Most of the Oracle extensions are alternatives to the JDBC types. The oracle.sql.NUMBER type is particularly useful when storing and retrieving NUMBER columns because there is no loss of precision, as may occur when using the JDBC numeric types. The oracle.sql.ROWID type allows you to store an Oracle rowid value (rowids were discussed in Chapter 2); Oracle stores a unique address for every row in the database using a column named ROWID of type ROWID. The oracle.sql.NUMBER and oracle.sql.ROWID types were covered in Chapter 3. The oracle.sql.BLOB, oracle.sql.CLOB, and oracle.sql.BFILE types, covered in Chapter 7, allow you to access the Oracle methods for large objects. Table A-5 lists the mappings between the Oracle extension classes and the compatible Oracle types.

Table A-5. Oracle extension class mappings

Java type

Oracle type

oracle.sql.NUMBER

NUMBER

oracle.sql.CHAR

CHAR

oracle.sql.RAW

RAW

oracle.sql.DATE

DATE

oracle.sql.ROWID

ROWID

oracle.sql.BLOB

BLOB

oracle.sql.CLOB

CLOB

oracle.sql.BFILE

BFILE

oracle.sql.STRUCT

STRUCT

oracle.sql.REF

REF

oracle.sql.ARRAY

ARRAY

< BACKCONTINUE >

Index terms contained in this section

CHAR datatype
      oracle.sql.CHAR extension class
datatypes
     Java and Oracle type mappings
            Oracle extension classes
oracle.sql.ARRAY extension class
oracle.sql.BFILE extension class
oracle.sql.BLOB extension class
oracle.sql.CLOB extension class
oracle.sql.DATE extension class
oracle.sql.NUMBER extension class
oracle.sql.RAW extension class
oracle.sql.REF extension class
oracle.sql.ROWID extension class
oracle.sql.STRUCT extension class



Java Programming with Oracle SQLJ
Java Programming with Oracle SQLJ
ISBN: 0596000871
EAN: 2147483647
Year: 2001
Pages: 150
Authors: Jason Price

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net