in src/main/java/software/amazon/documentdb/jdbc/DocumentDbDatabaseMetaDataResultSets.java [40:195]
static ImmutableList<JdbcColumnMetaData> buildProceduresColumnMetaData(
final String schemaName) {
if (proceduresColumnMetaData == null) {
// 1. PROCEDURE_CAT String => procedure catalog (may be null)
// 2. PROCEDURE_SCHEM String => procedure schema (may be null)
// 3. PROCEDURE_NAME String => procedure name
// 4. reserved for future use
// 5. reserved for future use
// 6. reserved for future use
// 7. REMARKS String => explanatory comment on the procedure
// 8. PROCEDURE_TYPE short => kind of procedure:
// procedureResultUnknown - Cannot determine if a return value will be returned
// procedureNoResult - Does not return a return value
// procedureReturnsResult - Returns a return value
// 9. SPECIFIC_NAME String => The name which uniquely identifies this procedure within its schema.
int ordinal = 0;
proceduresColumnMetaData = ImmutableList.<JdbcColumnMetaData>builder()
.add(new JdbcColumnMetaData(
ordinal++,
true, //caseSensitive,
ResultSetMetaData.columnNullable, //nullable,
false, //signed,
64, //displaySize,
"PROCEDURE_CAT", //label,
"PROCEDURE_CAT", //columnName,
schemaName, //schemaName,
0, //precision,
0, //scale,
Types.VARCHAR, //type.id,
JdbcType.VARCHAR.name(), //type.name,
String.class.getName()) //columnClassName
)
.add(new JdbcColumnMetaData(
ordinal++,
true, //caseSensitive,
ResultSetMetaData.columnNullable, //nullable,
false, //signed,
64, //displaySize,
"PROCEDURE_SCHEM", //label,
"PROCEDURE_SCHEM", //columnName,
schemaName, //schemaName,
0, //precision,
0, //scale,
Types.VARCHAR, //type.id,
JdbcType.VARCHAR.name(), //type.name,
String.class.getName()) //columnClassName
)
.add(new JdbcColumnMetaData(
ordinal++,
true, //caseSensitive,
ResultSetMetaData.columnNullable, //nullable,
false, //signed,
64, //displaySize,
"PROCEDURE_NAME", //label,
"PROCEDURE_NAME", //columnName,
schemaName, //schemaName,
0, //precision,
0, //scale,
Types.VARCHAR, //type.id,
JdbcType.VARCHAR.name(), //type.name,
String.class.getName()) //columnClassName
)
.add(new JdbcColumnMetaData(
ordinal++,
false, //caseSensitive,
ResultSetMetaData.columnNullable, //nullable,
false, //signed,
64, //displaySize,
"FUTURE_USE1", //label,
"FUTURE_USE1", //columnName,
schemaName, //schemaName,
0, //precision,
0, //scale,
Types.VARCHAR, //type.id,
JdbcType.VARCHAR.name(), //type.name,
String.class.getName()) //columnClassName
)
.add(new JdbcColumnMetaData(
ordinal++,
false, //caseSensitive,
ResultSetMetaData.columnNullable, //nullable,
false, //signed,
64, //displaySize,
"FUTURE_USE2", //label,
"FUTURE_USE2", //columnName,
schemaName, //schemaName,
0, //precision,
0, //scale,
Types.VARCHAR, //type.id,
JdbcType.VARCHAR.name(), //type.name,
String.class.getName()) //columnClassName
)
.add(new JdbcColumnMetaData(
ordinal++,
false, //caseSensitive,
ResultSetMetaData.columnNullable, //nullable,
false, //signed,
64, //displaySize,
"FUTURE_USE3", //label,
"FUTURE_USE3", //columnName,
schemaName, //schemaName,
0, //precision,
0, //scale,
Types.VARCHAR, //type.id,
JdbcType.VARCHAR.name(), //type.name,
String.class.getName()) //columnClassName
)
.add(new JdbcColumnMetaData(
ordinal++,
true, //caseSensitive,
ResultSetMetaData.columnNullable, //nullable,
false, //signed,
64, //displaySize,
"REMARKS", //label,
"REMARKS", //columnName,
schemaName, //schemaName,
0, //precision,
0, //scale,
Types.VARCHAR, //type.id,
JdbcType.VARCHAR.name(), //type.name,
String.class.getName()) //columnClassName
)
.add(new JdbcColumnMetaData(
ordinal++,
false, //caseSensitive,
ResultSetMetaData.columnNullable, //nullable,
false, //signed,
64, //displaySize,
"PROCEDURE_TYPE", //label,
"PROCEDURE_TYPE", //columnName,
schemaName, //schemaName,
0, //precision,
0, //scale,
Types.SMALLINT, //type.id,
JdbcType.SMALLINT.name(), //type.name,
short.class.getName()) //columnClassName
)
.add(new JdbcColumnMetaData(
ordinal, // not incremented
true, //caseSensitive,
ResultSetMetaData.columnNullable, //nullable,
false, //signed,
64, //displaySize,
"SPECIFIC_NAME", //label,
"SPECIFIC_NAME", //columnName,
schemaName, //schemaName,
0, //precision,
0, //scale,
Types.VARCHAR, //type.id,
JdbcType.VARCHAR.name(), //type.name,
String.class.getName()) //columnClassName
)
.build();
}
return proceduresColumnMetaData;
}