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

The following examples show how to use java.sql.DatabaseMetaData#getURL() . 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

/**
 * getURL() method. Note that this method
 * is the only JDBC 3 DatabaseMetaData method
 * that is dropped in JSR169.
 */
public void testGetURL() throws SQLException
{
    DatabaseMetaData dmd = getDMD();

    String url;
    try {
        url = dmd.getURL();
    } catch (NoSuchMethodError e) {
        // JSR 169 - method must not be there!
        assertTrue("getURL not supported", JDBC.vmSupportsJSR169());
        assertFalse("getURL not supported", JDBC.vmSupportsJDBC2());
        return;
    }

    assertFalse("getURL is supported!", JDBC.vmSupportsJSR169());
    assertTrue("getURL is supported!", JDBC.vmSupportsJDBC2());

    assertEquals("getURL match",
            getTestConfiguration().getJDBCUrl(),
            url);
}

Example 2

Source File: DatabaseInformations.java From javamelody with Apache License 2.0

6 votes

static Database getDatabaseForConnection(Connection connection) throws SQLException {
	final DatabaseMetaData metaData = connection.getMetaData();
	final String databaseName = metaData.getDatabaseProductName();
	final String url = metaData.getURL();
	for (final Database database : Database.values()) {
		if (database.isRecognized(databaseName, url)) {
			if (database == MYSQL && metaData.getDatabaseMajorVersion() <= 4) {
				// si mysql et version 4 alors c'est MYSQL4 et non MYSQL
				return MYSQL4;
			}
			return database;
		}
	}
	throw new IllegalArgumentException(
			I18N.getFormattedString("type_base_de_donnees_inconnu", databaseName));
}

Example 3

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

6 votes

/**
 * getURL() method. Note that this method
 * is the only JDBC 3 DatabaseMetaData method
 * that is dropped in JSR169.
 */
public void testGetURL() throws SQLException
{
    DatabaseMetaData dmd = getDMD();

    String url;
    try {
        url = dmd.getURL();
    } catch (NoSuchMethodError e) {
        // JSR 169 - method must not be there!
        assertTrue("getURL not supported", JDBC.vmSupportsJSR169());
        assertFalse("getURL not supported", JDBC.vmSupportsJDBC2());
        return;
    }

    assertFalse("getURL is supported!", JDBC.vmSupportsJSR169());
    assertTrue("getURL is supported!", JDBC.vmSupportsJDBC2());

    assertEquals("getURL match",
            getTestConfiguration().getJDBCUrl(),
            url);
}

Example 4

Source File: Kingbase8DictionaryBack.java From o2oa with GNU Affero General Public License v3.0

6 votes

public void connectedConfiguration(Connection conn) throws SQLException {
	super.connectedConfiguration(conn);
	boolean requiresWarnings = true;
	DatabaseMetaData meta = conn.getMetaData();
	String driverName = meta.getDriverName();
	String url = meta.getURL();
	if (this.driverVendor == null) {
		if ((driverName != null) && (driverName.equalsIgnoreCase("com.kingbase8.Driver"))) {
			this.driverVendor = "Kingbase8JdbcDriver";
			if ((url != null) && (url.startsWith("jdbc:kingbase8://"))) {
				requiresWarnings = false;
			}
		} else {
			this.driverVendor = "other";
		}
	}
	if (("Kingbase8JdbcDriver".equalsIgnoreCase(this.driverVendor)) && (requiresWarnings)) {
		this.log.warn(_loc.get("kingbase8 Jdbc connection", url));
	}
}

Example 5

Source File: JdbcFacade.java From iaf with Apache License 2.0

6 votes

/**
 * Returns the name and location of the database that this objects operates on.
 * 
 * @see nl.nn.adapterframework.core.HasPhysicalDestination#getPhysicalDestinationName()
 */
@Override
public String getPhysicalDestinationName() {
	String result="unknown";
	try (Connection connection = getConnection()) {
		DatabaseMetaData metadata = connection.getMetaData();
		result = metadata.getURL();

		String catalog=null;
		catalog=connection.getCatalog();
		result += catalog!=null ? ("/"+catalog):"";
	} catch (Exception e) {
		log.warn(getLogPrefix()+"exception retrieving PhysicalDestinationName", e);
	}
	return result;
}

Example 6

Source File: KingbaseDictionary.java From o2oa with GNU Affero General Public License v3.0

6 votes

public void connectedConfiguration(Connection conn) throws SQLException {
	super.connectedConfiguration(conn);
	boolean requiresWarnings = true;
	DatabaseMetaData meta = conn.getMetaData();
	String driverName = meta.getDriverName();
	String url = meta.getURL();
	if (this.driverVendor == null) {
		if ((driverName != null) && (driverName.equalsIgnoreCase("com.kingbase.Driver"))) {
			this.driverVendor = "KingbaseJdbcDriver";
			if ((url != null) && (url.startsWith("jdbc:kingbase://"))) {
				requiresWarnings = false;
			}
		} else {
			this.driverVendor = "other";
		}
	}
	if (("KingbaseJdbcDriver".equalsIgnoreCase(this.driverVendor)) && (requiresWarnings)) {
		this.log.warn(_loc.get("kingbase Jdbc connection", url));
	}
}

Example 7

Source File: DbMeta.java From das with Apache License 2.0

6 votes

private DbMeta(Connection conn, String realDbName, DatabaseCategory dbCategory) throws SQLException {
    dataBaseKeyName = realDbName;
    this.dbCategory = dbCategory;

    try {
        DatabaseMetaData meta = conn.getMetaData();
        databaseName = conn.getCatalog();
        url = meta.getURL();
        host = parseHostFromDBURL(url);

        userName = null;
        if(configureLocator == null) {
            userName = DataSourceLocator.getDataSourceConfigure(realDbName).getUserName();
        }else {
            userName = configureLocator.getDataSourceConfigure(realDbName).getUserName();
        }
    } catch (Throwable e) {
    }
}

Example 8

Source File: DbUtilities.java From openemm with GNU Affero General Public License v3.0

5 votes

public static String getDbUrl(Connection connection) {
	try {
		DatabaseMetaData databaseMetaData = connection.getMetaData();
		if (databaseMetaData != null) {
			return databaseMetaData.getURL();
		} else {
			return null;
		}
	} catch (SQLException e) {
		return null;
	}
}

Example 9

Source File: DatabaseStatusChecker.java From dubbox with 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 10

Source File: DBInformation.java From cloud-spring-boot-sample with Apache License 2.0

5 votes

public DBInformation(DatabaseMetaData metaData) throws SQLException
{
	url = metaData.getURL();
	dbName = metaData.getDatabaseProductName();
	dbMajorVersion = metaData.getDatabaseMajorVersion();
	dbMinorVersion = metaData.getDatabaseMinorVersion();

	driverName = metaData.getDriverName();
	driverVersion = metaData.getDriverVersion();

	userName = metaData.getUserName();
}

Example 11

Source File: DatabaseStatusChecker.java From dubbox-hystrix with 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 12

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

5 votes

private void checkDBMetadata(Connection conn, String url) throws Exception {
  DatabaseMetaData dbmd = conn.getMetaData();
  String actualUrl = dbmd.getURL();
  // remove any trailing slash
  getLogWriter().info("Got DB " + dbmd.getDatabaseProductName() + ' '
      + dbmd.getDatabaseProductVersion() + " using URL " + actualUrl);
  assertEquals("Expected the provided URL to match", url.replaceFirst("/$",
      ""), actualUrl.replaceFirst("/$", ""));
  ResultSet rs = dbmd.getCatalogs();
  while (rs.next()) {
    getLogWriter().info("Got DB catalog: " + rs.getString(1));
  }
  rs.close();
  rs = dbmd.getSchemas();
  while (rs.next()) {
    getLogWriter().info("Got DB schema: " + rs.getString(1)
        + " in catalog=" + rs.getString(2));
  }
  rs.close();
  rs = dbmd.getProcedures(null, null, null);
  while (rs.next()) {
    getLogWriter().info("Got Procedure " + rs.getString(3) + " in catalog="
        + rs.getString(1) + ", schema=" + rs.getString(2));
  }
  rs.close();
  // also check for a few flags that are failing over network connection
  assertTrue(dbmd.othersInsertsAreVisible(ResultSet.TYPE_FORWARD_ONLY));
  assertTrue(dbmd.othersDeletesAreVisible(ResultSet.TYPE_FORWARD_ONLY));
}

Example 13

Source File: HerokuDatabasePropertiesProviderResourceTest.java From tomee with Apache License 2.0

5 votes

@Test
public void herokuToJava() throws Exception {
    assertNotNull(db);

    final Connection connection = db.getConnection();
    final DatabaseMetaData metaData = connection.getMetaData();
    final String url = metaData.getURL();
    assertTrue(url.startsWith("jdbc:hsqldb:hsql://localhost:"));
    assertTrue(url.endsWith("/adb"));
    assertEquals("SA", metaData.getUserName());
    connection.close();
}

Example 14

Source File: DatabaseStatusChecker.java From dubbox with 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 File: ClientServerDUnit.java From gemfirexd-oss with Apache License 2.0

5 votes

private void checkDBMetadata(Connection conn, String url) throws Exception {
  DatabaseMetaData dbmd = conn.getMetaData();
  String actualUrl = dbmd.getURL();
  // remove any trailing slash
  getLogWriter().info("Got DB " + dbmd.getDatabaseProductName() + ' '
      + dbmd.getDatabaseProductVersion() + " using URL " + actualUrl);
  assertEquals("Expected the provided URL to match", url.replaceFirst("/$",
      ""), actualUrl.replaceFirst("/$", ""));
  ResultSet rs = dbmd.getCatalogs();
  while (rs.next()) {
    getLogWriter().info("Got DB catalog: " + rs.getString(1));
  }
  rs.close();
  rs = dbmd.getSchemas();
  while (rs.next()) {
    getLogWriter().info("Got DB schema: " + rs.getString(1)
        + " in catalog=" + rs.getString(2));
  }
  rs.close();
  rs = dbmd.getProcedures(null, null, null);
  while (rs.next()) {
    getLogWriter().info("Got Procedure " + rs.getString(3) + " in catalog="
        + rs.getString(1) + ", schema=" + rs.getString(2));
  }
  rs.close();
  // also check for a few flags that are failing over network connection
  assertTrue(dbmd.othersInsertsAreVisible(ResultSet.TYPE_FORWARD_ONLY));
  assertTrue(dbmd.othersDeletesAreVisible(ResultSet.TYPE_FORWARD_ONLY));
}

Example 16

Source File: DatabaseStatusChecker.java From open-capacity-platform with 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 17

Source File: DatabaseStatusChecker.java From dubbo3 with 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 18

Source File: DatabaseStatusChecker.java From dubbo3 with 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 19

Source File: DatabaseStatusChecker.java From dubbox with 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 20

Source File: DatabaseStatusChecker.java From dubbox with 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);
}