Java Code Examples for java.sql.Connection#getMetaData()

The following examples show how to use java.sql.Connection#getMetaData() . These examples are extracted from open source projects. 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 Project: ermasterr File: ImportFromDBManagerBase.java License: Apache License 2.0

6 votes

public static void main(final String[] args) throws InputException, InstantiationException, IllegalAccessException, SQLException {
    new ERDiagramActivator();

    final DBSetting setting = new DBSetting("Oracle", "localhost", 1521, "XE", "nakajima", "nakajima", true, null, null);

    Connection con = null;
    try {
        con = setting.connect();
        final DatabaseMetaData metaData = con.getMetaData();

        metaData.getIndexInfo(null, "SYS", "ALERT_QT", false, false);

    } finally {
        if (con != null) {
            con.close();
        }
    }
}

Example 2

Source Project: jsqsh File: Show.java License: Apache License 2.0

6 votes

private ResultSet doPrimaryKeys(Session session, Connection con, Options options)
    throws SQLException {
    
    if (options.arguments.size() != 3
        || !options.arguments.get(1).equalsIgnoreCase("keys")) {
        
        session.err.println("Use: \\show primary keys [[catalog.]schema.]table");
        return null;
    }
    
    SQLConnectionContext ctx = (SQLConnectionContext) session.getConnectionContext();
    SQLObjectName name = new SQLObjectName(ctx, options.arguments.get(2));
    
    DatabaseMetaData meta = con.getMetaData();
    return meta.getPrimaryKeys(
        (options.catalog != null ? options.catalog : name.getCatalog()),
        (options.schemaPattern != null ? options.schemaPattern : name.getSchema()),
        (options.tablePattern != null ? options.tablePattern : name.getName()));
}

Example 3

Source Project: linstor-server File: MigrationUtils.java License: GNU General Public License v3.0

6 votes

public static boolean columnExists(Connection connection, String tableName, String columnName)
    throws SQLException
{
    boolean exists = false;

    DatabaseMetaData metaData = connection.getMetaData();

    // Fetch all columns in order to do a case-insensitive search
    ResultSet res = metaData.getColumns(null, DbConstants.DATABASE_SCHEMA_NAME, null, null);

    while (res.next())
    {
        String resTableName = res.getString(META_COL_TABLE_NAME);
        String resColumnName = res.getString(META_COL_COLUMN_NAME);
        if (tableName.equalsIgnoreCase(resTableName) && columnName.equalsIgnoreCase(resColumnName))
        {
            exists = true;
        }
    }

    return exists;
}

Example 4

Source Project: doma-gen File: TableMetaReader.java License: Apache License 2.0

6 votes

/**
 * テーブルメタデータを読み取ります。
 *
 * @return テーブルメタデータ
 */
public List<TableMeta> read() {
  Connection con = JdbcUtil.getConnection(dataSource);
  try {
    DatabaseMetaData metaData = con.getMetaData();
    List<TableMeta> tableMetas =
        getTableMetas(metaData, schemaName != null ? schemaName : getDefaultSchemaName(metaData));
    for (TableMeta tableMeta : tableMetas) {
      Set<String> primaryKeySet = getPrimaryKeys(metaData, tableMeta);
      handleColumnMeta(metaData, tableMeta, primaryKeySet);
    }
    if (dialect.isJdbcCommentUnavailable()) {
      readCommentFromDictinary(con, tableMetas);
    }
    return tableMetas;
  } catch (SQLException e) {
    throw new GenException(Message.DOMAGEN9001, e, e);
  } finally {
    JdbcUtil.close(con);
  }
}

Example 5

Source Project: gemfirexd-oss File: DerbyNetAutoStart.java License: Apache License 2.0

6 votes

private static void checkConn( Connection conn, String label)
{
    try
    {
        DatabaseMetaData dbmd = conn.getMetaData();
        ResultSet rs = dbmd.getSchemas();
        while( rs.next());
        rs.close();
    }
    catch( SQLException sqle)
    {
        passed = false;
        System.out.println( "Could not use the " + label + " connection:");
        System.out.println( "  " + sqle.getMessage());
    }
}

Example 6

Source Project: activemq-artemis File: PropertySQLProvider.java License: Apache License 2.0

6 votes

public static SQLDialect investigateDialect(Connection connection) {
   SQLDialect dialect = null;
   try {
      DatabaseMetaData metaData = connection.getMetaData();
      String dbProduct = metaData.getDatabaseProductName();
      dialect = identifyDialect(dbProduct);

      if (dialect == null) {
         logger.debug("Attempting to guess on driver name.");
         dialect = identifyDialect(metaData.getDriverName());
      }
      if (dialect == null) {
         logger.warnf("Unable to detect database dialect from connection metadata or JDBC driver name.");
      } else {
         logger.debugf("Detect database dialect as '%s'.", dialect);
      }
   } catch (Exception e) {
      logger.debug("Unable to read JDBC metadata.", e);
   }
   return dialect;
}

Example 7

Source Project: jboss-daytrader File: TradeJEEDirect.java License: Apache License 2.0

6 votes

public String checkDBProductName() throws Exception {
    Connection conn = null;
    String dbProductName = null;

    try {
        if (Log.doTrace())
            Log.traceEnter("TradeDirect:checkDBProductName");

        conn = getConn();
        DatabaseMetaData dbmd = conn.getMetaData();
        dbProductName = dbmd.getDatabaseProductName();
    } catch (SQLException e) {
        Log.error(e, "TradeDirect:checkDBProductName() -- Error checking the Daytrader Database Product Name");
    } finally {
        releaseConn(conn);
    }
    return dbProductName;
}

Example 8

Source Project: openbd-core File: dbInfo.java License: GNU General Public License v3.0

5 votes

private cfData typeIndex(cfSession _session, cfDataSource datasource, String dbname, String table ) throws cfmRunTimeException{
	Connection c = null;
	try {
		c = datasource.getPooledConnection();
		
		DatabaseMetaData metaData = c.getMetaData();
		
		cfQueryResultData queryResult = new cfQueryResultData(new String[] { "index_name", "column_name", "ordinal_position", "cardinality", "type", "pages", "non_unique" }, "DBINFO");
		
		ResultSet rset = metaData.getIndexInfo(dbname, null, table, false, false);
		int row=1;
		while ( rset.next() ){
			queryResult.addRow(1);

			queryResult.setCell(row, 1, new cfStringData(rset.getString(6)) );
			queryResult.setCell(row, 2, new cfStringData(rset.getString(9)) );
			queryResult.setCell(row, 3, new cfStringData(rset.getString(8)) );
			queryResult.setCell(row, 3, new cfStringData(rset.getString(11)) );
			queryResult.setCell(row, 3, new cfStringData(rset.getString(7)) );
			queryResult.setCell(row, 3, new cfStringData(rset.getString(12)) );

			row++;
		}
		rset.close();

		return queryResult;
		
	} catch (SQLException e) {
		throwException(_session,  e.getMessage() );
	} finally {
		datasource.close(c);
	}
	
	return null;
}

Example 9

Source Project: incubator-batchee File: JDBCPersistenceManagerService.java License: Apache License 2.0

5 votes

private void createIfNotExists(final String tableName, final String createTableStatement) throws SQLException {
    final Connection conn = getConnection();
    final DatabaseMetaData dbmd = conn.getMetaData();
    final ResultSet rs = dbmd.getTables(null, schema, tableName, null);

    PreparedStatement ps = null;
    if (!rs.next()) {
        ps = conn.prepareStatement(createTableStatement);
        ps.executeUpdate();
    }

    cleanupConnection(conn, rs, ps);
}

Example 10

Source Project: calcite-avatica File: RemoteDriverTest.java License: Apache License 2.0

5 votes

private void checkDatabaseProperty(Connection connection)
    throws SQLException {
  final DatabaseMetaData metaData = connection.getMetaData();
  assertThat(metaData.getSQLKeywords(), equalTo(""));
  assertThat(metaData.getStringFunctions(),
      equalTo("ASCII,CHAR,CONCAT,DIFFERENCE,HEXTORAW,INSERT,LCASE,LEFT,"
          + "LENGTH,LOCATE,LTRIM,RAWTOHEX,REPEAT,REPLACE,RIGHT,RTRIM,SOUNDEX,"
          + "SPACE,SUBSTR,UCASE"));
  assertThat(metaData.getDefaultTransactionIsolation(),
      equalTo(Connection.TRANSACTION_READ_COMMITTED));
}

Example 11

Source Project: openbd-core File: WrappedConnection.java License: GNU General Public License v3.0

5 votes

public WrappedConnection( Connection con ){
  this.con        	= con;
  activeListener  	= null;
  creationTime			= System.currentTimeMillis();
  validationQuery 	= null;
  
  if ( !validateConnections ) {
  	return;
  }
  
  try {
  	// create validation query
  	DatabaseMetaData dbmd = con.getMetaData();
  	String dbProductName = dbmd.getDatabaseProductName().toLowerCase();
  	
  	if ( ( dbProductName.indexOf( "microsoft" ) >= 0 ) ||
     ( dbProductName.indexOf( "sql server" ) >= 0 ) || // this value is also returned by the BEA driver for sybase
     ( dbProductName.indexOf( "access" ) >= 0 ) ||
     ( dbProductName.indexOf( "adaptive server enterprise" ) >= 0 ) || // sybase using jConnect 5.5 driver
     ( dbProductName.indexOf( "sybase" ) >= 0 ) ) { // this check may not be needed
		validationQuery = "select 1";
	} else if ( dbProductName.indexOf( "oracle" ) >= 0 ) {
		validationQuery = "select sysdate from dual";
	} else if ( ( dbProductName.indexOf( "mysql" ) >= 0 ) ||
				( dbProductName.indexOf( "postgres" ) >= 0 ) ) {
		validationQuery = "select now()";
	} else if ( dbProductName.indexOf( "informix" ) >= 0 ) {
		validationQuery = "select distinct current timestamp from informix.systables";
	} else if ( ( dbProductName.indexOf( "db2" ) >= 0 ) ||
				( dbProductName.indexOf( "ibm" ) >= 0 ) ) { // this check may not be needed
		validationQuery = "select distinct(current timestamp) from sysibm.systables";
	} else if ( dbProductName.indexOf( "pointbase" ) >= 0 ) {
		validationQuery = "select count(*) from systables";
	} else {
		cfEngine.log( "Can't validate connections for " + dbProductName );
	}
  } catch ( SQLException ignore ) {}
}

Example 12

Source Project: open-capacity-platform File: DatabaseStatusChecker.java License: Apache License 2.0

5 votes

public Status check() {
    boolean ok;
    try {
        Connection connection = dataSource.getConnection();
        try {
            DatabaseMetaData metaData = connection.getMetaData();
            ResultSet resultSet = metaData.getTypeInfo();
            try {
                ok = resultSet.next();
            } finally {
                resultSet.close();
            }
            if (message == null) {
                message = metaData.getURL()
                        + " (" + metaData.getDatabaseProductName()
                        + " " + metaData.getDatabaseProductVersion()
                        + ", " + getIsolation(metaData.getDefaultTransactionIsolation()) + ")";
            }
            if (version == 0) {
                version = metaData.getDatabaseMajorVersion();
            }
        } finally {
            connection.close();
        }
    } catch (Throwable e) {
        logger.error(e.getMessage(), e);
        ok = false;
    }
    return new Status(!ok ? Status.Level.ERROR : (version < 5 ? Status.Level.WARN : Status.Level.OK), message);
}

Example 13

Source Project: jeecg-cloud File: SysBaseApiImpl.java License: Apache License 2.0

5 votes

/**
 * 获取数据库类型
 * @param dataSource
 * @return
 * @throws SQLException
 */
private String getDatabaseTypeByDataSource(DataSource dataSource) throws SQLException{
	if("".equals(DB_TYPE)) {
		Connection connection = dataSource.getConnection();
		try {
			DatabaseMetaData md = connection.getMetaData();
			String dbType = md.getDatabaseProductName().toLowerCase();
			if(dbType.indexOf("mysql")>=0) {
				DB_TYPE = DataBaseConstant.DB_TYPE_MYSQL;
			}else if(dbType.indexOf("oracle")>=0) {
				DB_TYPE = DataBaseConstant.DB_TYPE_ORACLE;
			}else if(dbType.indexOf("sqlserver")>=0||dbType.indexOf("sql server")>=0) {
				DB_TYPE = DataBaseConstant.DB_TYPE_SQLSERVER;
			}else if(dbType.indexOf("postgresql")>=0) {
				DB_TYPE = DataBaseConstant.DB_TYPE_POSTGRESQL;
			}else {
				throw new JeecgBootException("数据库类型:["+dbType+"]不识别!");
			}
		} catch (Exception e) {
			log.error(e.getMessage(), e);
		}finally {
			connection.close();
		}
	}
	return DB_TYPE;
	
}

Example 14

Source Project: dubbox File: DatabaseStatusChecker.java License: Apache License 2.0

5 votes

public Status check() {
    boolean ok;
    try {
        Connection connection = dataSource.getConnection();
        try {
            DatabaseMetaData metaData = connection.getMetaData();
            ResultSet resultSet = metaData.getTypeInfo();
            try {
                ok = resultSet.next();
            } finally {
                resultSet.close();
            }
            if (message == null) {
                message = metaData.getURL()
                    + " (" + metaData.getDatabaseProductName() 
                    + " " + metaData.getDatabaseProductVersion()
                    + ", " + getIsolation(metaData.getDefaultTransactionIsolation()) + ")";
            }
            if (version == 0) {
                version = metaData.getDatabaseMajorVersion();
            }
        } finally {
            connection.close();
        }
    } catch (Throwable e) {
        logger.error(e.getMessage(), e);
        ok = false;
    }
    return new Status(! ok ? Status.Level.ERROR : (version < 5 ? Status.Level.WARN : Status.Level.OK), message);
}

Example 15

Source Project: teaching File: SysBaseApiImpl.java License: Apache License 2.0

5 votes

/**
 * 获取数据库类型
 * @param dataSource
 * @return
 * @throws SQLException
 */
private String getDatabaseTypeByDataSource(DataSource dataSource) throws SQLException{
	if("".equals(DB_TYPE)) {
		Connection connection = dataSource.getConnection();
		try {
			DatabaseMetaData md = connection.getMetaData();
			String dbType = md.getDatabaseProductName().toLowerCase();
			if(dbType.indexOf("mysql")>=0) {
				DB_TYPE = DataBaseConstant.DB_TYPE_MYSQL;
			}else if(dbType.indexOf("oracle")>=0) {
				DB_TYPE = DataBaseConstant.DB_TYPE_ORACLE;
			}else if(dbType.indexOf("sqlserver")>=0||dbType.indexOf("sql server")>=0) {
				DB_TYPE = DataBaseConstant.DB_TYPE_SQLSERVER;
			}else if(dbType.indexOf("postgresql")>=0) {
				DB_TYPE = DataBaseConstant.DB_TYPE_POSTGRESQL;
			}else {
				throw new JeecgBootException("数据库类型:["+dbType+"]不识别!");
			}
		} catch (Exception e) {
			log.error(e.getMessage(), e);
		}finally {
			connection.close();
		}
	}
	return DB_TYPE;
	
}

Example 16

Source Project: gemfirexd-oss File: ConcurrentConnTest.java License: Apache License 2.0

5 votes

public static void metadataCalls(Connection conn)
throws Exception
{
  System.out.println("A new connection is doing metadata calls, but never commit...");

  DatabaseMetaData dmd = conn.getMetaData();
  getTypeInfo(dmd,System.out);
  getTables(dmd,System.out);
  getColumnInfo(dmd, "%",System.out);
  getPrimaryKeys(dmd, "%",System.out);
  getExportedKeys(dmd, "%",System.out);

}

Example 17

Source Project: shardingsphere-elasticjob-lite File: RDBJobEventStorage.java License: Apache License 2.0

5 votes

private void createJobExecutionTableAndIndexIfNeeded(final Connection connection) throws SQLException {
    DatabaseMetaData dbMetaData = connection.getMetaData();
    try (ResultSet resultSet = dbMetaData.getTables(connection.getCatalog(), null, TABLE_JOB_EXECUTION_LOG, new String[]{"TABLE"})) {
        if (!resultSet.next()) {
            createJobExecutionTable(connection);
        }
    }
}

Example 18

Source Project: hadoop-ozone File: TestReconInternalSchemaDefinition.java License: Apache License 2.0

4 votes

@Test
public void testReconTaskStatusCRUDOperations() throws Exception {
  // Verify table exists
  Connection connection = getConnection();
  DatabaseMetaData metaData = connection.getMetaData();
  ResultSet resultSet = metaData.getTables(null, null,
      RECON_TASK_STATUS_TABLE_NAME, null);

  while (resultSet.next()) {
    Assert.assertEquals(RECON_TASK_STATUS_TABLE_NAME,
        resultSet.getString("TABLE_NAME"));
  }

  ReconTaskStatusDao dao = getDao(ReconTaskStatusDao.class);
  long now = System.currentTimeMillis();
  ReconTaskStatus newRecord = new ReconTaskStatus();
  newRecord.setTaskName("HelloWorldTask");
  newRecord.setLastUpdatedTimestamp(now);
  newRecord.setLastUpdatedSeqNumber(100L);

  // Create
  dao.insert(newRecord);

  ReconTaskStatus newRecord2 = new ReconTaskStatus();
  newRecord2.setTaskName("GoodbyeWorldTask");
  newRecord2.setLastUpdatedTimestamp(now);
  newRecord2.setLastUpdatedSeqNumber(200L);
  // Create
  dao.insert(newRecord2);

  // Read
  ReconTaskStatus dbRecord = dao.findById("HelloWorldTask");

  Assert.assertEquals("HelloWorldTask", dbRecord.getTaskName());
  Assert.assertEquals(Long.valueOf(now), dbRecord.getLastUpdatedTimestamp());
  Assert.assertEquals(Long.valueOf(100), dbRecord.getLastUpdatedSeqNumber());

  // Update
  dbRecord.setLastUpdatedSeqNumber(150L);
  dao.update(dbRecord);

  // Read updated
  dbRecord = dao.findById("HelloWorldTask");
  Assert.assertEquals(Long.valueOf(150), dbRecord.getLastUpdatedSeqNumber());

  // Delete
  dao.deleteById("GoodbyeWorldTask");

  // Verify
  dbRecord = dao.findById("GoodbyeWorldTask");

  Assert.assertNull(dbRecord);
}

Example 19

Source Project: phoenix File: QueryDatabaseMetaDataIT.java License: Apache License 2.0

4 votes

@Test
public void testPrimaryKeyMetadataScan() throws SQLException {
    long ts = nextTimestamp();
    ensureTableCreated(getUrl(), MDTEST_NAME, null, ts);
    ensureTableCreated(getUrl(), CUSTOM_ENTITY_DATA_FULL_NAME, null, ts);
    Properties props = new Properties();
    props.setProperty(PhoenixRuntime.CURRENT_SCN_ATTRIB, Long.toString(ts + 5));
    Connection conn = DriverManager.getConnection(getUrl(), props);
    DatabaseMetaData dbmd = conn.getMetaData();
    ResultSet rs;
    rs = dbmd.getPrimaryKeys(null, "", MDTEST_NAME);
    assertTrue(rs.next());
    assertEquals(rs.getString("TABLE_SCHEM"),null);
    assertEquals(MDTEST_NAME, rs.getString("TABLE_NAME"));
    assertEquals(null, rs.getString("TABLE_CAT"));
    assertEquals(SchemaUtil.normalizeIdentifier("id"), rs.getString("COLUMN_NAME"));
    assertEquals(1, rs.getInt("KEY_SEQ"));
    assertEquals(null, rs.getString("PK_NAME"));
    assertFalse(rs.next());
    
    rs = dbmd.getPrimaryKeys(null, CUSTOM_ENTITY_DATA_SCHEMA_NAME, CUSTOM_ENTITY_DATA_NAME);
    assertTrue(rs.next());
    assertEquals(CUSTOM_ENTITY_DATA_SCHEMA_NAME, rs.getString("TABLE_SCHEM"));
    assertEquals(CUSTOM_ENTITY_DATA_NAME, rs.getString("TABLE_NAME"));
    assertEquals(null, rs.getString("TABLE_CAT"));
    assertEquals(SchemaUtil.normalizeIdentifier("custom_entity_data_id"), rs.getString("COLUMN_NAME"));
    assertEquals(3, rs.getInt("KEY_SEQ"));
    assertEquals(SchemaUtil.normalizeIdentifier("pk"), rs.getString("PK_NAME"));

    assertTrue(rs.next());
    assertEquals(CUSTOM_ENTITY_DATA_SCHEMA_NAME, rs.getString("TABLE_SCHEM"));
    assertEquals(CUSTOM_ENTITY_DATA_NAME, rs.getString("TABLE_NAME"));
    assertEquals(null, rs.getString("TABLE_CAT"));
    assertEquals(SchemaUtil.normalizeIdentifier("key_prefix"), rs.getString("COLUMN_NAME"));
    assertEquals(2, rs.getInt("KEY_SEQ"));
    assertEquals(SchemaUtil.normalizeIdentifier("pk"), rs.getString("PK_NAME"));
    
    assertTrue(rs.next());
    assertEquals(CUSTOM_ENTITY_DATA_SCHEMA_NAME, rs.getString("TABLE_SCHEM"));
    assertEquals(CUSTOM_ENTITY_DATA_NAME, rs.getString("TABLE_NAME"));
    assertEquals(null, rs.getString("TABLE_CAT"));
    assertEquals(SchemaUtil.normalizeIdentifier("organization_id"), rs.getString("COLUMN_NAME"));
    assertEquals(1, rs.getInt("KEY_SEQ"));
    assertEquals(SchemaUtil.normalizeIdentifier("pk"), rs.getString("PK_NAME")); // TODO: this is on the table row
    
    assertFalse(rs.next());

    rs = dbmd.getColumns("", CUSTOM_ENTITY_DATA_SCHEMA_NAME, CUSTOM_ENTITY_DATA_NAME, null);
    assertTrue(rs.next());
    assertEquals(CUSTOM_ENTITY_DATA_SCHEMA_NAME, rs.getString("TABLE_SCHEM"));
    assertEquals(CUSTOM_ENTITY_DATA_NAME, rs.getString("TABLE_NAME"));
    assertEquals(null, rs.getString("TABLE_CAT"));
    assertEquals(SchemaUtil.normalizeIdentifier("organization_id"), rs.getString("COLUMN_NAME"));
    assertEquals(rs.getInt("COLUMN_SIZE"), 15);
    
    assertTrue(rs.next());
    assertEquals(CUSTOM_ENTITY_DATA_SCHEMA_NAME, rs.getString("TABLE_SCHEM"));
    assertEquals(CUSTOM_ENTITY_DATA_NAME, rs.getString("TABLE_NAME"));
    assertEquals(null, rs.getString("TABLE_CAT"));
    assertEquals(SchemaUtil.normalizeIdentifier("key_prefix"), rs.getString("COLUMN_NAME"));
    assertEquals(rs.getInt("COLUMN_SIZE"), 3);
    
    assertTrue(rs.next());
    assertEquals(CUSTOM_ENTITY_DATA_SCHEMA_NAME, rs.getString("TABLE_SCHEM"));
    assertEquals(CUSTOM_ENTITY_DATA_NAME, rs.getString("TABLE_NAME"));
    assertEquals(null, rs.getString("TABLE_CAT"));
    assertEquals(SchemaUtil.normalizeIdentifier("custom_entity_data_id"), rs.getString("COLUMN_NAME"));
    
    // The above returns all columns, starting with the PK columns
    assertTrue(rs.next());
    
    rs = dbmd.getColumns("", CUSTOM_ENTITY_DATA_SCHEMA_NAME, CUSTOM_ENTITY_DATA_NAME, "KEY_PREFIX");
    assertTrue(rs.next());
    assertEquals(CUSTOM_ENTITY_DATA_SCHEMA_NAME, rs.getString("TABLE_SCHEM"));
    assertEquals(CUSTOM_ENTITY_DATA_NAME, rs.getString("TABLE_NAME"));
    assertEquals(null, rs.getString("TABLE_CAT"));
    assertEquals(SchemaUtil.normalizeIdentifier("key_prefix"), rs.getString("COLUMN_NAME"));
    
    rs = dbmd.getColumns("", CUSTOM_ENTITY_DATA_SCHEMA_NAME, CUSTOM_ENTITY_DATA_NAME, "KEY_PREFIX");
    assertTrue(rs.next());
    assertEquals(CUSTOM_ENTITY_DATA_SCHEMA_NAME, rs.getString("TABLE_SCHEM"));
    assertEquals(CUSTOM_ENTITY_DATA_NAME, rs.getString("TABLE_NAME"));
    assertEquals(null, rs.getString("TABLE_CAT"));
    assertEquals(SchemaUtil.normalizeIdentifier("key_prefix"), rs.getString("COLUMN_NAME"));
    
    assertFalse(rs.next());
    
}

Example 20

Source Project: tomee File: AlternateDriverJarEmbeddedDemo.java License: Apache License 2.0

4 votes

public String getDriverVersion() throws Exception {

            final Connection con = ds.getConnection();
            final DatabaseMetaData md = con.getMetaData();
            return md.getDriverVersion();
        }