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

The following examples show how to use java.sql.Connection#getMetaData() . 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: MigrationUtils.java    From linstor-server with GNU General Public License v3.0 6 votes vote down vote up
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 2
Source File: TradeJEEDirect.java    From jboss-daytrader with Apache License 2.0 6 votes vote down vote up
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 3
Source File: PropertySQLProvider.java    From activemq-artemis with Apache License 2.0 6 votes vote down vote up
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 4
Source File: DerbyNetAutoStart.java    From gemfirexd-oss with Apache License 2.0 6 votes vote down vote up
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 5
Source File: TableMetaReader.java    From doma-gen with Apache License 2.0 6 votes vote down vote up
/**
 * テーブルメタデータを読み取ります。
 *
 * @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 6
Source File: Show.java    From jsqsh with Apache License 2.0 6 votes vote down vote up
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 7
Source File: ImportFromDBManagerBase.java    From ermasterr with Apache License 2.0 6 votes vote down vote up
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 8
Source File: SysBaseApiImpl.java    From jeecg-cloud with Apache License 2.0 5 votes vote down vote up
/**
 * 获取数据库类型
 * @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 9
Source File: DatabaseStatusChecker.java    From open-capacity-platform with Apache License 2.0 5 votes vote down vote up
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 10
Source File: DatabaseStatusChecker.java    From dubbox with Apache License 2.0 5 votes vote down vote up
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 11
Source File: dbInfo.java    From openbd-core with GNU General Public License v3.0 5 votes vote down vote up
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 12
Source File: WrappedConnection.java    From openbd-core with GNU General Public License v3.0 5 votes vote down vote up
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 13
Source File: SysBaseApiImpl.java    From teaching with Apache License 2.0 5 votes vote down vote up
/**
 * 获取数据库类型
 * @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 File: RemoteDriverTest.java    From calcite-avatica with Apache License 2.0 5 votes vote down vote up
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 15
Source File: ConcurrentConnTest.java    From gemfirexd-oss with Apache License 2.0 5 votes vote down vote up
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 16
Source File: RDBJobEventStorage.java    From shardingsphere-elasticjob-lite with Apache License 2.0 5 votes vote down vote up
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 17
Source File: JDBCPersistenceManagerService.java    From incubator-batchee with Apache License 2.0 5 votes vote down vote up
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 18
Source File: TestReconInternalSchemaDefinition.java    From hadoop-ozone with Apache License 2.0 4 votes vote down vote up
@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 File: QueryDatabaseMetaDataIT.java    From phoenix with Apache License 2.0 4 votes vote down vote up
@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 File: AlternateDriverJarEmbeddedDemo.java    From tomee with Apache License 2.0 4 votes vote down vote up
public String getDriverVersion() throws Exception {

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