Java Code Examples for java.sql.DatabaseMetaData#getTableTypes()

The following examples show how to use java.sql.DatabaseMetaData#getTableTypes() . You can vote up the ones you like or vote down the ones you don't like, and go to the original project or source file by following the links above each example. You may check out the related API usage on the sidebar.

Example 1

Source File: DatabaseMetaDataTest.java From gemfirexd-oss with Apache License 2.0

6 votes

/**
 * Test getTableTypes()
 */
public void testTableTypes() throws SQLException
{
    DatabaseMetaData dmd = getDMD();

    ResultSet rs = dmd.getTableTypes();
    assertMetaDataResultSet(rs,
            new String[] {
            "TABLE_TYPE"
           },
           new int[] {
            Types.VARCHAR
           }
    , null
          );

    JDBC.assertFullResultSet(rs, new String[][]
      {
        {"SYNONYM"},{"SYSTEM TABLE"},{"TABLE"},{"VIEW"},
      }, true);
    rs.close();
}

Example 2

Source File: DatabaseMetaDataIT.java From snowflake-jdbc with Apache License 2.0

6 votes

@Test
public void testGetTableTypes() throws Throwable
{
  try (Connection connection = getConnection())
  {
    DatabaseMetaData metaData = connection.getMetaData();
    ResultSet resultSet = metaData.getTableTypes();
    Set<String> types = new HashSet<>();
    while (resultSet.next())
    {
      types.add(resultSet.getString(1));
    }
    assertEquals(2, types.size());
    assertTrue(types.contains("TABLE"));
    assertTrue(types.contains("VIEW"));
  }
}

Example 3

Source File: DatabaseMetaDataTest.java From gemfirexd-oss with Apache License 2.0

6 votes

/**
 * Test getTableTypes()
 */
public void testTableTypes() throws SQLException
{
    DatabaseMetaData dmd = getDMD();

    ResultSet rs = dmd.getTableTypes();
    assertMetaDataResultSet(rs,
            new String[] {
            "TABLE_TYPE"
           },
           new int[] {
            Types.VARCHAR
           }
    , null
          );

    JDBC.assertFullResultSet(rs, new String[][]
      {
        {"SYNONYM"},{"SYSTEM TABLE"},{"TABLE"},{"VIEW"},
      }, true);
    rs.close();
}

Example 4

Source File: ConnectionTest.java From tddl5 with Apache License 2.0

6 votes

/**
 * MetaData
 * 
 * @author jianghang
 * @since 5.0.2
 */
@Test
public void testDatabaseMetaData() throws Exception {
    DatabaseMetaData metaData = tddlConnection.getMetaData();
    ResultSet rs = metaData.getTableTypes();
    printResult(rs);

    rs = metaData.getTables("andor_mysql_group_atom",
        "andor_mysql_group_atom",
        "mysql_ibatis_type",
        new String[] { "TABLE" });
    printResult(rs);

    rs = metaData.getColumns("andor_mysql_group_atom", "andor_mysql_group_atom", "mysql_ibatis_type", "%");
    printResult(rs);
}

Example 5

Source File: JdbcThinMetadataSelfTest.java From ignite with Apache License 2.0

6 votes

/**
 * @throws Exception If failed.
 */
@Test
public void testGetTableTypes() throws Exception {
    try (Connection conn = DriverManager.getConnection(URL)) {
        DatabaseMetaData meta = conn.getMetaData();

        ResultSet rs = meta.getTableTypes();

        assertTrue(rs.next());

        assertEquals("TABLE", rs.getString("TABLE_TYPE"));

        assertTrue(rs.next());

        assertEquals("VIEW", rs.getString("TABLE_TYPE"));
    }
}

Example 6

Source File: JdbcMetadataSelfTest.java From ignite with Apache License 2.0

6 votes

/**
 * @throws Exception If failed.
 */
@Test
public void testGetTableTypes() throws Exception {
    try (Connection conn = DriverManager.getConnection(BASE_URL)) {
        DatabaseMetaData meta = conn.getMetaData();

        ResultSet rs = meta.getTableTypes();

        assertTrue(rs.next());

        assertEquals("TABLE", rs.getString("TABLE_TYPE"));

        assertTrue(rs.next());

        assertEquals("VIEW", rs.getString("TABLE_TYPE"));
    }
}

Example 7

Source File: JDBCSourceOrSink.java From components with Apache License 2.0

6 votes

private Set<String> getAvailableTableTypes(DatabaseMetaData dbMetaData) throws SQLException {
    Set<String> availableTableTypes = new HashSet<String>();
    List<String> neededTableTypes = Arrays.asList("TABLE", "VIEW", "SYNONYM");

    try (ResultSet rsTableTypes = dbMetaData.getTableTypes()) {
        while (rsTableTypes.next()) {
            String currentTableType = rsTableTypes.getString("TABLE_TYPE");
            if (currentTableType == null) {
                currentTableType = "";
            }
            currentTableType = currentTableType.trim();
            if ("BASE TABLE".equalsIgnoreCase(currentTableType)) {
                currentTableType = "TABLE";
            }
            if (neededTableTypes.contains(currentTableType)) {
                availableTableTypes.add(currentTableType);
            }
        }
    }

    return availableTableTypes;
}

Example 8

Source File: QueryDatabaseMetaDataIT.java From phoenix with Apache License 2.0

6 votes

@Test
public void testTableTypes() throws SQLException {
    try (Connection conn = DriverManager.getConnection(getUrl())) {
        DatabaseMetaData dbmd = conn.getMetaData();
        ResultSet rs = dbmd.getTableTypes();
        assertTrue(rs.next());
        assertEquals("INDEX", rs.getString(1));
        assertTrue(rs.next());
        assertEquals("SEQUENCE", rs.getString(1));
        assertTrue(rs.next());
        assertEquals("SYSTEM TABLE", rs.getString(1));
        assertTrue(rs.next());
        assertEquals("TABLE", rs.getString(1));
        assertTrue(rs.next());
        assertEquals("VIEW", rs.getString(1));
        assertFalse(rs.next());
    }
}

Example 9

Source File: AceQLMetaData.java From aceql-http with GNU Lesser General Public License v2.1

5 votes

/**
    * Returns the table types for the Connection
    *
    * @return the table types for the Connection
    * @throws SQLException it any SQL Exception occurs
    */
   public List<String> getTableTypes() throws SQLException {
DatabaseMetaData databaseMetaData = connection.getMetaData();
ResultSet rs = databaseMetaData.getTableTypes();
List<String> tableTypes = new ArrayList<>();
while (rs.next()) {
    tableTypes.add(rs.getString(1));
}
return tableTypes;
   }

Example 10

Source File: MetaDataJavaPrinter.java From aceql-http with GNU Lesser General Public License v2.1

5 votes

public List<String> getTableTypes() throws SQLException {
DatabaseMetaData databaseMetaData = connection.getMetaData();
ResultSet rs = databaseMetaData.getTableTypes();
List<String> tableTypes = new ArrayList<>();
while (rs.next()) {
    tableTypes.add(rs.getString(1));
}
return tableTypes;
   }

Example 11

Source File: MetaResultSetTest.java From calcite-avatica with Apache License 2.0

5 votes

@Test public void testGetTableTypes() throws SQLException {
  DatabaseMetaData metadata = getDatabaseMetadata();
  try (ResultSet rs = metadata.getTableTypes()) {
    ResultSetMetaData rsMeta = rs.getMetaData();

    assertEquals(1, rsMeta.getColumnCount());
    assertColumn(rsMeta, 1, "TABLE_TYPE", Types.VARCHAR, DatabaseMetaData.columnNoNulls);
  }
}

Example 12

Source File: Database.java From sis with Apache License 2.0

5 votes

/**
 * Returns the "TABLE" and "VIEW" keywords for table type, with unsupported keywords omitted.
 */
private static String[] getTableTypes(final DatabaseMetaData metadata) throws SQLException {
    final Set<String> types = new HashSet<>(4);
    try (ResultSet reflect = metadata.getTableTypes()) {
        while (reflect.next()) {
            final String type = reflect.getString(Reflection.TABLE_TYPE);
            if ("TABLE".equalsIgnoreCase(type) || "VIEW".equalsIgnoreCase(type)) {
                types.add(type);
            }
        }
    }
    return types.toArray(new String[types.size()]);
}

Example 13

Source File: CassandraConnectionTest.java From cassandra-jdbc-driver with Apache License 2.0

4 votes

@Test(groups = {"unit", "server"})
public void testGetMetaData() {
    try {
        DatabaseMetaData metaData = conn.getMetaData();
        assertNotNull(metaData);
        assertEquals("KEYSPACE", metaData.getSchemaTerm());

        ResultSet rs = metaData.getTableTypes();
        assertTrue(rs instanceof DummyCassandraResultSet);
        assertEquals(extractColumnNames(CassandraUtils.TABLE_TYPE_COLUMNS),
                CassandraUtils.getColumnNames(rs));
        assertEquals(CassandraUtils.TABLE_TYPE_DATA[0],
                CassandraUtils.getAllData(rs)[0]);
        rs.close();

        rs = metaData.getSchemas();
        assertTrue(rs instanceof DummyCassandraResultSet);
        assertEquals(extractColumnNames(CassandraUtils.SCHEMA_COLUMNS),
                CassandraUtils.getColumnNames(rs));
        Logger.debug(CassandraUtils.getAllData(rs));
        rs.close();

        rs = metaData.getTables(null, "system", "peers", null);
        assertTrue(rs instanceof DummyCassandraResultSet);
        assertEquals(extractColumnNames(CassandraUtils.TABLE_COLUMNS),
                CassandraUtils.getColumnNames(rs));
        Logger.debug(CassandraUtils.getAllData(rs));
        rs.close();

        rs = metaData.getColumns(null, "system", "peers", null);
        assertTrue(rs instanceof DummyCassandraResultSet);
        assertEquals(extractColumnNames(CassandraUtils.COLUMN_COLUMNS),
                CassandraUtils.getColumnNames(rs));
        Logger.debug(CassandraUtils.getAllData(rs));
        rs.close();

        rs = metaData.getIndexInfo(null, "system", "peers", false, true);
        assertTrue(rs instanceof DummyCassandraResultSet);
        assertEquals(extractColumnNames(CassandraUtils.INDEX_COLUMNS),
                CassandraUtils.getColumnNames(rs));
        Logger.debug(CassandraUtils.getAllData(rs));
        rs.close();

        rs = metaData.getPrimaryKeys(null, "system", "peers");
        assertTrue(rs instanceof DummyCassandraResultSet);
        assertEquals(extractColumnNames(CassandraUtils.PK_COLUMNS),
                CassandraUtils.getColumnNames(rs));
        Logger.debug(CassandraUtils.getAllData(rs));
        rs.close();

        rs = metaData.getUDTs(null, "system", "%", null);
        assertTrue(rs instanceof DummyCassandraResultSet);
        assertEquals(extractColumnNames(CassandraUtils.UDT_COLUMNS),
                CassandraUtils.getColumnNames(rs));
        Logger.debug(CassandraUtils.getAllData(rs));
        rs.close();

        rs = metaData.getColumns(null, "system", "IndexInfo", null);
        assertTrue(rs instanceof DummyCassandraResultSet);
        assertEquals(extractColumnNames(CassandraUtils.COLUMN_COLUMNS),
                CassandraUtils.getColumnNames(rs));
        Logger.debug(CassandraUtils.getAllData(rs));
        rs.close();
    } catch (SQLException e) {
        e.printStackTrace();
        fail("Error occurred during testing: " + e.getMessage());
    }
}