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 Informix® 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 Informix® SET column into a java.util.HashSet object
demo6.java Fetches the Informix® 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 Informix® SET column
demo8.java Fetches the Informix® SET column into a java.sql.Array object
dropDB.java Drops the database