Examples in the complex-types directory

The following table lists the files in the complex-types directory.


Demo program name	Description
createDB.java	Creates a database with named rows
list1.java	Inserts and selects a simple collection using both the java.sql.Array and java.util.Collection classes
list2.java	Inserts and selects a collection with a nested row element Uses both the java.sql.Array and java.util.Collection classes for the collection and both the SQLData and Struct interfaces for the nested row
r1_t.java	Defines the SQLData class for named row r1_t
r2_t.java	Defines the SQLData class for named row r2_t
GenericStruct.java	Instantiates a java.sql.Struct object for inserting into named or unnamed rows
row1.java	Inserts and selects a simple named row using both the SQLData and Struct interfaces
row2.java	Inserts and selects a named row with a nested collection using both the SQLData and Struct interfaces The SQLData interface uses the HCL OneDB™ IfmxComplexSQLOutput. writeObject() and IfmxComplexSQLOutput.readObject() extension methods to write and read the nested collection.
row3.java	Inserts and selects an unnamed row with a nested collection
fullname.java	Contains the SQLData class for the named row fullname_t Used by the demo1.java and demo2.java files
person.java	Contains the SQLData class for the named row person_t Used by the demo1.java and demo2.java files
demo1.java	Fetches a named row into an SQLData object
demo2.java	Inserts an SQLData object into a named row column
demo3.java	Fetches an unnamed row column into a Struct object
demo4.java	Inserts a Struct object into a named row column
demo5.java	Fetches the HCL OneDB SET column into a java.util.HashSet object
demo6.java	Fetches the HCL OneDB SET column into a java.util.TreeSet object A customized type mapping is provided to override the default.
demo7.java	Inserts a java.util.HashSet object into the HCL OneDB SET column
demo8.java	Fetches the HCL OneDB SET column into a java.sql.Array object
dropDB.java	Drops the database