The Java Developers Almanac 1.4


Order this book from Amazon.

   
Home > List of Packages > java.sql  [73 examples] > Oracle OBJECTs  [5 examples]

e298. Inserting an OBJECT Value into an Oracle Table Using a Prepared Statement

This example inserts Oracle OBJECTs into an Oracle table using a prepared statement. The example uses the OBJECT types and table created in e296 Creating an OBJECT Type in an Oracle Database.
    try {
        // Create an oracle.sql.STRUCT object to hold the values for object2
        Object[] object2Values = new Object[]{"str", new BigDecimal(123)};
        oracle.sql.StructDescriptor structDesc =
            oracle.sql.StructDescriptor.createDescriptor("OBJECT2", connection);
        oracle.sql.STRUCT object2 =
            new oracle.sql.STRUCT(structDesc, connection, object2Values);
    
        // Create an oracle.sql.STRUCT object to hold the values for object1
        Object[] object1Values = new Object[]{"str", object2};
        structDesc = oracle.sql.StructDescriptor.createDescriptor("OBJECT1", connection);
        oracle.sql.STRUCT object1 =
            new oracle.sql.STRUCT(structDesc, connection, object1Values);
    
        // Create a prepared statement for insertion into object1_table
        PreparedStatement ps =
            connection.prepareStatement("INSERT INTO object1_table VALUES(?,?)");
    
        // Set the values to insert
        ps.setInt(1, 123);
        ps.setObject(2, object1);
    
        // Insert the new row
        ps.execute();
    } catch (SQLException e) {
    }

 Related Examples
e296. Creating an OBJECT Type in an Oracle Database
e297. Inserting an OBJECT Value into an Oracle Table
e299. Getting an OBJECT Value from an Oracle Table
e300. Deleting an OBJECT Type from an Oracle Table

See also: Batching    Connections    Database Meta Data    Deleting Data    Drivers    Importing and Exporting    Inserting and Updating Data    Oracle VARRAYs    Procedures and Functions    Retrieving Data    Scrollable Result Sets    Tables    Updatable Result Sets   


© 2002 Addison-Wesley.