private boolean isTableExist(final Connection connection, final String catalog, final String actualTableName) throws SQLException { try (ResultSet resultSet = connection.getMetaData().getTables(catalog, null, actualTableName, null)) { return resultSet.next(); } }
public static boolean existsTable(String tablename) throws SQLException { if(existingTablenames == null){ existingTablenames = new HashSet<>(); DatabaseMetaData md = connection.getMetaData(); ResultSet rs = md.getTables(null, null, "%", null); while (rs.next()) { existingTablenames.add(rs.getString(3).toLowerCase()); } } return (existingTablenames.contains(tablename.toLowerCase())); }
ResultSet rs = meta.getTables(null, name, null, tableTypes); ArrayList<DbTableOrView> list = New.arrayList(); while (rs.next()) { DbTableOrView table = new DbTableOrView(this, rs); if (contents.isOracle() && table.getName().indexOf('$') > 0) { rs.close(); tables = list.toArray(new DbTableOrView[0]); if (tables.length < SysProperties.CONSOLE_MAX_TABLES_LIST_COLUMNS) {
@Override protected ResultSet getTables(Connection connection, String schemaName, String tableName) throws SQLException { // MySQL maps their "database" to SQL catalogs and does not have schemas DatabaseMetaData metadata = connection.getMetaData(); String escape = metadata.getSearchStringEscape(); return metadata.getTables( schemaName, null, escapeNamePattern(tableName, escape), new String[] {"TABLE", "VIEW"}); }
Connection conn = driver.connect("jdbc:kylin://localhost:7070/default", info); ResultSet catalogs = conn.getMetaData().getCatalogs(); System.out.println("CATALOGS"); printResultSetMetaData(catalogs); printResultSet(catalogs); ResultSet schemas = conn.getMetaData().getSchemas(); System.out.println("SCHEMAS"); printResultSetMetaData(schemas); printResultSet(schemas); ResultSet tables = conn.getMetaData().getTables(null, null, null, null); System.out.println("TABLES"); printResultSetMetaData(tables); printResultSet(resultSet); resultSet.close(); catalogs.close(); schemas.close(); tables.close(); conn.close();
@Override public List<String> listTables(String schema) throws SQLException { List<String> ret = new ArrayList<>(); try (Connection con = SqlUtil.getConnection(dbconf); ResultSet rs = con.getMetaData().getTables(null, schema, null, null)) { while (rs.next()) { String name = rs.getString("TABLE_NAME"); ret.add(name); } } return ret; }
private void createJobRunningTableIfNeeded(final Connection conn) throws SQLException { DatabaseMetaData dbMetaData = conn.getMetaData(); try (ResultSet resultSet = dbMetaData.getTables(null, null, TABLE_JOB_RUNNING_STATISTICS, new String[]{"TABLE"})) { if (!resultSet.next()) { createJobRunningTable(conn); } } }
@Test public void testNoSuchTable() throws Exception { ResultSet resultSet = mock(ResultSet.class); given(resultSet.next()).willReturn(false); given(databaseMetaData.getDatabaseProductName()).willReturn("MyDB"); given(databaseMetaData.getDatabaseProductName()).willReturn("MyDB"); given(databaseMetaData.getDatabaseProductVersion()).willReturn("1.0"); given(databaseMetaData.getUserName()).willReturn("me"); given(databaseMetaData.storesLowerCaseIdentifiers()).willReturn(true); given(databaseMetaData.getTables(null, null, "x", null)).willReturn(resultSet); SimpleJdbcInsert insert = new SimpleJdbcInsert(dataSource).withTableName("x"); // Shouldn't succeed in inserting into table which doesn't exist thrown.expect(InvalidDataAccessApiUsageException.class); try { insert.execute(new HashMap<>()); } finally { verify(resultSet).close(); } }
@Override protected ResultSet getTables(Connection connection, String schemaName, String tableName) throws SQLException { DatabaseMetaData metadata = connection.getMetaData(); String escape = metadata.getSearchStringEscape(); return metadata.getTables( connection.getCatalog(), escapeNamePattern(schemaName, escape), escapeNamePattern(tableName, escape), new String[] {"TABLE", "VIEW", "MATERIALIZED VIEW", "FOREIGN TABLE"}); }
@Override public List<String> listTables(String catalog) throws SQLException { List<String> ret = new ArrayList<>(); try (Connection con = getConnection(); ResultSet res = con.getMetaData().getTables(catalog, null, null, null)) { String table; while (res.next()) { table = res.getString("TABLE_NAME"); ret.add(table); } } return ret; }
private void createTaskRunningTableIfNeeded(final Connection conn) throws SQLException { DatabaseMetaData dbMetaData = conn.getMetaData(); try (ResultSet resultSet = dbMetaData.getTables(null, null, TABLE_TASK_RUNNING_STATISTICS, new String[]{"TABLE"})) { if (!resultSet.next()) { createTaskRunningTable(conn); } } }
DatabaseMetaData meta = con.getMetaData(); ResultSet res = meta.getTables(null, null, "My_Table_Name", new String[] {"TABLE"}); while (res.next()) { System.out.println( " "+res.getString("TABLE_CAT") + ", "+res.getString("TABLE_SCHEM") + ", "+res.getString("TABLE_NAME") + ", "+res.getString("TABLE_TYPE") + ", "+res.getString("REMARKS")); }
protected ResultSet getTables(Connection connection, String schemaName, String tableName) throws SQLException { DatabaseMetaData metadata = connection.getMetaData(); String escape = metadata.getSearchStringEscape(); return metadata.getTables( connection.getCatalog(), escapeNamePattern(schemaName, escape), escapeNamePattern(tableName, escape), new String[] {"TABLE", "VIEW"}); }