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.

  {
    ResultSet rs = null;
    try
    {
      final Map<Integer, TableColumnInfo> columns = new TreeMap<Integer, TableColumnInfo>();
      DatabaseMetaData md = privateGetJDBCMetaData();
      rs = md.getColumns(catalog, schema, table, "%");
      final ResultSetColumnReader rdr = new ResultSetColumnReader(rs);


      int isNullAllowed = DatabaseMetaData.typeNullableUnknown;


      int index = 0;

View Full Code Here

   * @throws SQLException
   */
  @Test
  public void testGetIdentifierQuoteStringMSSQL() throws SQLException {
    Connection mockCon = mockHelper.createMock(Connection.class);
    DatabaseMetaData md = mockHelper.createMock(DatabaseMetaData.class);
    expect(md.getIdentifierQuoteString()).andStubReturn("foo");
    expect(mockCon.getMetaData()).andStubReturn(md);
    ISQLConnection sqlcon = mockHelper.createMock(ISQLConnection.class);
     expect(sqlcon.getConnection()).andStubReturn(mockCon);
    SQLDatabaseMetaData sqlmd = new SQLDatabaseMetaData(sqlcon);

View Full Code Here

 * @author manningr
 */
public class SybaseNonDboTableTest {
   
   private static void test(Connection con) throws Exception {
      DatabaseMetaData md = con.getMetaData();
      
      String cat = "dbcopydest";
      String schemaPattern = null;
      String tableNamePattern = null;


      ResultSet rs = md.getTables(cat,
                                  schemaPattern,
                                  tableNamePattern,
                                  new String[] { "TABLE" });
      while (rs.next()) {
         /*

View Full Code Here

    private static void test(Connection con) throws Exception{
        execute(con, dropTable, false);
        execute(con, createTable, true);
        
        ResultSet rs = null;
        DatabaseMetaData md = con.getMetaData();
        rs = md.getTables(null, null, "foo%", new String[] { "TABLE" });
        while (rs.next()) {
            String name = rs.getString(3);  //TABLENAME
            System.out.println("name="+name);
        }
    }

View Full Code Here

    stmt.execute("DATABASE dbcopydest");
  }
  
   private static void test(Connection con)   {
     try {
     DatabaseMetaData md = con.getMetaData();
      String cat = "dbcopydest";
      String schemaPattern = null;
      String typeNamePattern = "%";


      con.setCatalog(cat);
      
      ResultSet rs = md.getUDTs(cat, schemaPattern, typeNamePattern, null);
      while (rs.next()) {
         /*
          * String catalog, String schema, String simpleName
          */
         String catalog = rs.getString(1);

View Full Code Here

 * @author manningr
 */
public class ProgressGetTablesTest {
   
   private static void test(Connection con) throws Exception {
      DatabaseMetaData md = con.getMetaData();
      
      String cat = "DBCOPYDEST";
      String schemaPattern = "MANNINGR";
      String tableNamePattern = "TEST";


      ResultSet rs = md.getTables(cat,
                                  schemaPattern,
                                  tableNamePattern,
                                  new String[] { "TABLE" });
      while (rs.next()) {
         /*

View Full Code Here

  {
    execute(con, dropTable, false);
    execute(con, createTable, true);


    ResultSet rs = null;
    DatabaseMetaData md = con.getMetaData();
    rs = md.getColumns(null, null, tableName, null);
    while (rs.next())
    {
      String tableName = rs.getString(3); // TABLE NAME
      String columnName = rs.getString(4); // COLUMN NAME
      int columnSize = rs.getInt(7); // COLUMN SIZE

View Full Code Here

                                                     .anyTimes();
      expect(md.supportsSchemasInTableDefinitions()).andStubReturn(true);
      expect(md.getCatalogSeparator()).andReturn("").anyTimes();
      expect(md.getIdentifierQuoteString()).andReturn("\"").anyTimes();
      expect(md.getURL()).andReturn(dbURL).anyTimes();
      DatabaseMetaData dbmd = createMock(DatabaseMetaData.class);
      expect(md.getJDBCMetaData()).andReturn(dbmd).anyTimes();
      if (replay) {
         replay(md);
      }
      return md;

View Full Code Here

            value = doResultSetMethod(id, results, method, args);
         }
         else if (methodClass.isAssignableFrom(DatabaseMetaData.class))
         {
            Object id = invocation.getId();
            DatabaseMetaData dbMetaData = (DatabaseMetaData) databaseMetaDataMap.get(id);
            if(dbMetaData == null)
            {
               throw new IllegalAccessException("Failed to find DatabaseMetaData: " + id);
            }
            value = doDatabaseMetaDataMethod(dbMetaData, method, args);

View Full Code Here


      // enable transaction support
      conn.setAutoCommit(false);
      conn.setTransactionIsolation(Connection.TRANSACTION_READ_COMMITTED);


      DatabaseMetaData meta = conn.getMetaData();
      logger.info("Connected to " + connInfo.get("jdbc_url") 
          + ": " + meta.getDatabaseProductName() + " " + meta.getDatabaseProductVersion()
          + " with driver " +  meta.getDriverName() + " " + meta.getDriverVersion());


      return conn;
    } catch (SQLException e) {
      throw new DatabaseConnectionException("Unable to create a connection to: " + connInfo.get("jdbc_url"), e);
    }

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.