Compiling the Java files
========================
On Windows Platform:
%JAVA_HOME%\bin\javac -classpath ..\..\lib\jdbcT4.jar *.java ..\common\*.java

On Linux:
$JAVA_HOME/bin/javac -classpath ../../lib/jdbcT4.jar *.java ../common/*.java

Note: Make sure there are no compilation errors displayed on
      the screen.


Executing DBMetaSample
======================
On Windows Platform:
%JAVA_HOME%\bin\java -classpath ..\..\lib\jdbcT4.jar;..;. -Dt4jdbc.properties=..\t4jdbc.properties DBMetaSample

On Linux:
$JAVA_HOME/bin/java -classpath ../../lib/jdbcT4.jar:..:. -Dt4jdbc.properties=../t4jdbc.properties DBMetaSample


Output of the execution would look like:
========================================
<DATE, TIME> common.sampleUtils getPropertiesConnection
INFO: DriverManager.getConnection(url, props) passed

Inserting TimeStamp

INFO: DriverManager.getConnection(url, props) passed

Inserting TimeStamp


getTypeInfo()

Printing ResultSetMetaData ...
No. of Columns 19
Column 1 Data Type: VARCHAR Name: TYPE_NAME
Column 2 Data Type: SMALLINT Name: DATA_TYPE
Column 3 Data Type: INTEGER Name: PRECISION
Column 4 Data Type: VARCHAR Name: LITERAL_PREFIX
Column 5 Data Type: VARCHAR Name: LITERAL_SUFFIX
Column 6 Data Type: VARCHAR Name: CREATE_PARAMS
Column 7 Data Type: SMALLINT Name: NULLABLE
Column 8 Data Type: SMALLINT Name: CASE_SENSITIVE
Column 9 Data Type: SMALLINT Name: SEARCHABLE
Column 10 Data Type: SMALLINT Name: UNSIGNED_ATTRIBUTE
Column 11 Data Type: SMALLINT Name: FIXED_PREC_SCALE
Column 12 Data Type: SMALLINT Name: AUTO_INCREMENT
Column 13 Data Type: VARCHAR Name: LOCAL_TYPE_NAME
Column 14 Data Type: SMALLINT Name: MINIMUM_SCALE
Column 15 Data Type: SMALLINT Name: MAXIMUM_SCALE
Column 16 Data Type: SMALLINT Name: SQL_DATA_TYPE
Column 17 Data Type: SMALLINT Name: SQL_DATETIME_SUB
Column 18 Data Type: SMALLINT Name: NUM_PREC_RADIX
Column 19 Data Type: SMALLINT Name: INTERVAL_PRECISION

Fetching rows...

Printing Row 1 using getString(), getObject()
Column 1 - BIGINT,BIGINT
Column 2 - -5,-5
Column 3 - 19,19
Column 4 - null,null
Column 5 - null,null
Column 6 - null,null
Column 7 - 1,1
Column 8 - 0,0
Column 9 - 2,2
Column 10 - 0,0
Column 11 - 0,0
Column 12 - 0,0
Column 13 - LARGEINT,LARGEINT
Column 14 - null,null
Column 15 - null,null
Column 16 - -402,-402
Column 17 - null,null
Column 18 - 10,10
Column 19 - null,null

Printing Row 2 using getString(), getObject()
Column 1 - BIGINT SIGNED,BIGINT SIGNED
Column 2 - -5,-5
Column 3 - 19,19
Column 4 - null,null
Column 5 - null,null
Column 6 - null,null
Column 7 - 1,1
Column 8 - 0,0
Column 9 - 2,2
Column 10 - 0,0
Column 11 - 0,0
Column 12 - 0,0
Column 13 - LARGEINT,LARGEINT
Column 14 - null,null
Column 15 - null,null
Column 16 - -402,-402
Column 17 - null,null
Column 18 - 10,10
Column 19 - null,null

Printing Row 3 using getString(), getObject()
Column 1 - CHAR,CHAR
Column 2 - 1,1
Column 3 - 32000,32000
Column 4 - ','
Column 5 - ','
Column 6 - max length,max length
Column 7 - 1,1
Column 8 - 1,1
Column 9 - 3,3
Column 10 - null,null
Column 11 - 0,0
Column 12 - null,null
Column 13 - CHARACTER,CHARACTER
Column 14 - null,null
Column 15 - null,null
Column 16 - 1,1
Column 17 - null,null
Column 18 - null,null
Column 19 - null,null

Printing Row 4 using getString(), getObject()
Column 1 - NUMERIC,NUMERIC
Column 2 - 2,2
Column 3 - 128,128
Column 4 - null,null
Column 5 - null,null
Column 6 - precision,scale,precision,scale
Column 7 - 1,1
Column 8 - 0,0
Column 9 - 2,2
Column 10 - 0,0
Column 11 - 0,0
Column 12 - 0,0
Column 13 - NUMERIC,NUMERIC
Column 14 - 0,0
Column 15 - 128,128
Column 16 - 2,2
Column 17 - null,null
Column 18 - 10,10
Column 19 - null,null

Printing Row 5 using getString(), getObject()
Column 1 - NUMERIC SIGNED,NUMERIC SIGNED
Column 2 - 2,2
Column 3 - 128,128
Column 4 - null,null
Column 5 - null,null
Column 6 - precision,scale,precision,scale
Column 7 - 1,1
Column 8 - 0,0
Column 9 - 2,2
Column 10 - 0,0
Column 11 - 0,0
Column 12 - 0,0
Column 13 - NUMERIC,NUMERIC
Column 14 - 0,0
Column 15 - 128,128
Column 16 - 2,2
Column 17 - null,null
Column 18 - 10,10
Column 19 - null,null

Printing Row 6 using getString(), getObject()
Column 1 - NUMERIC UNSIGNED,NUMERIC UNSIGNED
Column 2 - 2,2
Column 3 - 128,128
Column 4 - null,null
Column 5 - null,null
Column 6 - precision,scale,precision,scale
Column 7 - 1,1
Column 8 - 0,0
Column 9 - 2,2
Column 10 - 1,1
Column 11 - 0,0
Column 12 - 0,0
Column 13 - NUMERIC,NUMERIC
Column 14 - 0,0
Column 15 - 128,128
Column 16 - 2,2
Column 17 - null,null
Column 18 - 10,10
Column 19 - null,null

Printing Row 7 using getString(), getObject()
Column 1 - DECIMAL,DECIMAL
Column 2 - 3,3
Column 3 - 18,18
Column 4 - null,null
Column 5 - null,null
Column 6 - precision,scale,precision,scale
Column 7 - 1,1
Column 8 - 0,0
Column 9 - 2,2
Column 10 - 0,0
Column 11 - 0,0
Column 12 - 0,0
Column 13 - DECIMAL,DECIMAL
Column 14 - 0,0
Column 15 - 18,18
Column 16 - 3,3
Column 17 - null,null
Column 18 - 10,10
Column 19 - null,null

Printing Row 8 using getString(), getObject()
Column 1 - DECIMAL SIGNED,DECIMAL SIGNED
Column 2 - 3,3
Column 3 - 18,18
Column 4 - null,null
Column 5 - null,null
Column 6 - precision,scale,precision,scale
Column 7 - 1,1
Column 8 - 0,0
Column 9 - 2,2
Column 10 - 0,0
Column 11 - 0,0
Column 12 - 0,0
Column 13 - DECIMAL,DECIMAL
Column 14 - 0,0
Column 15 - 18,18
Column 16 - 3,3
Column 17 - null,null
Column 18 - 10,10
Column 19 - null,null

Printing Row 9 using getString(), getObject()
Column 1 - DECIMAL UNSIGNED,DECIMAL UNSIGNED
Column 2 - 3,3
Column 3 - 18,18
Column 4 - null,null
Column 5 - null,null
Column 6 - precision,scale,precision,scale
Column 7 - 1,1
Column 8 - 0,0
Column 9 - 2,2
Column 10 - 1,1
Column 11 - 0,0
Column 12 - 0,0
Column 13 - DECIMAL,DECIMAL
Column 14 - 0,0
Column 15 - 18,18
Column 16 - -301,-301
Column 17 - null,null
Column 18 - 10,10
Column 19 - null,null

Printing Row 10 using getString(), getObject()
Column 1 - INTEGER,INTEGER
Column 2 - 4,4
Column 3 - 10,10
Column 4 - null,null
Column 5 - null,null
Column 6 - null,null
Column 7 - 1,1
Column 8 - 0,0
Column 9 - 2,2
Column 10 - 0,0
Column 11 - 0,0
Column 12 - 0,0
Column 13 - INTEGER,INTEGER
Column 14 - null,null
Column 15 - null,null
Column 16 - 4,4
Column 17 - null,null
Column 18 - 10,10
Column 19 - null,null

Printing Row 11 using getString(), getObject()
Column 1 - INTEGER SIGNED,INTEGER SIGNED
Column 2 - 4,4
Column 3 - 10,10
Column 4 - null,null
Column 5 - null,null
Column 6 - null,null
Column 7 - 1,1
Column 8 - 0,0
Column 9 - 2,2
Column 10 - 0,0
Column 11 - 0,0
Column 12 - 0,0
Column 13 - INTEGER,INTEGER
Column 14 - null,null
Column 15 - null,null
Column 16 - 4,4
Column 17 - null,null
Column 18 - 10,10
Column 19 - null,null

Printing Row 12 using getString(), getObject()
Column 1 - INTEGER UNSIGNED,INTEGER UNSIGNED
Column 2 - 4,4
Column 3 - 10,10
Column 4 - null,null
Column 5 - null,null
Column 6 - null,null
Column 7 - 1,1
Column 8 - 0,0
Column 9 - 2,2
Column 10 - 1,1
Column 11 - 0,0
Column 12 - 0,0
Column 13 - INTEGER,INTEGER
Column 14 - null,null
Column 15 - null,null
Column 16 - -401,-401
Column 17 - null,null
Column 18 - 10,10
Column 19 - null,null

Printing Row 13 using getString(), getObject()
Column 1 - SMALLINT,SMALLINT
Column 2 - 5,5
Column 3 - 5,5
Column 4 - null,null
Column 5 - null,null
Column 6 - null,null
Column 7 - 1,1
Column 8 - 0,0
Column 9 - 2,2
Column 10 - 0,0
Column 11 - 0,0
Column 12 - 0,0
Column 13 - SMALLINT,SMALLINT
Column 14 - null,null
Column 15 - null,null
Column 16 - 5,5
Column 17 - null,null
Column 18 - 10,10
Column 19 - null,null

Printing Row 14 using getString(), getObject()
Column 1 - SMALLINT SIGNED,SMALLINT SIGNED
Column 2 - 5,5
Column 3 - 5,5
Column 4 - null,null
Column 5 - null,null
Column 6 - null,null
Column 7 - 1,1
Column 8 - 0,0
Column 9 - 2,2
Column 10 - 0,0
Column 11 - 0,0
Column 12 - 0,0
Column 13 - SMALLINT,SMALLINT
Column 14 - null,null
Column 15 - null,null
Column 16 - 5,5
Column 17 - null,null
Column 18 - 10,10
Column 19 - null,null

Printing Row 15 using getString(), getObject()
Column 1 - SMALLINT UNSIGNED,SMALLINT UNSIGNED
Column 2 - 5,5
Column 3 - 5,5
Column 4 - null,null
Column 5 - null,null
Column 6 - null,null
Column 7 - 1,1
Column 8 - 0,0
Column 9 - 2,2
Column 10 - 1,1
Column 11 - 0,0
Column 12 - 0,0
Column 13 - SMALLINT,SMALLINT
Column 14 - null,null
Column 15 - null,null
Column 16 - -502,-502
Column 17 - null,null
Column 18 - 10,10
Column 19 - null,null

Printing Row 16 using getString(), getObject()
Column 1 - FLOAT,FLOAT
Column 2 - 6,6
Column 3 - 15,15
Column 4 - null,null
Column 5 - null,null
Column 6 - null,null
Column 7 - 1,1
Column 8 - 0,0
Column 9 - 2,2
Column 10 - 0,0
Column 11 - 0,0
Column 12 - 0,0
Column 13 - FLOAT,FLOAT
Column 14 - null,null
Column 15 - null,null
Column 16 - 6,6
Column 17 - null,null
Column 18 - 2,2
Column 19 - null,null

Printing Row 17 using getString(), getObject()
Column 1 - REAL,REAL
Column 2 - 7,7
Column 3 - 7,7
Column 4 - null,null
Column 5 - null,null
Column 6 - null,null
Column 7 - 1,1
Column 8 - 0,0
Column 9 - 2,2
Column 10 - 0,0
Column 11 - 0,0
Column 12 - 0,0
Column 13 - REAL,REAL
Column 14 - null,null
Column 15 - null,null
Column 16 - 7,7
Column 17 - null,null
Column 18 - 2,2
Column 19 - null,null

Printing Row 18 using getString(), getObject()
Column 1 - DOUBLE PRECISION,DOUBLE PRECISION
Column 2 - 8,8
Column 3 - 15,15
Column 4 - null,null
Column 5 - null,null
Column 6 - null,null
Column 7 - 1,1
Column 8 - 0,0
Column 9 - 2,2
Column 10 - 0,0
Column 11 - 0,0
Column 12 - 0,0
Column 13 - DOUBLE,DOUBLE
Column 14 - null,null
Column 15 - null,null
Column 16 - 8,8
Column 17 - null,null
Column 18 - 2,2
Column 19 - null,null

Printing Row 19 using getString(), getObject()
Column 1 - VARCHAR,VARCHAR
Column 2 - 12,12
Column 3 - 32000,32000
Column 4 - ','
Column 5 - ','
Column 6 - max length,max length
Column 7 - 1,1
Column 8 - 1,1
Column 9 - 3,3
Column 10 - null,null
Column 11 - 0,0
Column 12 - null,null
Column 13 - VARCHAR,VARCHAR
Column 14 - null,null
Column 15 - null,null
Column 16 - 12,12
Column 17 - null,null
Column 18 - null,null
Column 19 - null,null

Printing Row 20 using getString(), getObject()
Column 1 - DATE,DATE
Column 2 - 91,91
Column 3 - 10,10
Column 4 - {d ',{d '
Column 5 - '},'}
Column 6 - null,null
Column 7 - 1,1
Column 8 - 0,0
Column 9 - 2,2
Column 10 - null,null
Column 11 - 0,0
Column 12 - null,null
Column 13 - DATE,DATE
Column 14 - null,null
Column 15 - null,null
Column 16 - 9,9
Column 17 - 1,1
Column 18 - null,null
Column 19 - null,null

Printing Row 21 using getString(), getObject()
Column 1 - TIME,TIME
Column 2 - 92,92
Column 3 - 8,8
Column 4 - {t ',{t '
Column 5 - '},'}
Column 6 - null,null
Column 7 - 1,1
Column 8 - 0,0
Column 9 - 2,2
Column 10 - null,null
Column 11 - 0,0
Column 12 - null,null
Column 13 - TIME,TIME
Column 14 - null,null
Column 15 - null,null
Column 16 - 9,9
Column 17 - 2,2
Column 18 - null,null
Column 19 - null,null

Printing Row 22 using getString(), getObject()
Column 1 - TIMESTAMP,TIMESTAMP
Column 2 - 93,93
Column 3 - 26,26
Column 4 - {ts ',{ts '
Column 5 - '},'}
Column 6 - null,null
Column 7 - 1,1
Column 8 - 0,0
Column 9 - 2,2
Column 10 - null,null
Column 11 - 0,0
Column 12 - null,null
Column 13 - TIMESTAMP,TIMESTAMP
Column 14 - 0,0
Column 15 - 6,6
Column 16 - 9,9
Column 17 - 3,3
Column 18 - null,null
Column 19 - null,null

Printing Row 23 using getString(), getObject()
Column 1 - INTERVAL,INTERVAL
Column 2 - 101,101
Column 3 - 0,0
Column 4 - {INTERVAL ',{INTERVAL '
Column 5 - ' YEAR},' YEAR}
Column 6 - null,null
Column 7 - 1,1
Column 8 - 0,0
Column 9 - 2,2
Column 10 - 0,0
Column 11 - 0,0
Column 12 - null,null
Column 13 - INTERVAL,INTERVAL
Column 14 - 0,0
Column 15 - 0,0
Column 16 - 100,100
Column 17 - 1,1
Column 18 - null,null
Column 19 - 2,2

Printing Row 24 using getString(), getObject()
Column 1 - INTERVAL,INTERVAL
Column 2 - 102,102
Column 3 - 0,0
Column 4 - {INTERVAL ',{INTERVAL '
Column 5 - ' MONTH},' MONTH}
Column 6 - null,null
Column 7 - 1,1
Column 8 - 0,0
Column 9 - 2,2
Column 10 - 0,0
Column 11 - 0,0
Column 12 - null,null
Column 13 - INTERVAL,INTERVAL
Column 14 - 0,0
Column 15 - 0,0
Column 16 - 100,100
Column 17 - 2,2
Column 18 - null,null
Column 19 - 2,2

Printing Row 25 using getString(), getObject()
Column 1 - INTERVAL,INTERVAL
Column 2 - 103,103
Column 3 - 0,0
Column 4 - {INTERVAL ',{INTERVAL '
Column 5 - ' DAY},' DAY}
Column 6 - null,null
Column 7 - 1,1
Column 8 - 0,0
Column 9 - 2,2
Column 10 - 0,0
Column 11 - 0,0
Column 12 - null,null
Column 13 - INTERVAL,INTERVAL
Column 14 - 0,0
Column 15 - 0,0
Column 16 - 100,100
Column 17 - 3,3
Column 18 - null,null
Column 19 - 2,2

Printing Row 26 using getString(), getObject()
Column 1 - INTERVAL,INTERVAL
Column 2 - 104,104
Column 3 - 0,0
Column 4 - {INTERVAL ',{INTERVAL '
Column 5 - ' HOUR},' HOUR}
Column 6 - null,null
Column 7 - 1,1
Column 8 - 0,0
Column 9 - 2,2
Column 10 - 0,0
Column 11 - 0,0
Column 12 - null,null
Column 13 - INTERVAL,INTERVAL
Column 14 - 0,0
Column 15 - 0,0
Column 16 - 100,100
Column 17 - 4,4
Column 18 - null,null
Column 19 - 2,2

Printing Row 27 using getString(), getObject()
Column 1 - INTERVAL,INTERVAL
Column 2 - 105,105
Column 3 - 0,0
Column 4 - {INTERVAL ',{INTERVAL '
Column 5 - ' MINUTE},' MINUTE}
Column 6 - null,null
Column 7 - 1,1
Column 8 - 0,0
Column 9 - 2,2
Column 10 - 0,0
Column 11 - 0,0
Column 12 - null,null
Column 13 - INTERVAL,INTERVAL
Column 14 - 0,0
Column 15 - 0,0
Column 16 - 100,100
Column 17 - 5,5
Column 18 - null,null
Column 19 - 2,2

Printing Row 28 using getString(), getObject()
Column 1 - INTERVAL,INTERVAL
Column 2 - 106,106
Column 3 - 0,0
Column 4 - {INTERVAL ',{INTERVAL '
Column 5 - ' SECOND},' SECOND}
Column 6 - null,null
Column 7 - 1,1
Column 8 - 0,0
Column 9 - 2,2
Column 10 - 0,0
Column 11 - 0,0
Column 12 - null,null
Column 13 - INTERVAL,INTERVAL
Column 14 - 0,0
Column 15 - 0,0
Column 16 - 100,100
Column 17 - 6,6
Column 18 - null,null
Column 19 - 2,2

Printing Row 29 using getString(), getObject()
Column 1 - INTERVAL,INTERVAL
Column 2 - 107,107
Column 3 - 0,0
Column 4 - {INTERVAL ',{INTERVAL '
Column 5 - ' YEAR TO MONTH},' YEAR TO MONTH}
Column 6 - null,null
Column 7 - 1,1
Column 8 - 0,0
Column 9 - 2,2
Column 10 - 0,0
Column 11 - 0,0
Column 12 - null,null
Column 13 - INTERVAL,INTERVAL
Column 14 - 0,0
Column 15 - 0,0
Column 16 - 100,100
Column 17 - 7,7
Column 18 - null,null
Column 19 - 2,2

Printing Row 30 using getString(), getObject()
Column 1 - INTERVAL,INTERVAL
Column 2 - 108,108
Column 3 - 0,0
Column 4 - {INTERVAL ',{INTERVAL '
Column 5 - ' DAY TO HOUR},' DAY TO HOUR}
Column 6 - null,null
Column 7 - 1,1
Column 8 - 0,0
Column 9 - 2,2
Column 10 - 0,0
Column 11 - 0,0
Column 12 - null,null
Column 13 - INTERVAL,INTERVAL
Column 14 - 0,0
Column 15 - 0,0
Column 16 - 100,100
Column 17 - 8,8
Column 18 - null,null
Column 19 - 2,2

Printing Row 31 using getString(), getObject()
Column 1 - INTERVAL,INTERVAL
Column 2 - 109,109
Column 3 - 0,0
Column 4 - {INTERVAL ',{INTERVAL '
Column 5 - ' DAY TO MINUTE},' DAY TO MINUTE}
Column 6 - null,null
Column 7 - 1,1
Column 8 - 0,0
Column 9 - 2,2
Column 10 - 0,0
Column 11 - 0,0
Column 12 - null,null
Column 13 - INTERVAL,INTERVAL
Column 14 - 0,0
Column 15 - 0,0
Column 16 - 100,100
Column 17 - 9,9
Column 18 - null,null
Column 19 - 2,2

Printing Row 32 using getString(), getObject()
Column 1 - INTERVAL,INTERVAL
Column 2 - 110,110
Column 3 - 0,0
Column 4 - {INTERVAL ',{INTERVAL '
Column 5 - ' DAY TO SECOND},' DAY TO SECOND}
Column 6 - null,null
Column 7 - 1,1
Column 8 - 0,0
Column 9 - 2,2
Column 10 - 0,0
Column 11 - 0,0
Column 12 - null,null
Column 13 - INTERVAL,INTERVAL
Column 14 - 0,0
Column 15 - 0,0
Column 16 - 100,100
Column 17 - 10,10
Column 18 - null,null
Column 19 - 2,2

Printing Row 33 using getString(), getObject()
Column 1 - INTERVAL,INTERVAL
Column 2 - 111,111
Column 3 - 0,0
Column 4 - {INTERVAL ',{INTERVAL '
Column 5 - ' HOUR TO MINUTE},' HOUR TO MINUTE}
Column 6 - null,null
Column 7 - 1,1
Column 8 - 0,0
Column 9 - 2,2
Column 10 - 0,0
Column 11 - 0,0
Column 12 - null,null
Column 13 - INTERVAL,INTERVAL
Column 14 - 0,0
Column 15 - 0,0
Column 16 - 100,100
Column 17 - 11,11
Column 18 - null,null
Column 19 - 2,2

Printing Row 34 using getString(), getObject()
Column 1 - INTERVAL,INTERVAL
Column 2 - 112,112
Column 3 - 0,0
Column 4 - {INTERVAL ',{INTERVAL '
Column 5 - ' HOUR TO SECOND},' HOUR TO SECOND}
Column 6 - null,null
Column 7 - 1,1
Column 8 - 0,0
Column 9 - 2,2
Column 10 - 0,0
Column 11 - 0,0
Column 12 - null,null
Column 13 - INTERVAL,INTERVAL
Column 14 - 0,0
Column 15 - 0,0
Column 16 - 100,100
Column 17 - 12,12
Column 18 - null,null
Column 19 - 2,2

Printing Row 35 using getString(), getObject()
Column 1 - INTERVAL,INTERVAL
Column 2 - 113,113
Column 3 - 0,0
Column 4 - {INTERVAL ',{INTERVAL '
Column 5 - ' MINUTE TO SECOND},' MINUTE TO SECOND}
Column 6 - null,null
Column 7 - 1,1
Column 8 - 0,0
Column 9 - 2,2
Column 10 - 0,0
Column 11 - 0,0
Column 12 - null,null
Column 13 - INTERVAL,INTERVAL
Column 14 - 0,0
Column 15 - 0,0
Column 16 - 100,100
Column 17 - 13,13
Column 18 - null,null
Column 19 - 2,2

End of Data

getCatalogs()

Printing ResultSetMetaData ...
No. of Columns 1
Column 1 Data Type: VARCHAR Name: TABLE_CAT

Fetching rows...

Printing Row 1 using getString(), getObject()
Column 1 - TRAFODION,TRAFODION

End of Data

getTables()

Printing ResultSetMetaData ...
No. of Columns 10
Column 1 Data Type: VARCHAR Name: TABLE_CAT
Column 2 Data Type: VARCHAR Name: TABLE_SCHEM
Column 3 Data Type: VARCHAR Name: TABLE_NAME
Column 4 Data Type: VARCHAR Name: TABLE_TYPE
Column 5 Data Type: VARCHAR Name: REMARKS
Column 6 Data Type: VARCHAR Name: TYPE_CAT
Column 7 Data Type: VARCHAR Name: TYPE_SCHEM
Column 8 Data Type: VARCHAR Name: TYPE_NAME
Column 9 Data Type: VARCHAR Name: SELF_REFERENCING_COL_NAME
Column 10 Data Type: VARCHAR Name: REF_GENERATION

Fetching rows...

Printing Row 1 using getString(), getObject()
Column 1 - TRAFODION,TRAFODION
Column 2 - SEABASE,SEABASE
Column 3 - DBMETASAMPLE,DBMETASAMPLE
Column 4 - TABLE,TABLE
Column 5 - null,null
Column 6 - null,null
Column 7 - null,null
Column 8 - null,null
Column 9 - null,null
Column 10 - null,null

End of Data

getColumns()

Printing ResultSetMetaData ...
No. of Columns 18
Column 1 Data Type: VARCHAR Name: TABLE_CAT
Column 2 Data Type: VARCHAR Name: TABLE_SCHEM
Column 3 Data Type: VARCHAR Name: TABLE_NAME
Column 4 Data Type: VARCHAR Name: COLUMN_NAME
Column 5 Data Type: SMALLINT Name: DATA_TYPE
Column 6 Data Type: VARCHAR Name: TYPE_NAME
Column 7 Data Type: INTEGER Name: COLUMN_SIZE
Column 8 Data Type: INTEGER Name: BUFFER_LENGTH
Column 9 Data Type: SMALLINT Name: DECIMAL_DIGITS
Column 10 Data Type: SMALLINT Name: NUM_PREC_RADIX
Column 11 Data Type: SMALLINT Name: NULLABLE
Column 12 Data Type: VARCHAR Name: REMARKS
Column 13 Data Type: VARCHAR Name: COLUMN_DEF
Column 14 Data Type: SMALLINT Name: SQL_DATA_TYPE
Column 15 Data Type: SMALLINT Name: SQL_DATETIME_SUB
Column 16 Data Type: INTEGER Name: CHAR_OCTET_LENGTH
Column 17 Data Type: INTEGER Name: ORDINAL_POSITION
Column 18 Data Type: VARCHAR Name: IS_NULLABLE

Fetching rows...

Printing Row 1 using getString(), getObject()
Column 1 - TRAFODION,TRAFODION
Column 2 - SEABASE,SEABASE
Column 3 - DBMETASAMPLE,DBMETASAMPLE
Column 4 - C1,C1
Column 5 - 1,1
Column 6 - CHAR,CHAR
Column 7 - 20,20
Column 8 - 20,20
Column 9 - 0,0
Column 10 - null,null
Column 11 - 2,2
Column 12 - null,null
Column 13 - ,
Column 14 - 1,1
Column 15 - null,null
Column 16 - 20,20
Column 17 - 1,1
Column 18 - YES,YES

End of Data

getProcedures()

Printing ResultSetMetaData ...
No. of Columns 8
Column 1 Data Type: VARCHAR Name: PROCEDURE_CAT
Column 2 Data Type: VARCHAR Name: PROCEDURE_SCHEM
Column 3 Data Type: VARCHAR Name: PROCEDURE_NAME
Column 4 Data Type: SMALLINT Name: NUM_INPUT_PARAMS
Column 5 Data Type: SMALLINT Name: NUM_OUTPUT_PARAMS
Column 6 Data Type: SMALLINT Name: NUM_RESULT_SETS
Column 7 Data Type: VARCHAR Name: REMARKS
Column 8 Data Type: SMALLINT Name: PROCEDURE_TYPE

Fetching rows...

End of Data
=======================================================
