@Override public String getCatalogName(final int column) throws SQLException { return resultSetMetaData.getCatalogName(column); }
@Override public String getCatalogName(int column) throws InvalidResultSetAccessException { try { return this.resultSetMetaData.getCatalogName(column); } catch (SQLException se) { throw new InvalidResultSetAccessException(se); } }
@Override public String resultSetMetaData_getCatalogName(ResultSetMetaDataProxy metaData, int column) throws SQLException { if (this.pos < filterSize) { return nextFilter() .resultSetMetaData_getCatalogName(this, metaData, column); } return metaData.getResultSetMetaDataRaw() .getCatalogName(column); }
private Pair<List<List<String>>, List<SelectedColumnMeta>> createResponseFromResultSet(ResultSet resultSet) throws Exception { List<List<String>> results = Lists.newArrayList(); List<SelectedColumnMeta> columnMetas = Lists.newArrayList(); ResultSetMetaData metaData = resultSet.getMetaData(); int columnCount = metaData.getColumnCount(); // Fill in selected column meta for (int i = 1; i <= columnCount; ++i) { columnMetas.add(new SelectedColumnMeta(metaData.isAutoIncrement(i), metaData.isCaseSensitive(i), metaData.isSearchable(i), metaData.isCurrency(i), metaData.isNullable(i), metaData.isSigned(i), metaData.getColumnDisplaySize(i), metaData.getColumnLabel(i), metaData.getColumnName(i), metaData.getSchemaName(i), metaData.getCatalogName(i), metaData.getTableName(i), metaData.getPrecision(i), metaData.getScale(i), metaData.getColumnType(i), metaData.getColumnTypeName(i), metaData.isReadOnly(i), metaData.isWritable(i), metaData.isDefinitelyWritable(i))); } // fill in results while (resultSet.next()) { List<String> oneRow = Lists.newArrayListWithCapacity(columnCount); for (int i = 0; i < columnCount; i++) { oneRow.add((resultSet.getString(i + 1))); } results.add(oneRow); } return new Pair<>(results, columnMetas); }
private static TableMeta resultSetMetaToSchema(ResultSetMetaData rsmd, DatabaseMetaData dbmd, String tableName) throws SQLException { String schemaName = rsmd.getSchemaName(1); String catalogName = rsmd.getCatalogName(1);
@Test public void test_getCatalogName_getsCatalogName() throws SQLException { assertThat( rowMetadata.getCatalogName( ordOptBOOLEAN ), anyOf( equalTo( "DRILL" ), equalTo( "" ) ) ); }
r.addRow(i, m.getColumnLabel(i), m.getCatalogName(i), m.getSchemaName(i), m.getTableName(i),
private void printResultSetMetaData(ResultSet rs) throws SQLException { ResultSetMetaData metadata = rs.getMetaData(); System.out.println("Metadata:"); for (int i = 0; i < metadata.getColumnCount(); i++) { String metaStr = metadata.getCatalogName(i + 1) + " " + metadata.getColumnClassName(i + 1) + " " + metadata.getColumnDisplaySize(i + 1) + " " + metadata.getColumnLabel(i + 1) + " " + metadata.getColumnName(i + 1) + " " + metadata.getColumnType(i + 1) + " " + metadata.getColumnTypeName(i + 1) + " " + metadata.getPrecision(i + 1) + " " + metadata.getScale(i + 1) + " " + metadata.getSchemaName(i + 1) + " " + metadata.getTableName(i + 1); System.out.println(metaStr); } } }
catelogName = resultSetMetaData.getCatalogName(columnIndex); } catch (SQLException e) {
boolean isEqualsTo(ResultSetMetaData metadata, int colNum) throws SQLException { return metadata.getCatalogName(colNum).equals(InfoSchemaConstants.IS_CATALOG_NAME) && metadata.getSchemaName(colNum).isEmpty() && metadata.getTableName(colNum).isEmpty() && metadata.getColumnName(colNum).equals(columnName) && metadata.getColumnLabel(colNum).equals(columnName) && metadata.getColumnType(colNum) == type && metadata.isNullable(colNum) == nullable && // There is an existing bug where query results doesn't contain the precision for VARCHAR field. //metadata.getPrecision(colNum) == precision && metadata.getScale(colNum) == scale && metadata.isSigned(colNum) == signed && metadata.getColumnDisplaySize(colNum) == displaySize && metadata.getColumnClassName(colNum).equals(className) && metadata.isSearchable(colNum) && metadata.isAutoIncrement(colNum) == false && metadata.isCaseSensitive(colNum) == false && metadata.isReadOnly(colNum) && metadata.isWritable(colNum) == false && metadata.isDefinitelyWritable(colNum) == false && metadata.isCurrency(colNum) == false; }
meta.getCatalogName(i), m_ColAttrib_CATALOGUE_NAME_TypeID, lastColHeaderIdx);
@DB() protected void setField(final Object entity, final ResultSet rs, ResultSetMetaData meta, final int index) throws SQLException { Attribute attr = _allColumns.get(new Pair<String, String>(meta.getTableName(index), meta.getColumnName(index))); if (attr == null) { // work around for mysql bug to return original table name instead of view name in db view case Table tbl = entity.getClass().getSuperclass().getAnnotation(Table.class); if (tbl != null) { attr = _allColumns.get(new Pair<String, String>(tbl.name(), meta.getColumnLabel(index))); } } assert (attr != null) : "How come I can't find " + meta.getCatalogName(index) + "." + meta.getColumnName(index); setField(entity, attr.field, rs, index); }
@Override public String resultSetMetaData_getCatalogName(ResultSetMetaDataProxy metaData, int column) throws SQLException { if (this.pos < filterSize) { return nextFilter() .resultSetMetaData_getCatalogName(this, metaData, column); } return metaData.getResultSetMetaDataRaw() .getCatalogName(column); }
@Override public String getCatalogName(final int column) throws SQLException { return resultSetMetaData.getCatalogName(column); }
@Override public String getCatalogName(int i) throws SQLException { try(Resource res = resultSetHolder.getResource()) { return res.getResultSet().getMetaData().getCatalogName(i); } }
for (int i = 1; i <= columnCount; i++) final String catalogName = resultsMetaData.getCatalogName(i); final String schemaName = resultsMetaData.getSchemaName(i); String tableName = resultsMetaData.getTableName(i);
for (int i = 1; i <= columnCount; i++) final String catalogName = resultsMetaData.getCatalogName(i); final String schemaName = resultsMetaData.getSchemaName(i); String tableName = resultsMetaData.getTableName(i);
protected GeneratedKeyInfo(ResultSetMetaData metaData, ResultSet rs, int columnNo) throws SQLException { this.catalogName = metaData.getCatalogName(columnNo); this.schemaName = metaData.getSchemaName(columnNo); this.tableName = metaData.getTableName(columnNo); this.columnName = metaData.getColumnName(columnNo); this.columnLabel = metaData.getColumnLabel(columnNo); this.value = rs.getObject(columnNo); this.columnNo = columnNo - 1; this.converters = Converters.getDefault(); }
private static void updateKeys(SourceColumn column, DatabaseMetaData dm, ResultSetMetaData rsm, int i) throws SQLException { String columnName = rsm.getColumnName(i); String schemaName = rsm.getSchemaName(i); String tableName = rsm.getTableName(i); String catalog = rsm.getCatalogName(i); checkConnectionPoint(column, columnName, dm.getPrimaryKeys(catalog, schemaName, tableName)); if (!column.getLdmType().equals(SourceColumn.LDM_TYPE_CONNECTION_POINT)) { checkReference(column, columnName, dm.getImportedKeys(catalog, schemaName, tableName)); } }
@Test public void test_getCatalogName_getsCatalogName() throws SQLException { assertThat( rowMetadata.getCatalogName( ordOptBOOLEAN ), anyOf( equalTo( "DREMIO" ), equalTo( "" ) ) ); }