|
1 package com.daffodilwoods.daffodildb.server.serversystem;
2
3 import java.util.*;
4
5 import com.daffodilwoods.daffodildb.server.datadictionarysystem.*;
6 import com.daffodilwoods.daffodildb.server.datasystem.interfaces.*;
7 import com.daffodilwoods.daffodildb.server.datasystem.persistentsystem.*;
8 import com.daffodilwoods.database.general.*;
9 import com.daffodilwoods.database.resource.*;
10
11 public class SystemTableInformation {
12 public final static Integer  SQLIdentifierSize = new Integer (128);
13 public final static Integer characterDataSize = new Integer (1024);
14 public final static Integer serializeObjectDataSize = new Integer (12000);
15 public final static Integer viewDefinitionSize = new Integer (4096);
16 public final static Integer dtdIdentifierSize = new Integer (257);
17
18 public final static String transactionIndexTable = "default_index_transactionId";
19 public final static String sessionIndexTable = "default_index_sessionId";
20
21 public SystemTableInformation() {
22 }
23
24 public static Object [][] getTableStructure(QualifiedIdentifier tableName) throws DException {
25 if (tableName.equals(SystemTables.characterSets_TableName))
26 return characterSetsTableStructure();
27 else if (tableName.equals(SystemTables.collations_TableName))
28 return collationsTableStructure();
29 else if (tableName.equals(SystemTables.column_privileges_TableName))
30 return columnPrivilegesTableStructure();
31 if (tableName.equals(SystemTables.schema_TableName))
32 return schemaTableStructure();
33 else if (tableName.equals(SystemTables.tables_TableName))
34 return tablesTableStructure();
35 else if (tableName.equals(SystemTables.columns_TableName))
36 return columnsTableStructure();
37 else if (tableName.equals(SystemTables.dataTypeDescriptor_TableName))
38 return dataTypeTableStructure();
39 else if (tableName.equals(SystemTables.triggers_TableName))
40 return triggerTableStructure();
41 else if (tableName.equals(SystemTables.trigger_table_usage_TableName))
42 return triggerTableUsageTableStructure();
43 else if (tableName.equals(SystemTables.trigger_column_usage_TableName))
44 return triggerColumnUsageTableStructure();
45 else if (tableName.equals(SystemTables.triggered_update_columns_TableName))
46 return triggerUpdateColumnTableStructure();
47
48 else if (tableName.equals(SystemTables.table_constraints_TableName))
49 return tableConstraintsTableStructure();
50 else if (tableName.equals(SystemTables.referential_constraints_TableName))
51 return referentialConstraintsTableStructure();
52
53 else if (tableName.equals(SystemTables.check_constraints_TableName))
54 return checkConstraintsTableStructure();
55
56 else if (tableName.equals(SystemTables.key_column_usage_TableName))
57 return keyColumnUsageTableStructure();
58
59 else if (tableName.equals(SystemTables.check_column_usage_TableName))
60 return checkColumnUsageTableStructure();
61 else if (tableName.equals(SystemTables.check_table_usage_TableName))
62 return checkTableUsageTableStructure();
63
64 else if (tableName.equals(SystemTables.views_TableName))
65 return viewsTableStructure();
66 else if (tableName.equals(SystemTables.view_colum_usage_TableName))
67 return viewColumnUsageTableStructure();
68 else if (tableName.equals(SystemTables.view_table_usage_TableName))
69 return viewTableUsageTableStructure();
70 else if (tableName.equals(SystemTables.domains_TableName))
71 return domainTableStructure();
72 else if (tableName.equals(SystemTables.usage_privileges_TableName))
73 return usagePrivilegesTableStructure();
74 else if (tableName.equals(SystemTables.table_privileges_TableName))
75 return tablePrivilegesTableStructure();
76 else if (tableName.equals(SystemTables.domain_constraints_TableName))
77 return domain_constraintsTableStructure();
78
79 else if (tableName.equals(SystemTables.role_authorization_TableName))
80 return role_Authorization_DescriptorsTableStructure();
81 else if (tableName.equals(SystemTables.roles_TableName))
82 return rolesTableStructure();
83 else if (tableName.equals(SystemTables.routine_privileges_TableName))
84 return routine_PrivilegesTableStructure();
85 else if (tableName.equals(SystemTables.users_TableName))
86 return usersTableStructure();
87 else if (tableName.equals(SystemTables.sumtrigger_TableName))
88 return sumtriggerTableStructure();
89 else if (tableName.equals(SystemTables.transaction_TableName))
90 return transactionTableStructure();
91 else if (tableName.equals(SystemTables.parameters_TableName))
92 return parametersTableStructure();
93 else if (tableName.equals(SystemTables.routines_TableName))
94 return routinesTableStructure();
95 else if (tableName.equals(SystemTables.DATABASEINFO))
96 return databaseInfoTableStructure();
97 else if (tableName.equals(SystemTables.TABLEINFO))
98 return tableInfoTableStructure();
99 else if (tableName.equals(SystemTables.COLUMNINFO))
100 return columnInfoTableStructure();
101 else if (tableName.equals(SystemTables.CLUSTERINFO))
102 return clusterInfoTableStructure();
103 else if (tableName.equals(SystemTables.DATABASEINDEXINFO))
104 return databaseIndexInfoTableStructure();
105 else if (tableName.equals(SystemTables.DATABASEINDEXCOLUMNS))
106 return databaseIndexColumnsTableStructure();
107 else if (tableName.equals(SystemTables.INDEXINFO))
108 return indexInfoTableStructure();
109 else if (tableName.equals(SystemTables.INDEXCOLUMNS))
110 return indexColumnsTableStructure();
111 else if (tableName.equals(SystemTables.FULLTEXTINFO))
112 return fulltextindexTableStructure();
113 else if (tableName.equals(SystemTables.FULLTEXTCOLUMNINFO))
114 return fulltextindexTableStructure();
115 else if (tableName.equals(SystemTables.DATABASEFILEINFO))
116 return FileGeneratorInfoTableStructure();
117 else if (tableName.equals(SystemTables.FREESPACEINFO))
118 return FreeSpaceInfoTableStructure();
119 else if (tableName.equals(SystemTables.SCHEDULEINFO))
120 return scheduleInfoTableStructure();
121 else if (tableName.equals(SystemTables.DATABASEFULLTEXTINFO))
122 return databaseFullTextInfoTableStructure();
123 else if (tableName.equals(SystemTables.DIRTYDISTRIBUTEDTRANSACTIONS))
124 return dirtyDistributedTransactionsTableStructure();
125 else if (tableName.equals(SystemTables.DATABASEFULLTEXTCOLUMNINFO))
126 return databaseFullTextColumnInfoTableStructure();
127
128
129 else if (tableName.equals(SystemTables.user_defined_type_TableName))
130 return User_Defined_TypesTableStructure();
131 else if (tableName.equals(SystemTables.user_defined_type_privileges_TableName))
132 return User_Defined_Type_PrivilegesTableStructure();
133 else if (tableName.equals(SystemTables.method_specifications_TableName))
134 return method_SpecificationTableStructure();
135 else if (tableName.equals(SystemTables.method_specification_parameters_TableName))
136 return method_Specification_ParametersTableStructure();
137 else if (tableName.equals(SystemTables.transforms_TableName))
138 return transform_TableStructure();
139 else if (tableName.getName().equalsIgnoreCase(transactionIndexTable))
140 return TransactionIndexTableStructure();
141 else if (tableName.getName().startsWith(sessionIndexTable))
142 return SessionIndexTableStructure();
143 else if (tableName.getName().startsWith("default_index"))
144 return DefaultIndexTableStructure();
145 else if (tableName.equals(SystemTables.sequence_number_TableName))
146 return sequenceTableStructure();
147 else if (tableName.equals(SystemTables.routine_column_usage_TableName))
148 return routineColumnUsageTableStructure();
149 else if (tableName.equals(SystemTables.routine_table_usage_TableName))
150 return routineTableUsageTableStructure();
151
152 return null;
153 }
154
155 public static ArrayList getTableDetails() {
156 ArrayList list = new ArrayList();
157 list.add(new Object [] {SystemTables.INDEXINFO, indexInfoTableColumnInformation()});
158 list.add(new Object [] {SystemTables.dualSystemTable, dualSystemTableColumnInformation()});
159 list.add(new Object [] {SystemTables.INDEXCOLUMNS, indexColumnsTableColumnInformation()});
160 list.add(new Object [] {SystemTables.FULLTEXTINFO, fulltextindexTableColumnInformation()});
161 list.add(new Object [] {SystemTables.FULLTEXTCOLUMNINFO, indexColumnsTableColumnInformation()});
162 list.add(new Object [] {SystemTables.columns_TableName, columnsTableColumnInformation()});
163 list.add(new Object [] {SystemTables.dataTypeDescriptor_TableName, dataTypeTableColumnInformation()});
164 list.add(new Object [] {SystemTables.tables_TableName, tablesTableColumnInformation()});
165 list.add(new Object [] {SystemTables.characterSets_TableName, characterSetsTableColumnInformation()});
166 list.add(new Object [] {SystemTables.check_column_usage_TableName, checkColumnUsageTableColumnInformation()});
167 list.add(new Object [] {SystemTables.check_constraints_TableName, checkConstraintsTableColumnInformation()});
168 list.add(new Object [] {SystemTables.check_table_usage_TableName, checkTableUsageColumnInformation()});
169 list.add(new Object [] {SystemTables.collations_TableName, collationsTableColumnInformation()});
170 list.add(new Object [] {SystemTables.column_privileges_TableName, columnPrivilegesTableColumnInformation()});
171 list.add(new Object [] {SystemTables.domains_TableName, domainTableColumnInformation()});
172 list.add(new Object [] {SystemTables.domain_constraints_TableName, domain_constraintsTableColumnInformation()});
173 list.add(new Object [] {SystemTables.key_column_usage_TableName, keyColumnUsageTableColumnInformation()});
174 list.add(new Object [] {SystemTables.method_specification_parameters_TableName, method_Specification_ParametersTableColumnInformation()});
175 list.add(new Object [] {SystemTables.method_specifications_TableName, method_SpecificationTableColumnInformation()});
176 list.add(new Object [] {SystemTables.parameters_TableName, parametersTableColumnInformation()});
177 list.add(new Object [] {SystemTables.referential_constraints_TableName, referentialConstraintsTableColumnInformation()});
178 list.add(new Object [] {SystemTables.role_authorization_TableName, role_Authorization_DescriptorsTableColumnInformation()});
179 list.add(new Object [] {SystemTables.roles_TableName, rolesTableColumnInformation()});
180 list.add(new Object [] {SystemTables.routine_privileges_TableName, routine_PrivilegesTableColumnInformation()});
181 list.add(new Object [] {SystemTables.routines_TableName, routinesTableColumnInformation()});
182 list.add(new Object [] {SystemTables.schema_TableName, schemaTableColumnInformation()});
183 list.add(new Object [] {SystemTables.table_constraints_TableName, tableConstraintsTableColumnInformation()});
184 list.add(new Object [] {SystemTables.table_privileges_TableName, tablePrivilegesTableColumnInformation()});
185 list.add(new Object [] {SystemTables.transforms_TableName, transform_TableColumnInformation()});
186 list.add(new Object [] {SystemTables.trigger_column_usage_TableName, triggerColumnUsageTableColumnInformation()});
187 list.add(new Object [] {SystemTables.triggers_TableName, triggerTableColumnInformation()});
188 list.add(new Object [] {SystemTables.trigger_table_usage_TableName, triggerTableUsageColumnInformation()});
189 list.add(new Object [] {SystemTables.triggered_update_columns_TableName, triggerUpdateColumnColumnInformation()});
190 list.add(new Object [] {SystemTables.usage_privileges_TableName, usagePrivilegesTableColumnInformation()});
191 list.add(new Object [] {SystemTables.userDefinedTypes_TableName, User_Defined_TypesTableColumnInformation()});
192 list.add(new Object [] {SystemTables.user_defined_type_privileges_TableName, User_Defined_Type_PrivilegesTableColumnInformation()});
193 list.add(new Object [] {SystemTables.users_TableName, usersTableColumnInformation()});
194 list.add(new Object [] {SystemTables.view_colum_usage_TableName, viewColumnUsageTableColumnInformation()});
195 list.add(new Object [] {SystemTables.view_table_usage_TableName, viewTableUsageTableColumnInformation()});
196 list.add(new Object [] {SystemTables.views_TableName, viewsTableColumnInformation()});
197 list.add(new Object [] {SystemTables.sequence_number_TableName, sequenceTableColumnInformation()});
198 list.add(new Object [] {SystemTables.routine_column_usage_TableName, routineColumnUsageTableColumnInformation()});
199 list.add(new Object [] {SystemTables.routine_table_usage_TableName, routineTableUsageTableColumnInformation()});
200 return list;
201 }
202
203 public static ColumnInformation columnsTableColumnInformation() {
204 ColumnInformation ci = new ColumnInformation();
205 ci.setObjects(columnsTableStructure());
206 return ci;
207 }
208
209 public static Object [][] columnsTableStructure() {
210 return new Object [][] { {SystemFields.systemFields[SystemFields.rowId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (0)}
211 , {SystemFields.systemFields[SystemFields.transactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (1)}
212 , {SystemFields.systemFields[SystemFields.invalidTransactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (2)}
213 , {SystemFields.systemFields[SystemFields.sessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (3)}
214 , {SystemFields.systemFields[SystemFields.invalidSessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (4)}
215 , {"table_catalog", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (5)}
216 , {"table_schema", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (6)}
217 , {"table_name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (7)}
218 , {"column_name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (8)}
219 , {"ordinal_position", new Long (Datatype.INTEGER), new Integer (Datatype.INTSIZE), new Long (9)}
220 , {"dtd_identifier", new Long (Datatype.VARCHAR), dtdIdentifierSize, new Long (10)}
221 , {"domain_catalog", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (11)}
222 , {"domain_schema", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (12)}
223 , {"domain_name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (13)}
224 ,
225 {"column_default", new Long (Datatype.VARCHAR), characterDataSize, new Long (14)}
226 , {"is_Nullable", new Long (Datatype.VARCHAR), characterDataSize , new Long (15)}
227 , {"is_Self_Referencing", new Long (Datatype.VARCHAR), characterDataSize , new Long (16)}
228 , {"is_Autoincrement", new Long (Datatype.VARCHAR), characterDataSize , new Long (17)}
229 ,
230 };
231 }
232
233 public static ColumnInformation dataTypeTableColumnInformation() {
234 ColumnInformation ci = new ColumnInformation();
235 ci.setObjects(dataTypeTableStructure());
236 return ci;
237 }
238
239 public static Object [][] dataTypeTableStructure() {
240 return new Object [][] {
241
242 {SystemFields.systemFields[SystemFields.rowId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (0)}
243 , {SystemFields.systemFields[SystemFields.transactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (1)}
244 , {SystemFields.systemFields[SystemFields.invalidTransactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (2)}
245 , {SystemFields.systemFields[SystemFields.sessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (3)}
246 , {SystemFields.systemFields[SystemFields.invalidSessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (4)}
247 , {"object_catalog", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (5)}
248 , {"object_schema", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (6)}
249 , {"object_name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (7)}
250 , {"object_type", new Long (Datatype.VARCHAR), characterDataSize , new Long (8)}
251 , {"dtd_identifier", new Long (Datatype.VARCHAR), dtdIdentifierSize, new Long (9)}
252 , {"data_Type", new Long (Datatype.VARCHAR), characterDataSize , new Long (10)}
253 , {"character_maximum_length", new Long (Datatype.INTEGER), new Integer (Datatype.INTSIZE), new Long (11)}
254 , {"character_octet_length", new Long (Datatype.INTEGER), new Integer (Datatype.INTSIZE), new Long (12)}
255 , {"collation_catalog", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (13)}
256 , {"collation_schema", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (14)}
257 , {"collation_name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (15)}
258 , {"numeric_precision", new Long (Datatype.INTEGER), new Integer (Datatype.INTSIZE), new Long (16)}
259 , {"numeric_precision_radix", new Long (Datatype.INTEGER), new Integer (Datatype.INTSIZE), new Long (17)}
260 , {"numeric_scale", new Long (Datatype.INTEGER), new Integer (Datatype.INTSIZE), new Long (18)}
261 , {"datetime_precision", new Long (Datatype.INTEGER), new Integer (Datatype.INTSIZE), new Long (19)}
262 , {"interval_type", new Long (Datatype.VARCHAR), characterDataSize , new Long (20)}
263 , {"interval_precision", new Long (Datatype.INTEGER), new Integer (Datatype.INTSIZE), new Long (21)}
264 , {"user_defined_type_catalog", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (22)}
265 , {"user_defined_type_schema", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (23)}
266 , {"user_defined_type_name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (24)}
267 , {"scope_catalog", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (25)}
268 , {"scope_schema", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (26)}
269 , {"scope_name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (27)}
270 , {"maximum_cardinality", new Long (Datatype.INTEGER), new Integer (Datatype.INTSIZE), new Long (28)}
271 };
272 }
273
274 public static ColumnInformation tablesTableColumnInformation() {
275 ColumnInformation ci = new ColumnInformation();
276 ci.setObjects(tablesTableStructure());
277 return ci;
278 }
279
280 public static Object [][] tablesTableStructure() {
281 return new Object [][] { {SystemFields.systemFields[SystemFields.rowId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (0)}
282 , {SystemFields.systemFields[SystemFields.transactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (1)}
283 , {SystemFields.systemFields[SystemFields.invalidTransactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (2)}
284 , {SystemFields.systemFields[SystemFields.sessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (3)}
285 , {SystemFields.systemFields[SystemFields.invalidSessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (4)}
286 , {"table_catalog", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (5)}
287 , {"table_schema", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (6)}
288 , {"table_name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (7)}
289 , {"table_type", new Long (Datatype.VARCHAR), characterDataSize , new Long (8)}
290 , {"self_referencing_column_name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (9)}
291 , {"reference_generation", new Long (Datatype.VARCHAR), characterDataSize , new Long (10)}
292 , {"user_defined_type_catalog", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (11)}
293 , {"user_defined_type_schema", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (12)}
294 , {"user_defined_type_name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (13)}
295 , {"commitAction", new Long (Datatype.VARCHAR), characterDataSize, new Long (14)}
296 , {"country_code", new Long (Datatype.VARCHAR), characterDataSize, new Long (15)}
297 , {"language_code", new Long (Datatype.VARCHAR), characterDataSize, new Long (16)}
298 ,
299 };
300 }
301
302 static ColumnInformation characterSetsTableColumnInformation() {
303 ColumnInformation ci = new ColumnInformation();
304 ci.setObjects(characterSetsTableStructure());
305 return ci;
306 }
307
308 static Object [][] characterSetsTableStructure() {
309 return new Object [][] { {SystemFields.systemFields[SystemFields.rowId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (0)}
310 , {SystemFields.systemFields[SystemFields.transactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (1)}
311 , {SystemFields.systemFields[SystemFields.invalidTransactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (2)}
312 , {SystemFields.systemFields[SystemFields.sessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (3)}
313 , {SystemFields.systemFields[SystemFields.invalidSessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (4)}
314 ,
315
316 {"character_set_catalog", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (5)}
317 , {"character_set_schema", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (6)}
318 , {"character_set_name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (7)}
319 , {"form_of_use", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (8)}
320 , {"number_of_characters", new Long (Datatype.INTEGER), new Integer (Datatype.INTSIZE), new Long (9)}
321 , {"default_collate_catalog", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (10)}
322 , {"default_collate_schema", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (11)}
323 , {"default_collate_name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (12)}
324
325 };
326 }
327
328 static ColumnInformation checkColumnUsageTableColumnInformation() {
329 ColumnInformation ci = new ColumnInformation();
330 ci.setObjects(checkColumnUsageTableStructure());
331 return ci;
332 }
333
334 static Object [][] checkColumnUsageTableStructure() {
335 return new Object [][] { {SystemFields.systemFields[SystemFields.rowId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (0)}
336 , {SystemFields.systemFields[SystemFields.transactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (1)}
337 , {SystemFields.systemFields[SystemFields.invalidTransactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (2)}
338 , {SystemFields.systemFields[SystemFields.sessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (3)}
339 , {SystemFields.systemFields[SystemFields.invalidSessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (4)}
340 ,
341
342 {"constraint_catalog", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (5)}
343 , {"constraint_schema", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (6)}
344 , {"constraint_name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (7)}
345 , {"table_catalog", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (8)}
346 , {"table_schema", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (9)}
347 , {"table_name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (10)}
348 , {"column_name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (11)}
349 ,
350 };
351 }
352
353 static ColumnInformation checkConstraintsTableColumnInformation() {
354 ColumnInformation ci = new ColumnInformation();
355 ci.setObjects(checkConstraintsTableStructure());
356 return ci;
357 }
358
359 static Object [][] checkConstraintsTableStructure() {
360 return new Object [][] { {SystemFields.systemFields[SystemFields.rowId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (0)}
361 , {SystemFields.systemFields[SystemFields.transactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (1)}
362 , {SystemFields.systemFields[SystemFields.invalidTransactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (2)}
363 , {SystemFields.systemFields[SystemFields.sessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (3)}
364 , {SystemFields.systemFields[SystemFields.invalidSessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (4)}
365 ,
366
367 {"constraint_catalog", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (5)}
368 , {"constraint_schema", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (6)}
369 , {"constraint_name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (7)}
370 ,
371 {"check_clause", new Long (Datatype.VARCHAR), serializeObjectDataSize, new Long (8)}
372 ,
373 };
374 }
375
376 static ColumnInformation checkTableUsageColumnInformation() {
377 ColumnInformation ci = new ColumnInformation();
378 ci.setObjects(checkTableUsageTableStructure());
379 return ci;
380 }
381
382 static Object [][] checkTableUsageTableStructure() {
383 return new Object [][] { {SystemFields.systemFields[SystemFields.rowId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (0)}
384 , {SystemFields.systemFields[SystemFields.transactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (1)}
385 , {SystemFields.systemFields[SystemFields.invalidTransactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (2)}
386 , {SystemFields.systemFields[SystemFields.sessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (3)}
387 , {SystemFields.systemFields[SystemFields.invalidSessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (4)}
388 ,
389
390 {"constraint_catalog", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (5)}
391 , {"constraint_schema", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (6)}
392 , {"constraint_name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (7)}
393 , {"table_catalog", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (8)}
394 , {"table_schema", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (9)}
395 , {"table_name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (10)}
396 ,
397 };
398 }
399
400 static ColumnInformation clusterInfoTableColumnInformation() {
401 ColumnInformation ci = new ColumnInformation();
402 ci.setObjects(clusterInfoTableStructure());
403 return ci;
404 }
405
406 static Object [][] clusterInfoTableStructure() {
407 return new Object [][] {
408
409 {"StartAddress", new Integer (Datatype.INT), new Integer (Datatype.INTSIZE), new Integer (0)}
410 };
411 }
412
413 static ColumnInformation collationsTableColumnInformation() {
414 ColumnInformation ci = new ColumnInformation();
415 ci.setObjects(collationsTableStructure());
416 return ci;
417 }
418
419 static Object [][] collationsTableStructure() {
420 return new Object [][] { {SystemFields.systemFields[SystemFields.rowId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (0)}
421 , {SystemFields.systemFields[SystemFields.transactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (1)}
422 , {SystemFields.systemFields[SystemFields.invalidTransactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (2)}
423 , {SystemFields.systemFields[SystemFields.sessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (3)}
424 , {SystemFields.systemFields[SystemFields.invalidSessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (4)}
425 ,
426
427 {"collation_catalog", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (5)}
428 , {"collation_schema", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (6)}
429 , {"collation_name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (7)}
430 , {"character_set_catalog", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (8)}
431 , {"character_set_schema", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (9)}
432 , {"character_set_name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (10)}
433 , {"pad_attribute", new Long (Datatype.VARCHAR), characterDataSize , new Long (11)}
434 , {"collation_type", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (12)}
435 , {"collation_definition", new Long (Datatype.VARCHAR), characterDataSize, new Long (13)}
436 , {"collation_dictionary", new Long (Datatype.VARCHAR), characterDataSize, new Long (14)}
437 ,
438 };
439 }
440
441 static ColumnInformation columnPrivilegesTableColumnInformation() {
442 ColumnInformation ci = new ColumnInformation();
443 ci.setObjects(columnPrivilegesTableStructure());
444 return ci;
445 }
446
447 static Object [][] columnPrivilegesTableStructure() {
448 return new Object [][] { {SystemFields.systemFields[SystemFields.rowId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (0)}
449 , {SystemFields.systemFields[SystemFields.transactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (1)}
450 , {SystemFields.systemFields[SystemFields.invalidTransactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (2)}
451 , {SystemFields.systemFields[SystemFields.sessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (3)}
452 , {SystemFields.systemFields[SystemFields.invalidSessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (4)}
453 ,
454
455 {"grantor", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (5)}
456 , {"grantee", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (6)}
457 , {"table_catalog", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (7)}
458 , {"table_schema", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (8)}
459 , {"table_name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (9)}
460 , {"column_name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (10)}
461 , {"privilege_type", new Long (Datatype.VARCHAR), characterDataSize , new Long (11)}
462 , {"is_grantable", new Long (Datatype.VARCHAR), characterDataSize , new Long (12)}
463 ,
464 };
465 }
466
467 static ColumnInformation domain_constraintsTableColumnInformation() {
468 ColumnInformation ci = new ColumnInformation();
469 ci.setObjects(domain_constraintsTableStructure());
470 return ci;
471 }
472
473 static Object [][] domain_constraintsTableStructure() {
474 return new Object [][] { {SystemFields.systemFields[SystemFields.rowId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (0)}
475 , {SystemFields.systemFields[SystemFields.transactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (1)}
476 , {SystemFields.systemFields[SystemFields.invalidTransactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (2)}
477 , {SystemFields.systemFields[SystemFields.sessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (3)}
478 , {SystemFields.systemFields[SystemFields.invalidSessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (4)}
479 ,
480
481 {"constraint_catalog", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (5)}
482 , {"constraint_schema", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (6)}
483 , {"constraint_name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (7)}
484 , {"domain_catalog", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (8)}
485 , {"domain_schema", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (9)}
486 , {"domain_name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (10)}
487 , {"is_deferrable", new Long (Datatype.VARCHAR), characterDataSize , new Long (11)}
488 , {"initially_deferred", new Long (Datatype.VARCHAR), characterDataSize , new Long (12)}
489 ,
490 };
491 }
492
493 static ColumnInformation domainTableColumnInformation() {
494 ColumnInformation ci = new ColumnInformation();
495 ci.setObjects(domainTableStructure());
496 return ci;
497 }
498
499 static Object [][] domainTableStructure() {
500 return new Object [][] { {SystemFields.systemFields[SystemFields.rowId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (0)}
501 , {SystemFields.systemFields[SystemFields.transactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (1)}
502 , {SystemFields.systemFields[SystemFields.invalidTransactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (2)}
503 , {SystemFields.systemFields[SystemFields.sessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (3)}
504 , {SystemFields.systemFields[SystemFields.invalidSessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (4)}
505 ,
506
507 {"domain_catalog", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (5)}
508 , {"domain_schema", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (6)}
509 , {"domain_name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (7)}
510 , {"dtd_identifier", new Long (Datatype.VARCHAR), dtdIdentifierSize, new Long (8)}
511 , {"domain_default", new Long (Datatype.VARCHAR), characterDataSize, new Long (9)}
512 ,
513 };
514 }
515
516 static ColumnInformation EMPIndexTableStructure() {
517 ColumnInformation ci = new ColumnInformation();
518 ci.setObjects(
519 new Object [][] { {SystemFields.systemFields[SystemFields.rowId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (0)}
520 , {SystemFields.systemFields[SystemFields.transactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (1)}
521 , {SystemFields.systemFields[SystemFields.invalidTransactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (2)}
522 , {SystemFields.systemFields[SystemFields.sessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (3)}
523 , {SystemFields.systemFields[SystemFields.invalidSessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (4)}
524 ,
525
526 {"RecordClusterAddress", new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (5)}
527 , {"RecordNumber", new Long (Datatype.INTEGER), new Integer (Datatype.INTSIZE), new Long (6)}
528 , {"ClusterSize", new Long (Datatype.INTEGER), new Integer (Datatype.INTSIZE), new Long (7)}
529 , {"NextNodeAddress", new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (8)}
530 , {"NextNodeRecordNumber", new Long (Datatype.INTEGER), new Integer (Datatype.INTSIZE), new Long (9)}
531 , {"NextClusterSize", new Long (Datatype.INTEGER), new Integer (Datatype.INTSIZE), new Long (10)}
532 , {"recordId", new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (11)}
533 });
534 return ci;
535 }
536
537 static ColumnInformation EMPIndexTableStructure1() {
538 ColumnInformation ci = new ColumnInformation();
539 ci.setObjects(
540 new Object [][] { {SystemFields.systemFields[SystemFields.rowId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (0)}
541 , {SystemFields.systemFields[SystemFields.transactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (1)}
542 , {SystemFields.systemFields[SystemFields.invalidTransactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (2)}
543 , {SystemFields.systemFields[SystemFields.sessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (3)}
544 , {SystemFields.systemFields[SystemFields.invalidSessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (4)}
545 ,
546
547 {"RecordClusterAddress", new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (5)}
548 , {"RecordNumber", new Long (Datatype.INTEGER), new Integer (Datatype.INTSIZE), new Long (6)}
549 , {"ClusterSize", new Long (Datatype.INTEGER), new Integer (Datatype.INTSIZE), new Long (7)}
550 , {"NextNodeAddress", new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (8)}
551 , {"NextNodeRecordNumber", new Long (Datatype.INTEGER), new Integer (Datatype.INTSIZE), new Long (9)}
552 , {"NextClusterSize", new Long (Datatype.INTEGER), new Integer (Datatype.INTSIZE), new Long (10)}
553 , {"Name", new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (11)}
554 });
555 return ci;
556 }
557
558 static ColumnInformation EmpTableStructure() {
559 ColumnInformation ci = new ColumnInformation();
560 ci.setObjects(
561 new Object [][] { {SystemFields.systemFields[SystemFields.rowId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (0)}
562 , {SystemFields.systemFields[SystemFields.transactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (1)}
563 , {SystemFields.systemFields[SystemFields.invalidTransactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (2)}
564 , {SystemFields.systemFields[SystemFields.sessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (3)}
565 , {SystemFields.systemFields[SystemFields.invalidSessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (4)}
566 ,
567
568 {"RecordId", new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (5)}
569 ,
570 {"Name", new Long (Datatype.CHAR), new Integer (100), new Long (6)}
571 , {"Age", new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (7)}
572 , {"Sex", new Long (Datatype.CHAR), new Integer (100), new Long (8)}
573 , {"EmpNo", new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (9)}
574 });
575 return ci;
576 }
577
578 static ColumnInformation indexColumnsTableColumnInformation() {
579 ColumnInformation ci = new ColumnInformation();
580 ci.setObjects(indexColumnsTableStructure());
581 return ci;
582 }
583
584
597
598 static Object [][] indexColumnsTableStructure() {
599 return new Object [][] { {SystemFields.systemFields[SystemFields.rowId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (0)}
600 , {SystemFields.systemFields[SystemFields.transactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (1)}
601 , {SystemFields.systemFields[SystemFields.invalidTransactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (2)}
602 , {SystemFields.systemFields[SystemFields.sessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (3)}
603 , {SystemFields.systemFields[SystemFields.invalidSessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (4)}
604 ,
605
606 {"table_catalog", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (5)}
607 , {"table_schema", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (6)}
608 , {"table_name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (7)}
609 , {"IndexName", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (8)}
610 , {"column_name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (9)}
611 , {"OrderType", new Long (Datatype.BOOLEAN), new Integer (Datatype.BOOLEANSIZE), new Long (10)}
612 ,
613 {"ordinal_position", new Long (Datatype.INTEGER), new Integer (Datatype.INTSIZE), new Long (11)}
614
615 };
616 }
617
618 static Object [][] dualSystemTableStructure() {
619 return new Object [][] { {SystemFields.systemFields[SystemFields.rowId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (0)}
620 , {SystemFields.systemFields[SystemFields.transactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (1)}
621 , {SystemFields.systemFields[SystemFields.invalidTransactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (2)}
622 , {SystemFields.systemFields[SystemFields.sessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (3)}
623 , {SystemFields.systemFields[SystemFields.invalidSessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (4)}
624 , {"Column_Name", new Long (Datatype.INT), new Integer (Datatype.INTSIZE), new Long (5)}
625 };
626 }
627
628 static Object [][] fulltextindexTableStructure() {
629 return new Object [][] { {SystemFields.systemFields[SystemFields.rowId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (0)}
630 , {SystemFields.systemFields[SystemFields.transactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (1)}
631 , {SystemFields.systemFields[SystemFields.invalidTransactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (2)}
632 , {SystemFields.systemFields[SystemFields.sessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (3)}
633 , {SystemFields.systemFields[SystemFields.invalidSessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (4)}
634 , {"table_catalog", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (5)}
635 , {"table_schema", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (6)}
636 , {"table_name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (7)}
637 , {"IndexName", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (8)}
638 , {"FixedVariable", new Long (Datatype.BOOLEAN), new Integer (Datatype.BOOLEANSIZE), new Long (9)}
639 };
640 }
641
642 static ColumnInformation databaseIndexColumnsTableColumnInformation() {
643 ColumnInformation ci = new ColumnInformation();
644 ci.setObjects(databaseIndexColumnsTableStructure());
645 return ci;
646 }
647
648
661
662 static Object [][] databaseIndexColumnsTableStructure() {
663 return new Object [][] {
664
665 {"table_catalog", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (0)}
666 , {"table_schema", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (1)}
667 , {"table_name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (2)}
668 , {"IndexName", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (3)}
669 , {"column_name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (4)}
670 , {"OrderType", new Long (Datatype.BOOLEAN), new Integer (Datatype.BOOLEANSIZE), new Long (5)}
671 , {"ColumnIndex", new Long (Datatype.INTEGER), new Integer (Datatype.INTSIZE), new Long (6)}
672 , {"ordinal_position", new Long (Datatype.INTEGER), new Integer (Datatype.INTSIZE), new Long (7)}
673
674 };
675 }
676
677 static ColumnInformation databaseIndexInfoTableColumnInformation() {
678 ColumnInformation ci = new ColumnInformation();
679 ci.setObjects(databaseIndexInfoTableStructure());
680 return ci;
681 }
682
683 static Object [][] databaseIndexInfoTableStructure() {
684 return new Object [][] {
685
686
692 {"table_catalog", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (0)}
693 , {"table_schema", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (1)}
694 , {"table_name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (2)}
695 , {"IndexName", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (3)}
696 , {"ControlClusterAddress", new Long (Datatype.INTEGER), new Integer (Datatype.INTSIZE), new Long (4)}
697 , {"FixedVariable", new Long (Datatype.BOOLEAN), new Integer (Datatype.BOOLEANSIZE), new Long (5)}
698
710 };
711 }
712
713 static ColumnInformation indexInfoTableColumnInformation() {
714 ColumnInformation ci = new ColumnInformation();
715 ci.setObjects(indexInfoTableStructure());
716 return ci;
717 }
718
719 static ColumnInformation dualSystemTableColumnInformation() {
720 ColumnInformation ci = new ColumnInformation();
721 ci.setObjects(dualSystemTableStructure());
722 return ci;
723 }
724
725 static ColumnInformation fulltextindexTableColumnInformation() {
726 ColumnInformation ci = new ColumnInformation();
727 ci.setObjects(fulltextindexTableStructure());
728 return ci;
729 }
730
731 static Object [][] indexInfoTableStructure() {
732 return new Object [][] {
733
734 {SystemFields.systemFields[SystemFields.rowId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (0)}
735 , {SystemFields.systemFields[SystemFields.transactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (1)}
736 , {SystemFields.systemFields[SystemFields.invalidTransactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (2)}
737 , {SystemFields.systemFields[SystemFields.sessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (3)}
738 , {SystemFields.systemFields[SystemFields.invalidSessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (4)}
739 ,
740
741 {"table_catalog", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (5)}
742 , {"table_schema", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (6)}
743 , {"table_name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (7)}
744 , {"IndexName", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (8)}
745 , {"IndexTableName", new Long (Datatype.VARCHAR), new Integer (256), new Long (9)}
746 , {"NumberOfRecords", new Long (Datatype.INTEGER), new Integer (Datatype.INTSIZE), new Long (10)}
747 , {"RootNodeAddress", new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (11)}
748 , {"RootClusterSize", new Long (Datatype.INTEGER), new Integer (Datatype.INTSIZE), new Long (12)}
749 , {"RootRecordNumber", new Long (Datatype.INTEGER), new Integer (Datatype.INTSIZE), new Long (13)}
750 , {"FixedVariable", new Long (Datatype.BOOLEAN), new Integer (Datatype.BOOLEANSIZE), new Long (14)}
751 , {"is_system_generated", new Long (Datatype.BOOLEAN), new Integer (Datatype.BOOLEANSIZE), new Long (15)}
752
764 };
765 }
766
767 static ColumnInformation IndexTableStructure() {
768 ColumnInformation ci = new ColumnInformation();
769 ci.setObjects(
770 new Object [][] { {SystemFields.systemFields[SystemFields.rowId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (0)}
771 , {SystemFields.systemFields[SystemFields.transactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (1)}
772 , {SystemFields.systemFields[SystemFields.invalidTransactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (2)}
773 , {SystemFields.systemFields[SystemFields.sessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (3)}
774 , {SystemFields.systemFields[SystemFields.invalidSessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (4)}
775 ,
776
777 {"RecordClusterAddress", new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (5)}
778 , {"RecordNumber", new Long (Datatype.INTEGER), new Integer (Datatype.INTSIZE), new Long (6)}
779 , {"ClusterSize", new Long (Datatype.INTEGER), new Integer (Datatype.INTSIZE), new Long (7)}
780 , {"NextNodeAddress", new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (8)}
781 , {"NextNodeRecordNumber", new Long (Datatype.INTEGER), new Integer (Datatype.INTSIZE), new Long (9)}
782 , {"NextClusterSize", new Long (Datatype.INTEGER), new Integer (Datatype.INTSIZE), new Long (10)}
783 ,
784 });
785 return ci;
786 }
787
788 static ColumnInformation keyColumnUsageTableColumnInformation() {
789 ColumnInformation ci = new ColumnInformation();
790 ci.setObjects(keyColumnUsageTableStructure());
791 return ci;
792 }
793
794 static Object [][] keyColumnUsageTableStructure() {
795 return new Object [][] { {SystemFields.systemFields[SystemFields.rowId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (0)}
796 , {SystemFields.systemFields[SystemFields.transactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (1)}
797 , {SystemFields.systemFields[SystemFields.invalidTransactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (2)}
798 , {SystemFields.systemFields[SystemFields.sessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (3)}
799 , {SystemFields.systemFields[SystemFields.invalidSessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (4)}
800 ,
801
802 {"constraint_catalog", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (5)}
803 , {"constraint_schema", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (6)}
804 , {"constraint_name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (7)}
805 , {"table_catalog", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (8)}
806 , {"table_schema", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (9)}
807 , {"table_name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (10)}
808 , {"column_name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (11)}
809 , {"ordinal_position", new Long (Datatype.INTEGER), new Integer (Datatype.INTSIZE), new Long (12)}
810 };
811 }
812
813 static ColumnInformation method_Specification_ParametersTableColumnInformation() {
814 ColumnInformation ci = new ColumnInformation();
815 ci.setObjects(method_Specification_ParametersTableStructure());
816 return ci;
817 }
818
819 static Object [][] method_Specification_ParametersTableStructure() {
820 return new Object [][] {
821
822 {SystemFields.systemFields[SystemFields.rowId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (0)}
823 , {SystemFields.systemFields[SystemFields.transactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (1)}
824 , {SystemFields.systemFields[SystemFields.invalidTransactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (2)}
825 , {SystemFields.systemFields[SystemFields.sessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (3)}
826 , {SystemFields.systemFields[SystemFields.invalidSessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (4)}
827 ,
828
829 {"Specific_Catalog", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (5)}
830 , {"Specific_Schema", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (6)}
831 , {"Specific_Name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (7)}
832 , {"Method_Catalog", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (8)}
833 , {"Method_Schema", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (9)}
834 , {"Method_Name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (10)}
835 , {"Method_Specification_Identifier", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (11)}
836 , {"Ordinal_Position", new Long (Datatype.INTEGER), new Integer (Datatype.INTSIZE), new Long (12)}
837 , {"DTD_Identifier", new Long (Datatype.VARCHAR), dtdIdentifierSize, new Long (13)}
838 , {"Parameter_Mode", new Long (Datatype.VARCHAR), characterDataSize, new Long (14)}
839 , {"Is_Result", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (15)}
840 , {"As_Locator", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (16)}
841 , {"Parameter_Name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (17)}
842 , {"From_SQL_Specific_Catalog", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (18)}
843 , {"From_SQL_Specific_Schema", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (19)}
844 , {"From_SQL_Specific_Name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (20)}
845 };
846 }
847
848 static ColumnInformation method_SpecificationTableColumnInformation() {
849 ColumnInformation ci = new ColumnInformation();
850 ci.setObjects(method_SpecificationTableStructure());
851 return ci;
852 }
853
854 static Object [][] method_SpecificationTableStructure() {
855 return new Object [][] {
856
857 {SystemFields.systemFields[SystemFields.rowId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (0)}
858 , {SystemFields.systemFields[SystemFields.transactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (1)}
859 , {SystemFields.systemFields[SystemFields.invalidTransactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (2)}
860 , {SystemFields.systemFields[SystemFields.sessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (3)}
861 , {SystemFields.systemFields[SystemFields.invalidSessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (4)}
862 ,
863
864 {"Specific_Catalog", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (5)}
865 , {"Specific_Schema", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (6)}
866 , {"Specific_Name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (7)}
867 , {"User_Defined_Type_Catalog", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (8)}
868 , {"User_Defined_Type_Schema", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (9)}
869 , {"User_Defined_Type_Name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (10)}
870 , {"Method_Name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (11)}
871 , {"Is_Static", new Long (Datatype.VARCHAR), characterDataSize, new Long (12)}
872 , {"Is_Overriding", new Long (Datatype.VARCHAR), characterDataSize, new Long (13)}
873 , {"Method_Language", new Long (Datatype.VARCHAR), characterDataSize, new Long (14)}
874 , {"Parameter_Style", new Long (Datatype.VARCHAR), characterDataSize, new Long (15)}
875 , {"DTD_Identifier", new Long (Datatype.VARCHAR), dtdIdentifierSize, new Long (16)}
876 , {"Is_Deterministic", new Long (Datatype.VARCHAR), characterDataSize, new Long (17)}
877 , {"SQL_Data_Access", new Long (Datatype.VARCHAR), characterDataSize, new Long (18)}
878 , {"Is_Null_Call", new Long (Datatype.VARCHAR), characterDataSize, new Long (19)}
879 , {"To_SQL_Specific_Catalog", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (20)}
880 , {"To_SQL_Specific_Schema", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (21)}
881 , {"To_SQL_Specific_Name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (22)}
882 , {"As_Locator", new Long (Datatype.VARCHAR), characterDataSize, new Long (23)}
883 , {"created", new Long (Datatype.TIMESTAMP), new Integer (Datatype.TIMESTAMPSIZE), new Long (24)}
884 , {"Last_Altered", new Long (Datatype.TIMESTAMP), new Integer (Datatype.TIMESTAMPSIZE), new Long (25)}
885 };
886 }
887
888 static ColumnInformation parametersTableColumnInformation() {
889 ColumnInformation ci = new ColumnInformation();
890 ci.setObjects(parametersTableStructure());
891 return ci;
892 }
893
894 static Object [][] parametersTableStructure() {
895 return new Object [][] { {SystemFields.systemFields[SystemFields.rowId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (0)}
896 , {SystemFields.systemFields[SystemFields.transactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (1)}
897 , {SystemFields.systemFields[SystemFields.invalidTransactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (2)}
898 , {SystemFields.systemFields[SystemFields.sessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (3)}
899 , {SystemFields.systemFields[SystemFields.invalidSessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (4)}
900 ,
901
902 {"specific_catalog", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (5)}
903 , {"specific_schema", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (6)}
904 , {"specific_name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (7)}
905 , {"ordinal_position", new Long (Datatype.INTEGER), new Integer (Datatype.INTSIZE), new Long (8)}
906 , {"dtd_identifier", new Long (Datatype.VARCHAR), dtdIdentifierSize, new Long (9)}
907 , {"parameter_mode", new Long (Datatype.VARCHAR), characterDataSize, new Long (10)}
908 , {"is_result", new Long (Datatype.VARCHAR), characterDataSize, new Long (11)}
909 , {"as_locator", new Long (Datatype.VARCHAR), characterDataSize, new Long (12)}
910 , {"parameter_name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (13)}
911 , {"from_sql_specific_catalog", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (14)}
912 , {"from_sql_specific_schema", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (15)}
913 , {"from_sql_specific_name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (16)}
914 , {"to_sql_specific_catalog", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (17)}
915 , {"to_sql_specific_schema", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (18)}
916 , {"to_sql_specific_name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (19)}
917 };
918 }
919
920 static ColumnInformation powerFailureTableStructure() {
921 ColumnInformation ci = new ColumnInformation();
922 ci.setObjects(
923 new Object [][] { {SystemFields.systemFields[SystemFields.rowId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (0)}
924 , {SystemFields.systemFields[SystemFields.transactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (1)}
925 , {SystemFields.systemFields[SystemFields.invalidTransactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (2)}
926 , {SystemFields.systemFields[SystemFields.sessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (3)}
927 , {SystemFields.systemFields[SystemFields.invalidSessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (4)}
928 ,
929
930 {"StartAddress", new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (5)}
931 , {"EndAddress", new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (6)}
932 , {"ClusterData", new Long (Datatype.CHARACTER), new Integer ( -1), new Long (7)}
933 });
934 return ci;
935 }
936
937 static ColumnInformation referentialConstraintsTableColumnInformation() {
938 ColumnInformation ci = new ColumnInformation();
939 ci.setObjects(referentialConstraintsTableStructure());
940 return ci;
941 }
942
943 static Object [][] referentialConstraintsTableStructure() {
944 return new Object [][] {
945
946 {SystemFields.systemFields[SystemFields.rowId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (0)}
947 , {SystemFields.systemFields[SystemFields.transactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (1)}
948 , {SystemFields.systemFields[SystemFields.invalidTransactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (2)}
949 , {SystemFields.systemFields[SystemFields.sessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (3)}
950 , {SystemFields.systemFields[SystemFields.invalidSessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (4)}
951 ,
952
953 {"constraint_catalog", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (5)}
954 , {"constraint_schema", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (6)}
955 , {"constraint_name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (7)}
956 , {"unique_constraint_catalog", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (8)}
957 , {"unique_constraint_schema", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (9)}
958 , {"unique_constraint_name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (10)}
959 , {"match_option", new Long (Datatype.VARCHAR), characterDataSize , new Long (11)}
960 , {"update_rule", new Long (Datatype.VARCHAR), characterDataSize , new Long (12)}
961 , {"delete_rule", new Long (Datatype.VARCHAR), characterDataSize , new Long (13)}
962 ,
963 };
964 }
965
966 static ColumnInformation role_Authorization_DescriptorsTableColumnInformation() {
967 ColumnInformation ci = new ColumnInformation();
968 ci.setObjects(role_Authorization_DescriptorsTableStructure());
969 return ci;
970 }
971
972 static Object [][] role_Authorization_DescriptorsTableStructure() {
973 return new Object [][] {
974
975 {SystemFields.systemFields[SystemFields.rowId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (0)}
976 , {SystemFields.systemFields[SystemFields.transactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (1)}
977 , {SystemFields.systemFields[SystemFields.invalidTransactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (2)}
978 , {SystemFields.systemFields[SystemFields.sessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (3)}
979 , {SystemFields.systemFields[SystemFields.invalidSessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (4)}
980 ,
981
982 {"role_name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (5)}
983 , {"grantee", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (6)}
984 , {"grantor", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (7)}
985 , {"is_grantable", new Long (Datatype.VARCHAR), characterDataSize , new Long (8)}
986 ,
987 };
988 }
989
990 static ColumnInformation rolesTableColumnInformation() {
991 ColumnInformation ci = new ColumnInformation();
992 ci.setObjects(rolesTableStructure());
993 return ci;
994 }
995
996 static Object [][] rolesTableStructure() {
997 return new Object [][] { {SystemFields.systemFields[SystemFields.rowId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (0)}
998 , {SystemFields.systemFields[SystemFields.transactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (1)}
999 , {SystemFields.systemFields[SystemFields.invalidTransactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (2)}
1000 , {SystemFields.systemFields[SystemFields.sessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (3)}
1001 , {SystemFields.systemFields[SystemFields.invalidSessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (4)}
1002 ,
1003
1004 {"role_name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (5)}
1005 ,
1006 };
1007 }
1008
1009 static ColumnInformation routine_PrivilegesTableColumnInformation() {
1010 ColumnInformation ci = new ColumnInformation();
1011 ci.setObjects(routine_PrivilegesTableStructure());
1012 return ci;
1013 }
1014
1015 static Object [][] routine_PrivilegesTableStructure() {
1016 return new Object [][] {
1017
1018 {SystemFields.systemFields[SystemFields.rowId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (0)}
1019 , {SystemFields.systemFields[SystemFields.transactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (1)}
1020 , {SystemFields.systemFields[SystemFields.invalidTransactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (2)}
1021 , {SystemFields.systemFields[SystemFields.sessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (3)}
1022 , {SystemFields.systemFields[SystemFields.invalidSessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (4)}
1023 ,
1024
1025 {"grantor", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (5)}
1026 , {"grantee", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (6)}
1027 , {"specific_catalog", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (7)}
1028 , {"specific_schema", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (8)}
1029 , {"specific_name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (9)}
1030 , {"privilege_type", new Long (Datatype.VARCHAR), characterDataSize , new Long (10)}
1031 , {"is_grantable", new Long (Datatype.VARCHAR), characterDataSize , new Long (11)}
1032 ,
1033 };
1034 }
1035
1036 static ColumnInformation routinesTableColumnInformation() {
1037 ColumnInformation ci = new ColumnInformation();
1038 ci.setObjects(routinesTableStructure());
1039 return ci;
1040 }
1041
1042 static Object [][] routinesTableStructure() {
1043 return new Object [][] { {SystemFields.systemFields[SystemFields.rowId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (0)}
1044 , {SystemFields.systemFields[SystemFields.transactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (1)}
1045 , {SystemFields.systemFields[SystemFields.invalidTransactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (2)}
1046 , {SystemFields.systemFields[SystemFields.sessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (3)}
1047 , {SystemFields.systemFields[SystemFields.invalidSessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (4)}
1048 ,
1049
1050 {"specific_catalog", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (5)}
1051 , {"specific_schema", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (6)}
1052 , {"specific_name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (7)}
1053 , {"routine_catalog", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (8)}
1054 , {"routine_schema", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (9)}
1055 , {"routine_name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (10)}
1056 , {"module_catalog", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (11)}
1057 , {"module_schema", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (12)}
1058 , {"module_name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (13)}
1059 , {"user_defined_type_catalog", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (14)}
1060 , {"user_defined_type_schema", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (15)}
1061 , {"user_defined_type_name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (16)}
1062 , {"routine_type", new Long (Datatype.VARCHAR), characterDataSize, new Long (17)}
1063 , {"dtd_identifier", new Long (Datatype.VARCHAR), dtdIdentifierSize, new Long (18)}
1064 , {"routine_body", new Long (Datatype.VARCHAR), characterDataSize, new Long (19)}
1065 ,
1066 {"routine_definition", new Long (Datatype.VARCHAR), serializeObjectDataSize, new Long (20)}
1067 , {"external_name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (21)}
1068 , {"external_language", new Long (Datatype.VARCHAR), characterDataSize, new Long (22)}
1069 , {"parameter_style", new Long (Datatype.VARCHAR), characterDataSize, new Long (23)}
1070 , {"is_deterministic", new Long (Datatype.VARCHAR), characterDataSize, new Long (24)}
1071 , {"sql_data_access", new Long (Datatype.VARCHAR), characterDataSize, new Long (25)}
1072 , {"is_null_call", new Long (Datatype.VARCHAR), characterDataSize, new Long (26)}
1073 , {"sql_path", new Long (Datatype.VARCHAR), characterDataSize, new Long (27)}
1074 , {"schema_level_routine", new Long (Datatype.VARCHAR), characterDataSize, new Long (28)}
1075 , {"max_dynamic_result_sets", new Long (Datatype.INTEGER), new Integer (Datatype.INTSIZE), new Long (29)}
1076 , {"is_user_defined_cast", new Long (Datatype.VARCHAR), characterDataSize, new Long (30)}
1077 , {"is_implicitly_invocable", new Long (Datatype.VARCHAR), characterDataSize, new Long (31)}
1078 , {"security_type", new Long (Datatype.VARCHAR), characterDataSize, new Long (32)}
1079 , {"to_sql_specific_catalog", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (33)}
1080 , {"to_sql_specific_schema", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (34)}
1081 , {"to_sql_specific_name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (35)}
1082 , {"as_locator", new Long (Datatype.VARCHAR), characterDataSize, new Long (36)}
1083 , {"created", new Long (Datatype.TIMESTAMP), new Integer (Datatype.TIMESTAMPSIZE), new Long (37)}
1084 , {"last_altered", new Long (Datatype.TIMESTAMP), new Integer (Datatype.TIMESTAMPSIZE), new Long (38)}
1085 };
1086 }
1087
1088 static ColumnInformation schemaTableColumnInformation() {
1089 ColumnInformation ci = new ColumnInformation();
1090 ci.setObjects(schemaTableStructure());
1091 return ci;
1092 }
1093
1094 static Object [][] schemaTableStructure() {
1095 return new Object [][] {
1096
1097 {SystemFields.systemFields[SystemFields.rowId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (0)}
1098 , {SystemFields.systemFields[SystemFields.transactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (1)}
1099 , {SystemFields.systemFields[SystemFields.invalidTransactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (2)}
1100 , {SystemFields.systemFields[SystemFields.sessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (3)}
1101 , {SystemFields.systemFields[SystemFields.invalidSessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (4)}
1102 ,
1103
1104 {"catalog_name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (5)}
1105 , {"schema_name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (6)}
1106 , {"schema_owner", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (7)}
1107 , {"default_character_set_catalog", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (8)}
1108 , {"default_character_set_schema", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (9)}
1109 , {"default_character_set_name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (10)}
1110 , {"sql_path", new Long (Datatype.VARCHAR), characterDataSize, new Long (11)}
1111 ,
1112 };
1113 }
1114
1115 static ColumnInformation sumtriggerTableColumnInformation() {
1116 ColumnInformation ci = new ColumnInformation();
1117 ci.setObjects(sumtriggerTableStructure());
1118 return ci;
1119 }
1120
1121 static Object [][] sumtriggerTableStructure() {
1122 return new Object [][] { {SystemFields.systemFields[SystemFields.rowId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (0)}
1123 , {SystemFields.systemFields[SystemFields.transactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (1)}
1124 , {SystemFields.systemFields[SystemFields.invalidTransactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (2)}
1125 , {SystemFields.systemFields[SystemFields.sessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (3)}
1126 , {SystemFields.systemFields[SystemFields.invalidSessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (4)}
1127 ,
1128
1129 {"table_catalog", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (5)}
1130 , {"table_schema", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (6)}
1131 , {"table_name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (7)}
1132 , {"column_name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (8)}
1133 , {"targetfield", new Long (Datatype.VARCHAR), characterDataSize, new Long (9)}
1134 , {"trigger_event", new Long (Datatype.VARCHAR), characterDataSize, new Long (10)}
1135 , {"user_session", new Long (Datatype.VARCHAR), characterDataSize, new Long (11)}
1136 , {"violatevalidityevent", new Long (Datatype.VARCHAR), characterDataSize, new Long (12)}
1137 , {"sum_relation", new Long (Datatype.VARCHAR), characterDataSize, new Long (13)}
1138 ,
1139 };
1140 }
1141
1142 static ColumnInformation tableConstraintsTableColumnInformation() {
1143 ColumnInformation ci = new ColumnInformation();
1144 ci.setObjects(tableConstraintsTableStructure());
1145 return ci;
1146 }
1147
1148 static Object [][] tableConstraintsTableStructure() {
1149 return new Object [][] { {SystemFields.systemFields[SystemFields.rowId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (0)}
1150 , {SystemFields.systemFields[SystemFields.transactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (1)}
1151 , {SystemFields.systemFields[SystemFields.invalidTransactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (2)}
1152 , {SystemFields.systemFields[SystemFields.sessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (3)}
1153 , {SystemFields.systemFields[SystemFields.invalidSessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (4)}
1154 ,
1155
1156 {"constraint_catalog", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (5)}
1157 , {"constraint_schema", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (6)}
1158 , {"constraint_name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (7)}
1159 , {"constraint_type", new Long (Datatype.VARCHAR), characterDataSize , new Long (8)}
1160 , {"table_catalog", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (9)}
1161 , {"table_schema", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (10)}
1162 , {"table_name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (11)}
1163 , {"is_deferrable", new Long (Datatype.VARCHAR), characterDataSize , new Long (12)}
1164 , {"initially_deferred", new Long (Datatype.VARCHAR), characterDataSize , new Long (13)}
1165 ,
1166 };
1167 }
1168
1169 static ColumnInformation tableInfoTableColumnInformation() {
1170 ColumnInformation ci = new ColumnInformation();
1171 ci.setObjects(tableInfoTableStructure());
1172 return ci;
1173 }
1174
1175 static Object [][] tableInfoTableStructure() {
1176 return new Object [][] {
1177 {"CatalogName", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (0)}
1178 , {"SchemaName", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (1)}
1179 , {"TableName", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (2)}
1180 , {"StartAddress", new Long (Datatype.INTEGER), new Integer (Datatype.INTSIZE), new Long (3)}
1181 ,
1182 {"Language", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (4)}
1183 , {"Country", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (5)}
1184 };
1185 }
1186
1187 static ColumnInformation tablePrivilegesTableColumnInformation() {
1188 ColumnInformation ci = new ColumnInformation();
1189 ci.setObjects(tablePrivilegesTableStructure());
1190 return ci;
1191 }
1192
1193 static Object [][] tablePrivilegesTableStructure() {
1194 return new Object [][] {
1195
1196 {SystemFields.systemFields[SystemFields.rowId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (0)}
1197 , {SystemFields.systemFields[SystemFields.transactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (1)}
1198 , {SystemFields.systemFields[SystemFields.invalidTransactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (2)}
1199 , {SystemFields.systemFields[SystemFields.sessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (3)}
1200 , {SystemFields.systemFields[SystemFields.invalidSessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (4)}
1201 ,
1202
1203 {"grantor", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (5)}
1204 , {"grantee", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (6)}
1205 , {"table_catalog", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (7)}
1206 , {"table_schema", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (8)}
1207 , {"table_name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (9)}
1208 , {"privilege_type", new Long (Datatype.VARCHAR), characterDataSize , new Long (10)}
1209 , {"is_grantable", new Long (Datatype.VARCHAR), characterDataSize , new Long (11)}
1210 , {"with_hierarchy", new Long (Datatype.VARCHAR), characterDataSize , new Long (12)}
1211 ,
1212 };
1213 }
1214
1215 static ColumnInformation testTableStructure() {
1216 ColumnInformation ci = new ColumnInformation();
1217 ci.setObjects(
1218 new Object [][] { {SystemFields.systemFields[SystemFields.rowId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (0)}
1219 , {SystemFields.systemFields[SystemFields.transactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (1)}
1220 , {SystemFields.systemFields[SystemFields.invalidTransactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (2)}
1221 , {SystemFields.systemFields[SystemFields.sessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (3)}
1222 , {SystemFields.systemFields[SystemFields.invalidSessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (4)}
1223 ,
1224
1225 {"col_CHAR", new Long (Datatype.CHAR), new Integer (1), new Long (5)}
1226 , {"col_VARCHAR", new Long (Datatype.VARCHAR), new Integer (50), new Long (6)}
1227 , {"col_CHARACTERVARYING", new Long (Datatype.CHARACTERVARYING), new Integer (50), new Long (7)}
1228 , {"col_CHARVARYING", new Long (Datatype.CHARVARYING), new Integer (1), new Long (8)}
1229 , {"col_CHARACTER", new Long (Datatype.CHARACTER), new Integer (1), new Long (9)}
1230 , {"col_INT", new Long (Datatype.INT), new Integer (Datatype.INTSIZE), new Long (10)}
1231 , {"col_INTEGER", new Long (Datatype.INTEGER), new Integer (Datatype.INTSIZE), new Long (11)}
1232 , {"col_LONG", new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (12)}
1233 , {"col_SMALLINT", new Long (Datatype.SMALLINT), new Integer (Datatype.SHORTSIZE), new Long (13)}
1234 , {"col_SHORT", new Long (Datatype.SHORT), new Integer (Datatype.SHORTSIZE), new Long (14)}
1235 , {"col_BOOLEAN", new Long (Datatype.BOOLEAN), new Integer (Datatype.BOOLEANSIZE), new Long (15)}
1236 , {"col_REAL", new Long (Datatype.REAL), new Integer (Datatype.REALSIZE), new Long (16)}
1237 , {"col_FLOAT", new Long (Datatype.FLOAT), new Integer (Datatype.FLOATSIZE), new Long (17)}
1238 , {"col_DOUBLEPRECISION", new Long (Datatype.DOUBLEPRECISION), new Integer (Datatype.DOUBLESIZE), new Long (18)}
1239 , {"col_DOUBLE", new Long (Datatype.DOUBLE), new Integer (Datatype.DOUBLESIZE), new Long (19)}
1240 , {"col_DATE", new Long (Datatype.DATE), new Integer (Datatype.DATESIZE), new Long (20)}
1241 , {"col_NUMERIC", new Long (Datatype.NUMERIC), new Integer (Datatype.LONGSIZE), new Long (21)}
1242 , {"col_DECIMAL", new Long (Datatype.DECIMAL), new Integer (Datatype.LONGSIZE), new Long (22)}
1243 , {"col_DEC", new Long (Datatype.DEC), new Integer (Datatype.LONGSIZE), new Long (23)}
1244 , {"col_BIGDECIMAL", new Long (Datatype.BIGDECIMAL), new Integer (Datatype.DOUBLESIZE), new Long (24)}
1245 , {"col_TIME", new Long (Datatype.TIME), new Integer (Datatype.TIMESIZE), new Long (25)}
1246 , {"col_TIMESTAMP", new Long (Datatype.TIMESTAMP), new Integer (Datatype.TIMESTAMPSIZE), new Long (26)}
1247 , {"col_BYTE", new Long (Datatype.BYTE), new Integer (Datatype.BYTESIZE), new Long (27)}
1248 , {"col_BIT", new Long (Datatype.BIT), new Integer (20), new Long (28)}
1249 , {"col_BITVARYING", new Long (Datatype.BITVARYING), new Integer (20), new Long (29)}
1250 , {"col_BLOB ", new Long (Datatype.BLOB), new Integer (8), new Long (30)}
1251 , {"col_CLOB", new Long (Datatype.CLOB), new Integer (8), new Long (31)}
1252 });
1253 return ci;
1254 }
1255
1256 static ColumnInformation transactionTableColumnInformation() {
1257 ColumnInformation ci = new ColumnInformation();
1258 ci.setObjects(transactionTableStructure());
1259 return ci;
1260 }
1261
1262 static Object [][] transactionTableStructure() {
1263 return new Object [][] {
1264
1265 {SystemFields.systemFields[SystemFields.rowId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (0)}
1266 , {SystemFields.systemFields[SystemFields.transactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (1)}
1267 , {SystemFields.systemFields[SystemFields.invalidTransactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (2)}
1268 , {SystemFields.systemFields[SystemFields.sessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (3)}
1269 , {SystemFields.systemFields[SystemFields.invalidSessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (4)}
1270 ,
1271
1272 {"UserName", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (5)}
1273 , {"CommitTime", new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (6)}
1274 , {"SavedTransactionId", new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (7)}
1275 , {"SavedSessionId", new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (8)}
1276 , {"TransactionComplete", new Long (Datatype.BOOLEAN), new Integer (Datatype.BOOLEANSIZE), new Long (9)}
1277 ,
1278 };
1279 }
1280
1281 static ColumnInformation transform_TableColumnInformation() {
1282 ColumnInformation ci = new ColumnInformation();
1283 ci.setObjects(transform_TableStructure());
1284 return ci;
1285 }
1286
1287 static Object [][] transform_TableStructure() {
1288 return new Object [][] { {SystemFields.systemFields[SystemFields.rowId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (0)}
1289 , {SystemFields.systemFields[SystemFields.transactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (1)}
1290 , {SystemFields.systemFields[SystemFields.invalidTransactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (2)}
1291 , {SystemFields.systemFields[SystemFields.sessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (3)}
1292 , {SystemFields.systemFields[SystemFields.invalidSessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (4)}
1293 ,
1294
1295 {"User_Defined_Type_Catalog", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (5)}
1296 , {"User_Defined_Type_Schema", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (6)}
1297 , {"User_Defined_Type_Name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (7)}
1298 , {"Specific_Catalog", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (8)}
1299 , {"Specific_Schema", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (9)}
1300 , {"Specific_Name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (10)}
1301 , {"Group_Name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (11)}
1302 , {"Transform_Type", new Long (Datatype.VARCHAR), characterDataSize, new Long (12)}
1303 ,
1304 };
1305 }
1306
1307 static ColumnInformation triggerColumnUsageTableColumnInformation() {
1308 ColumnInformation ci = new ColumnInformation();
1309 ci.setObjects(triggerColumnUsageTableStructure());
1310 return ci;
1311 }
1312
1313 static Object [][] triggerColumnUsageTableStructure() {
1314 return new Object [][] { {SystemFields.systemFields[SystemFields.rowId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (0)}
1315 , {SystemFields.systemFields[SystemFields.transactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (1)}
1316 , {SystemFields.systemFields[SystemFields.invalidTransactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (2)}
1317 , {SystemFields.systemFields[SystemFields.sessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (3)}
1318 , {SystemFields.systemFields[SystemFields.invalidSessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (4)}
1319 ,
1320
1321 {"trigger_catalog", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (5)}
1322 , {"trigger_schema", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (6)}
1323 , {"trigger_name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (7)}
1324 , {"table_catalog", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (8)}
1325 , {"table_schema", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (9)}
1326 , {"table_name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (10)}
1327 , {"column_name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (11)}
1328 ,
1329 };
1330 }
1331
1332 static ColumnInformation triggerTableColumnInformation() {
1333 ColumnInformation ci = new ColumnInformation();
1334 ci.setObjects(triggerTableStructure());
1335 return ci;
1336 }
1337
1338 static Object [][] triggerTableStructure() {
1339 return new Object [][] { {SystemFields.systemFields[SystemFields.rowId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (0)}
1340 , {SystemFields.systemFields[SystemFields.transactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (1)}
1341 , {SystemFields.systemFields[SystemFields.invalidTransactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (2)}
1342 , {SystemFields.systemFields[SystemFields.sessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (3)}
1343 , {SystemFields.systemFields[SystemFields.invalidSessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (4)}
1344 ,
1345
1346 {"trigger_catalog", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (5)}
1347 , {"trigger_schema", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (6)}
1348 , {"trigger_name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (7)}
1349 , {"event_manipulation", new Long (Datatype.VARCHAR), characterDataSize , new Long (8)}
1350 , {"event_object_catalog", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (9)}
1351 , {"event_object_schema", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (10)}
1352 , {"event_object_table", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (11)}
1353 , {"action_order", new Long (Datatype.INTEGER), new Integer (Datatype.INTSIZE), new Long (12)}
1354 ,
1355 {"action_condition", new Long (Datatype.VARCHAR), serializeObjectDataSize, new Long (13)}
1356 , {"action_statement", new Long (Datatype.VARCHAR), serializeObjectDataSize , new Long (14)}
1357 , {"action_orientation", new Long (Datatype.VARCHAR), characterDataSize , new Long (15)}
1358 , {"condition_timing", new Long (Datatype.VARCHAR), characterDataSize , new Long (16)}
1359 , {"condition_reference_old_table", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (17)}
1360 , {"condition_reference_new_table", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (18)}
1361 , {"created", new Long (Datatype.TIMESTAMP), new Integer (Datatype.TIMESTAMPSIZE), new Long (19)}
1362 ,
1363 };
1364 }
1365
1366 static ColumnInformation triggerTableUsageColumnInformation() {
1367 ColumnInformation ci = new ColumnInformation();
1368 ci.setObjects(triggerTableUsageTableStructure());
1369 return ci;
1370 }
1371
1372 static Object [][] triggerTableUsageTableStructure() {
1373 return new Object [][] { {SystemFields.systemFields[SystemFields.rowId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (0)}
1374 , {SystemFields.systemFields[SystemFields.transactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (1)}
1375 , {SystemFields.systemFields[SystemFields.invalidTransactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (2)}
1376 , {SystemFields.systemFields[SystemFields.sessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (3)}
1377 , {SystemFields.systemFields[SystemFields.invalidSessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (4)}
1378 ,
1379
1380 {"trigger_catalog", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (5)}
1381 , {"trigger_schema", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (6)}
1382 , {"trigger_name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (7)}
1383 , {"table_catalog", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (8)}
1384 , {"table_schema", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (9)}
1385 , {"table_name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (10)}
1386 ,
1387 };
1388 }
1389
1390 static ColumnInformation triggerUpdateColumnColumnInformation() {
1391 ColumnInformation ci = new ColumnInformation();
1392 ci.setObjects(triggerUpdateColumnTableStructure());
1393 return ci;
1394 }
1395
1396 static Object [][] triggerUpdateColumnTableStructure() {
1397 return new Object [][] { {SystemFields.systemFields[SystemFields.rowId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (0)}
1398 , {SystemFields.systemFields[SystemFields.transactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (1)}
1399 , {SystemFields.systemFields[SystemFields.invalidTransactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (2)}
1400 , {SystemFields.systemFields[SystemFields.sessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (3)}
1401 , {SystemFields.systemFields[SystemFields.invalidSessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (4)}
1402 ,
1403
1404 {"trigger_catalog", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (5)}
1405 , {"trigger_schema", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (6)}
1406 , {"trigger_name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (7)}
1407 , {"event_object_catalog", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (8)}
1408 , {"event_object_schema", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (9)}
1409 , {"event_object_table", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (10)}
1410 , {"event_object_column", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (11)}
1411 ,
1412 };
1413 }
1414
1415 static ColumnInformation usagePrivilegesTableColumnInformation() {
1416 ColumnInformation ci = new ColumnInformation();
1417 ci.setObjects(usagePrivilegesTableStructure());
1418 return ci;
1419 }
1420
1421 static Object [][] usagePrivilegesTableStructure() {
1422 return new Object [][] { {SystemFields.systemFields[SystemFields.rowId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (0)}
1423 , {SystemFields.systemFields[SystemFields.transactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (1)}
1424 , {SystemFields.systemFields[SystemFields.invalidTransactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (2)}
1425 , {SystemFields.systemFields[SystemFields.sessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (3)}
1426 , {SystemFields.systemFields[SystemFields.invalidSessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (4)}
1427 ,
1428
1429 {"grantor", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (5)}
1430 , {"grantee", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (6)}
1431 , {"object_catalog", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (7)}
1432 , {"object_schema", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (8)}
1433 , {"object_name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (9)}
1434 , {"object_type", new Long (Datatype.VARCHAR), characterDataSize , new Long (10)}
1435 , {"is_grantable", new Long (Datatype.VARCHAR), characterDataSize , new Long (11)}
1436 ,
1437 };
1438 }
1439
1440 static ColumnInformation User_Defined_Type_PrivilegesTableColumnInformation() {
1441 ColumnInformation ci = new ColumnInformation();
1442 ci.setObjects(User_Defined_TypesTableStructure());
1443 return ci;
1444 }
1445
1446 static Object [][] User_Defined_Type_PrivilegesTableStructure() {
1447 return new Object [][] { {SystemFields.systemFields[SystemFields.rowId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (0)}
1448 , {SystemFields.systemFields[SystemFields.transactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (1)}
1449 , {SystemFields.systemFields[SystemFields.invalidTransactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (2)}
1450 , {SystemFields.systemFields[SystemFields.sessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (3)}
1451 , {SystemFields.systemFields[SystemFields.invalidSessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (4)}
1452 ,
1453
1454 {"Grantor", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (5)}
1455 , {"Grantee", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (6)}
1456 , {"User_Defined_Type_Catalog", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (7)}
1457 , {"User_Defined_Type_Schema", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (8)}
1458 , {"User_Defined_Type_Name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (9)}
1459 , {"Privilege_Type", new Long (Datatype.VARCHAR), characterDataSize, new Long (10)}
1460 , {"Is_Grantable", new Long (Datatype.VARCHAR), characterDataSize, new Long (11)}
1461
1462 };
1463 }
1464
1465 static ColumnInformation User_Defined_TypesTableColumnInformation() {
1466 ColumnInformation ci = new ColumnInformation();
1467 ci.setObjects(User_Defined_TypesTableStructure());
1468 return ci;
1469 }
1470
1471 static Object [][] User_Defined_TypesTableStructure() {
1472 return new Object [][] {
1473
1474 {SystemFields.systemFields[SystemFields.rowId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (0)}
1475 , {SystemFields.systemFields[SystemFields.transactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (1)}
1476 , {SystemFields.systemFields[SystemFields.invalidTransactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (2)}
1477 , {SystemFields.systemFields[SystemFields.sessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (3)}
1478 , {SystemFields.systemFields[SystemFields.invalidSessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (4)}
1479 ,
1480
1481 {"User_Defined_Type_Catalog", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (5)}
1482 , {"User_Defined_Type_Schema", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (6)}
1483 , {"User_Defined_Type_Name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (7)}
1484 , {"User_Defined_Type_Category", new Long (Datatype.VARCHAR), characterDataSize, new Long (8)}
1485 , {"Source_Dtd_Identifier", new Long (Datatype.VARCHAR), dtdIdentifierSize, new Long (9)}
1486 , {"Is_Instantiable", new Long (Datatype.VARCHAR), characterDataSize, new Long (10)}
1487 , {"Is_Final", new Long (Datatype.VARCHAR), characterDataSize, new Long (11)}
1488 , {"Ordering_Form", new Long (Datatype.VARCHAR), characterDataSize, new Long (12)}
1489 , {"Ordering_Category", new Long (Datatype.VARCHAR), characterDataSize, new Long (13)}
1490 , {"Ordering_Routine_Catalog", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (14)}
1491 , {"Ordering_Routine_Schema", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (15)}
1492 , {"Ordering_Routine_Name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (16)}
1493 , {"Reference_Type", new Long (Datatype.VARCHAR), characterDataSize, new Long (17)}
1494 , {"Ref_Dtd_Identifier", new Long (Datatype.VARCHAR), dtdIdentifierSize, new Long (18)}
1495
1496 };
1497 }
1498
1499 static ColumnInformation usersTableColumnInformation() {
1500 ColumnInformation ci = new ColumnInformation();
1501 ci.setObjects(usersTableStructure());
1502 return ci;
1503 }
1504
1505 static Object [][] usersTableStructure() {
1506 return new Object [][] { {SystemFields.systemFields[SystemFields.rowId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (0)}
1507 , {SystemFields.systemFields[SystemFields.transactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (1)}
1508 , {SystemFields.systemFields[SystemFields.invalidTransactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (2)}
1509 , {SystemFields.systemFields[SystemFields.sessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (3)}
1510 , {SystemFields.systemFields[SystemFields.invalidSessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (4)}
1511 ,
1512
1513 {"user_name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (5)}
1514 , {"user_password", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (6)}
1515 ,
1516 };
1517 }
1518
1519 static ColumnInformation viewsTableColumnInformation() {
1520 ColumnInformation ci = new ColumnInformation();
1521 ci.setObjects(viewsTableStructure());
1522 return ci;
1523 }
1524
1525 static Object [][] viewsTableStructure() {
1526 return new Object [][] { {SystemFields.systemFields[SystemFields.rowId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (0)}
1527 , {SystemFields.systemFields[SystemFields.transactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (1)}
1528 , {SystemFields.systemFields[SystemFields.invalidTransactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (2)}
1529 , {SystemFields.systemFields[SystemFields.sessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (3)}
1530 , {SystemFields.systemFields[SystemFields.invalidSessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (4)}
1531 ,
1532
1533 {"table_catalog", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (5)}
1534 , {"table_schema", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (6)}
1535 , {"table_name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (7)}
1536 , {"view_definition", new Long (Datatype.VARCHAR), viewDefinitionSize , new Long (8)}
1537 , {"check_option", new Long (Datatype.VARCHAR), characterDataSize , new Long (9)}
1538 , {"is_updatable", new Long (Datatype.VARCHAR), characterDataSize , new Long (10)}
1539 , {"is_insertable_into", new Long (Datatype.VARCHAR), characterDataSize , new Long (11)}
1540 , {"materialized_table_name", new Long (Datatype.VARCHAR), characterDataSize , new Long (12)}
1541 };
1542 }
1543
1544 static ColumnInformation viewColumnUsageTableColumnInformation() {
1545 ColumnInformation ci = new ColumnInformation();
1546 ci.setObjects(viewColumnUsageTableStructure());
1547 return ci;
1548 }
1549
1550 static Object [][] viewColumnUsageTableStructure() {
1551 return new Object [][] { {SystemFields.systemFields[SystemFields.rowId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (0)}
1552 , {SystemFields.systemFields[SystemFields.transactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (1)}
1553 , {SystemFields.systemFields[SystemFields.invalidTransactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (2)}
1554 , {SystemFields.systemFields[SystemFields.sessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (3)}
1555 , {SystemFields.systemFields[SystemFields.invalidSessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (4)}
1556 ,
1557
1558 {"view_catalog", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (5)}
1559 , {"view_schema", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (6)}
1560 , {"view_name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (7)}
1561 , {"table_catalog", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (8)}
1562 , {"table_schema", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (9)}
1563 , {"table_name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (10)}
1564 , {"column_name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (11)}
1565 ,
1566 };
1567 }
1568
1569 static ColumnInformation viewTableUsageTableColumnInformation() {
1570 ColumnInformation ci = new ColumnInformation();
1571 ci.setObjects(viewTableUsageTableStructure());
1572 return ci;
1573 }
1574
1575 static Object [][] viewTableUsageTableStructure() {
1576 return new Object [][] { {SystemFields.systemFields[SystemFields.rowId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (0)}
1577 , {SystemFields.systemFields[SystemFields.transactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (1)}
1578 , {SystemFields.systemFields[SystemFields.invalidTransactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (2)}
1579 , {SystemFields.systemFields[SystemFields.sessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (3)}
1580 , {SystemFields.systemFields[SystemFields.invalidSessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (4)}
1581 ,
1582
1583 {"view_catalog", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (5)}
1584 , {"view_schema", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (6)}
1585 , {"view_name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (7)}
1586 , {"table_catalog", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (8)}
1587 , {"table_schema", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (9)}
1588 , {"table_name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (10)}
1589 ,
1590 };
1591 }
1592
1593 static ColumnInformation columnInfoTableColumnInformation() {
1594 ColumnInformation ci = new ColumnInformation();
1595 ci.setObjects(columnInfoTableStructure());
1596 return ci;
1597 }
1598
1599 static Object [][] columnInfoTableStructure() {
1600 return new Object [][] {
1601 {"CatalogName", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Integer (0)}
1602 , {"SchemaName", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Integer (1)}
1603 , {"TableName", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Integer (2)}
1604 , {"columnName", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Integer (3)}
1605 , {"columnType", new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Integer (4)}
1606 , {"columnSize", new Long (Datatype.INTEGER), new Integer (Datatype.INTSIZE), new Integer (5)}
1607 , {"columnIndex", new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Integer (6)}
1608 , {"Address", new Long (Datatype.INTEGER), new Integer (Datatype.INTSIZE), new Integer (7)}
1609 };
1610 }
1611
1612 public static ColumnInformation databaseInfoTableColumnInformation() {
1613 ColumnInformation ci = new ColumnInformation();
1614 ci.setObjects(databaseInfoTableStructure());
1615 return ci;
1616 }
1617
1618 static Object [][] databaseInfoTableStructure() {
1619 return new Object [][] {
1620 {"databaseName", new Long (Datatype.VARCHAR), new Long (128), new Long (0)}
1621 , {"initialSize", new Long (Datatype.VARCHAR), new Long (128), new Long (1)}
1622 , {"databaseVersion", new Long (Datatype.VARCHAR), new Long (128), new Long (2)}
1623 , {"databaseCode", new Long (Datatype.INTEGER), new Long (Datatype.INTSIZE), new Long (3)}
1624 , {"incrementFactor", new Long (Datatype.INTEGER), new Long (Datatype.INTSIZE), new Long (4)}
1625 , {"unicodeSupport", new Long (Datatype.BOOLEAN), new Long (Datatype.BOOLEANSIZE), new Long (5)}
1626 , {"multiFileSupport", new Long (Datatype.BOOLEAN), new Long (Datatype.BOOLEANSIZE), new Long (6)}
1627 , {"encryptionSupport", new Long (Datatype.BOOLEAN), new Long (Datatype.BOOLEANSIZE), new Long (7)}
1628 , {"encryptionAlgorithm", new Long (Datatype.VARCHAR), new Long (128), new Long (8)}
1629 , {"encryptionKey", new Long (Datatype.VARCHAR), new Long (128), new Long (9)}
1630 , {"CLUSTERSIZE", new Long (Datatype.VARCHAR), new Long (128), new Long (10)}
1631
1632 };
1633 }
1634
1635 static Object [][] databaseFullTextInfoTableStructure() {
1636 return new Object [][] {
1637 {"table_catalog", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (0)}
1638 , {"table_schema", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (1)}
1639 , {"table_name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (2)}
1640 , {"indexName", new Long (Datatype.VARCHAR), new Long (128), new Long (3)}
1641 ,
1642 {"tokenTableName", new Long (Datatype.VARCHAR), new Long (128), new Long (4)}
1643 , {"locationTableName", new Long (Datatype.VARCHAR), new Long (128), new Long (5)}
1644 ,
1645
1646 };
1647 }
1648
1649 static Object [][] databaseFullTextColumnInfoTableStructure() {
1650 return new Object [][] {
1651 {"table_catalog", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (0)}
1652 , {"table_schema", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (1)}
1653 , {"table_name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (2)}
1654 , {"indexName", new Long (Datatype.VARCHAR), new Long (128), new Long (3)}
1655 , {"columnName", new Long (Datatype.VARCHAR), new Long (128), new Long (4)}
1656 ,
1657
1658 };
1659 }
1660
1661 static Object [][] DefaultIndexTableStructure() {
1662 return new Object [][] { {"RecordClusterAddress", new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (0)}
1663 , {"RecordNumber", new Long (Datatype.INTEGER), new Integer (Datatype.INTSIZE), new Long (1)}
1664 , {"ClusterSize", new Long (Datatype.INTEGER), new Integer (Datatype.INTSIZE), new Long (2)}
1665 , {"NextNodeAddress", new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (3)}
1666 , {"NextNodeRecordNumber", new Long (Datatype.INTEGER), new Integer (Datatype.INTSIZE), new Long (4)}
1667 , {"NextClusterSize", new Long (Datatype.INTEGER), new Integer (Datatype.INTSIZE), new Long (5)}
1668 , {SystemFields.systemFields[SystemFields.rowId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (6)}
1669 , {SystemFields.systemFields[SystemFields.transactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (7)}
1670 , {SystemFields.systemFields[SystemFields.sessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (8)}
1671 ,
1672 };
1673 }
1674
1675 static Object [][] TransactionIndexTableStructure() {
1676 return new Object [][] { {"RecordClusterAddress", new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (0)}
1677 , {"RecordNumber", new Long (Datatype.INTEGER), new Integer (Datatype.INTSIZE), new Long (1)}
1678 , {"ClusterSize", new Long (Datatype.INTEGER), new Integer (Datatype.INTSIZE), new Long (2)}
1679 , {"NextNodeAddress", new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (3)}
1680 , {"NextNodeRecordNumber", new Long (Datatype.INTEGER), new Integer (Datatype.INTSIZE), new Long (4)}
1681 , {"NextClusterSize", new Long (Datatype.INTEGER), new Integer (Datatype.INTSIZE), new Long (5)}
1682 , {"SavedTransactionId", new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (6)}
1683 ,
1684 };
1685 }
1686
1687 static Object [][] SessionIndexTableStructure() {
1688 return new Object [][] { {"RecordClusterAddress", new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (0)}
1689 , {"RecordNumber", new Long (Datatype.INTEGER), new Integer (Datatype.INTSIZE), new Long (1)}
1690 , {"ClusterSize", new Long (Datatype.INTEGER), new Integer (Datatype.INTSIZE), new Long (2)}
1691 , {"NextNodeAddress", new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (3)}
1692 , {"NextNodeRecordNumber", new Long (Datatype.INTEGER), new Integer (Datatype.INTSIZE), new Long (4)}
1693 , {"NextClusterSize", new Long (Datatype.INTEGER), new Integer (Datatype.INTSIZE), new Long (5)}
1694 , {"SavedSessionId", new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (6)}
1695 ,
1696 };
1697 }
1698
1699 static Object [][] FreeSpaceInfoTableStructure() {
1700 return new Object [][] { {"CatalogName", new Long (Datatype.VARCHAR), SQLIdentifierSize, Boolean.FALSE, null, null, null}
1701 , {"SchemaName", new Long (Datatype.VARCHAR), SQLIdentifierSize, Boolean.FALSE, null, null, null}
1702 , {"TableName", new Long (Datatype.VARCHAR), SQLIdentifierSize, Boolean.FALSE, null, null, null}
1703 , {"ClusterAddress", new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), Boolean.TRUE, null, null, null}
1704 , {"FreeSpace", new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), Boolean.TRUE, null, null, null}
1705 };
1706 }
1707
1708 static Object [][] FileGeneratorInfoTableStructure() {
1709 return new Object [][] { {"DataBaseName", new Long (Datatype.VARCHAR), SQLIdentifierSize, Boolean.FALSE, null, null, null}
1710 , {"No_OfFiles", new Long (Datatype.INTEGER), new Integer (Datatype.INTSIZE), Boolean.TRUE, null, null, null}
1711 };
1712 }
1713
1714 static Object [][] sequenceTableStructure() {
1715 return new Object [][] { {SystemFields.systemFields[SystemFields.rowId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (0)}
1716 , {SystemFields.systemFields[SystemFields.transactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (1)}
1717 , {SystemFields.systemFields[SystemFields.invalidTransactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (2)}
1718 , {SystemFields.systemFields[SystemFields.sessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (3)}
1719 , {SystemFields.systemFields[SystemFields.invalidSessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (4)}
1720 , {"sequence_catalog", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (5)}
1721 , {"sequence_schema", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (6)}
1722 , {"sequence_name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (7)}
1723 , {"start_with", new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (8)}
1724 , {"min_value", new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (9)}
1725 , {"max_value", new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (10)}
1726 , {"increment_by", new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (11)}
1727 , {"last_value", new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (12)}
1728 , {"cycle_in_sequence", new Long (Datatype.BOOLEAN), new Integer (Datatype.BOOLEANSIZE), new Long (13)}
1729 , {"sequence_order", new Long (Datatype.BOOLEAN), new Integer (Datatype.BOOLEANSIZE), new Long (14)}
1730 };
1731
1732 }
1733
1734 static Object [][] scheduleInfoTableStructure() {
1735 return new Object [][] { {"databaseName", new Long (Datatype.VARCHAR), new Long (128), new Long (0)}
1736 , {"scheduleName", new Long (Datatype.VARCHAR), new Long (128), new Long (1)}
1737 , {"timeDuration", new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (2)}
1738 , {"backupType", new Long (Datatype.VARCHAR), new Long (128), new Long (3)}
1739 , {"lastBackupTime", new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (4)}
1740 , {"backupPath", new Long (Datatype.VARCHAR), new Long (128), new Long (5)}
1741 , {"databaseNameForBackup", new Long (Datatype.VARCHAR), new Long (128), new Long (6)}
1742 };
1743 }
1744
1745 static ColumnInformation dirtyDistributedTransactionsTableColumnInformation() {
1746 ColumnInformation ci = new ColumnInformation();
1747 ci.setObjects(dirtyDistributedTransactionsTableStructure());
1748 return ci;
1749 }
1750
1751 static Object [][] dirtyDistributedTransactionsTableStructure() {
1752 return new Object [][] { {SystemFields.systemFields[SystemFields.sessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (0)}
1753 , {"table_catalog", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (1)}
1754 , {"table_schema", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (2)}
1755 , {"table_name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (3)}
1756 };
1757 }
1758
1759 static ColumnInformation sequenceTableColumnInformation() {
1760 ColumnInformation ci = new ColumnInformation();
1761 ci.setObjects(sequenceTableStructure());
1762 return ci;
1763 }
1764
1765 static ColumnInformation routineColumnUsageTableColumnInformation() {
1766 ColumnInformation ci = new ColumnInformation();
1767 ci.setObjects(routineColumnUsageTableStructure());
1768 return ci;
1769 }
1770
1771 static Object [][] routineColumnUsageTableStructure() {
1772 return new Object [][] { {SystemFields.systemFields[SystemFields.rowId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (0)}
1773 , {SystemFields.systemFields[SystemFields.transactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (1)}
1774 , {SystemFields.systemFields[SystemFields.invalidTransactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (2)}
1775 , {SystemFields.systemFields[SystemFields.sessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (3)}
1776 , {SystemFields.systemFields[SystemFields.invalidSessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (4)}
1777 , {"SPECIFIC_catalog", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (5)}
1778 , {"SPECIFIC_schema", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (6)}
1779 , {"SPECIFIC_name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (7)}
1780 , {"table_catalog", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (8)}
1781 , {"table_schema", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (9)}
1782 , {"table_name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (10)}
1783 , {"column_name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (11)}
1784 };
1785 }
1786
1787 static ColumnInformation routineTableUsageTableColumnInformation() {
1788 ColumnInformation ci = new ColumnInformation();
1789 ci.setObjects(routineTableUsageTableStructure());
1790 return ci;
1791 }
1792
1793 static Object [][] routineTableUsageTableStructure() {
1794 return new Object [][] { {SystemFields.systemFields[SystemFields.rowId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (0)}
1795 , {SystemFields.systemFields[SystemFields.transactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (1)}
1796 , {SystemFields.systemFields[SystemFields.invalidTransactionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (2)}
1797 , {SystemFields.systemFields[SystemFields.sessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (3)}
1798 , {SystemFields.systemFields[SystemFields.invalidSessionId], new Long (Datatype.LONG), new Integer (Datatype.LONGSIZE), new Long (4)}
1799 , {"SPECIFIC_catalog", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (5)}
1800 , {"SPECIFIC_schema", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (6)}
1801 , {"SPECIFIC_name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (7)}
1802 , {"table_catalog", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (8)}
1803 , {"table_schema", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (9)}
1804 , {"table_name", new Long (Datatype.VARCHAR), SQLIdentifierSize, new Long (10)}
1805 };
1806 }
1807}
1808 |
Popular Tags |
Java API By Example, From Geeks To Geeks.