JDBC 3.0 Feature: Support for IEEE datatypes BINARY_DOUBLE,
BINARY_FLOAT- Planet Distance Application Readme

1. Introduction
2. Application Overview
3. Sample Application Files
4. Setting up the Sample Application

1.1 Pre-requisites

Fundamental concepts of using and working with Java, JDBC, SQL, Oracle Database.

1.2 Technical Overview

This sample application illustrates the new JDBC 3.0 feature: Support for IEEE datatypes BINARY_DOUBLE and BINARY_FLOAT within the Oracle Database 10g as well as from the Oracle JDBC 10g.

Fundamentals of the datatypes:

BINARY_DOUBLE is a 64-bit, double-precision floating-point number datatype. Each BINARY_DOUBLE value requires 9 bytes, including a length byte. A 64-bit double format number X is divided as

sign	s	1-bit
exponent	e	11-bits
fraction	f	52-bits

BINARY_FLOAT is a 32-bit, single-precision floating-point number datatype. Each BINARY_FLOAT value requires 5 bytes, including a length byte. A 32-bit single format number X is divided as

sign	s	1-bit
exponent	e	8-bits
fraction	f	23-bits

In a NUMBER column, floating point numbers have decimal precision. In a BINARY_FLOAT or BINARY_DOUBLE column, floating-point numbers have binary precision. The binary floating-point numbers support the special values infinity and NaN (not a number).

Support from JDBC:
In order to bind a binary_float or binary_double parameter, cast the prepared statement to oracle.jdbc.driver.OraclePreparedStatement and invoke setBinaryFloat() or SetBinaryDouble(). If you instead invoke setFloat() or setDouble(), the actual data bind will be done as for a NUMBER column and there will be both loss of performance and possible data corruption.

    .......
    .......
    
    // OraclePreparedStatement object to execute the SQL INSERT statement.
    OraclePreparedStatement opstmt = null;
    .....

    // Create the SQL query string to select the records.
    String sqlQuery = "INSERT INTO planet_au_distance "+
                      " VALUES(?,?,?,?,?,149600000)";

    // Create the PreparedStatement object with the SQL query String.
    opstmt = (OraclePreparedStatement)conn.prepareStatement(sqlQuery);
    .......
    .......
      
    // Get the distance of the planet.
    double distance = Double.parseDouble(dist);
      
    // 1 Astronomical Unit(AU)= 149600000 Kms; avg. distance between 
    // Sun-Earth. Divide the distance by AU.
    double distVal = distance/149600000;
    Double dbl1 = new Double(distVal);     
      
    // Bind the 'BINARY_DOUBLE' datatype value.
    BINARY_DOUBLE biD = new BINARY_DOUBLE(dbl1.doubleValue());
    opstmt.setBinaryDouble(3,biD);

    // Bind the 'BINARY_FLOAT' datatype value.
    BINARY_FLOAT biF = new BINARY_FLOAT(dbl1.floatValue());
    opstmt.setBinaryFloat(4,biF);
      
    // Bind the normal 'NUMBER' datatype value.
    int biN = (int)distVal;
    opstmt.setInt(5,biN);
            
    // Execute the PreparedStatement.
    int val =opstmt.executeUpdate();

    .......
    .......