Examples of java.sql.DatabaseMetaData

java.sql.DatabaseMetaData
An interface which provides comprehensive information about the database.
This interface is implemented by JDBC driver writers in order to provide information about the underlying Database capabilities and the JDBC driver capabilities taken together.
Some of the methods in this interface take String parameters which are Patterns. Within these string Patterns, '%' and '_' characters have special meanings. '%' means "match any substring of 0 or more characters". '_' means "match any one character". Only metadata entries that match the pattern are returned. If such a search pattern string is set to null, that argument's criteria are dropped from the search.


  protected Set<String> findAllTables()
    throws SQLException
  {
    Set<String> tables = new HashSet<String>();
    DatabaseMetaData metaData = conn.getMetaData();
    String c = null;
    String s = null;
    String n = null;
    String[] TYPE_TABLE = new String[] { "TABLE" };
    ResultSet rs = metaData.getTables(c, s, n, TYPE_TABLE);
    try {
      while (rs.next()) {
        String tableName = rs.getString(3);
        tables.add(tableName);
      }

View Full Code Here


  protected Set<String> findTablesWithExactColumn(String column)
    throws SQLException
  {
    Set<String> tables = new HashSet<String>();
    DatabaseMetaData metaData = conn.getMetaData();
    String c = null;
    String s = null;
    String n = null;
    ResultSet rs = metaData.getColumns(c, s, n, column);
    try {
      while (rs.next()) {
        String tableName = rs.getString(3);
        tables.add(tableName);
      }

View Full Code Here


    Class.forName(driver);


    Connection conn = DriverManager.getConnection(server, user, pass);


    DatabaseMetaData md = conn.getMetaData();


    if (namespace.equals("--tables")) {
      listTables(md);
      conn.close();
    }

View Full Code Here

    */
   public final void informativeStuff(I_DbPool pool) throws Exception {
      Connection conn = null;
      try {
         conn = pool.reserve();
         DatabaseMetaData meta = conn.getMetaData();
         
         ResultSet rs = meta.getTypeInfo();
         
         while (rs.next()) {
            System.out.println(meta.getDatabaseProductName());
            System.out.println("==========================================================");
            System.out.println("'" + rs.getString(1) + "'\t  TYPE_NAME String => Type name");
            System.out.println("'" + rs.getInt(2) + "'\t DATA_TYPE int => SQL data type from java.sql.Types");
            System.out.println("'" + rs.getInt(3) + "'\t PRECISION int => maximum precision");
            System.out.println("'" + rs.getString(4) + "'\t LITERAL_PREFIX String => prefix used to quote a literal (may be null)");

View Full Code Here

  }


  public boolean isCreated()
    throws SQLException
  {
    DatabaseMetaData metaData = conn.getMetaData();
    String c = getCatalog();
    String s = getSchema();
    String n = getName();
    ResultSet tables = metaData.getTables(c, s, n, TYPE_TABLE);
    try {
      return tables.next();
    }
    finally {
      tables.close();

View Full Code Here

  }


  public Map<String, List<String>> getIndexes()
    throws SQLException
  {
    DatabaseMetaData metaData = conn.getMetaData();
    String c = getCatalog();
    String s = getSchema();
    String n = getName();
    ResultSet indexes = metaData.getIndexInfo(c, s, n, false, false);
    try {
      Map<String, List<String>> names = new HashMap<String, List<String>>();
      while (indexes.next()) {
        String index = indexes.getString(6);
        String column = indexes.getString(9);

View Full Code Here

  protected IDataSet createDataSet() throws DataSetException
  {
    final ISQLConnection conn = getSession().getSQLConnection();
    try
    {
            DatabaseMetaData md = conn.getSQLMetaData().getJDBCMetaData();
      return new MetaDataDecoratorDataSet(md, getSession().getDriver().getDriverClassName(), getSession().getDriver().getJarFileNames());
    }
    catch (SQLException ex)
    {
      throw new DataSetException(ex);

View Full Code Here

           throw new IllegalArgumentException("tableName must be not empty");
      catalog = StringHelper.defaultIfEmpty(catalog, null);
      schema = StringHelper.defaultIfEmpty(schema, null);
      
    Connection conn = DataSourceProvider.getConnection();
    DatabaseMetaData dbMetaData = conn.getMetaData();
    ResultSet rs = dbMetaData.getTables(catalog, schema, tableName, null);
    try {
      while(rs.next()) {
        Table table = new TableCreateProcessor(conn,getSchema(),getCatalog()).createTable(rs);
        return table;
      }

View Full Code Here

          GLogger.perf("createTable() cost:"+(System.currentTimeMillis()- start)+" tableName:"+tableName);
      }
    }
    
    private List<Table> getAllTables() throws SQLException {
      DatabaseMetaData dbMetaData = connection.getMetaData();
      ResultSet rs = dbMetaData.getTables(getCatalog(), getSchema(), null, null);
      try {
        List<Table> tables = new ArrayList<Table>();
        while(rs.next()) {
          tables.add(createTable(rs));
        }

View Full Code Here

        try {
            Class.forName("org.hsqldb.jdbcDriver").newInstance();
            conn = DriverManager.getConnection("jdbc:hsqldb:../data/db","sa","");
            stmt = conn.createStatement();
            
            DatabaseMetaData dbmd = conn.getMetaData();
            ResultSet rs = dbmd.getTables(null, null, "%", null);
            
            boolean found = false;


            while (rs.next()) {
                    String s = rs.getString(3);

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of java.sql.DatabaseMetaData

atg.tools.dynunit.adapter.gsa.SQLProcessorEngine

ca.carleton.gcrc.jdbc.JdbcConnections

ch.epfl.lbd.database.providers.oracle.connection.OracleConnection

ch.epfl.lbd.database.providers.postgresql.connection.PostgreSqlConnection

ch.qos.logback.core.db.ConnectionSourceBase

cn.org.rapid_framework.generator.provider.db.DbTableFactory

cn.org.rapid_framework.generator.provider.db.table.TableFactory

co.paralleluniverse.galaxy.jdbc.SQLDB

com.alibaba.druid.filter.FilterChainImpl

com.alibaba.otter.shared.common.utils.meta.DdlUtils

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.