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

The following examples show how to use java.sql.DatabaseMetaData#storesMixedCaseIdentifiers() . 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: SqlDialectFactoryImpl.java From Quicksql with MIT License

6 votes

private Casing getCasing(DatabaseMetaData databaseMetaData, boolean quoted) {
  try {
    if (quoted
        ? databaseMetaData.storesUpperCaseQuotedIdentifiers()
        : databaseMetaData.storesUpperCaseIdentifiers()) {
      return Casing.TO_UPPER;
    } else if (quoted
        ? databaseMetaData.storesLowerCaseQuotedIdentifiers()
        : databaseMetaData.storesLowerCaseIdentifiers()) {
      return Casing.TO_LOWER;
    } else if (quoted
        ? (databaseMetaData.storesMixedCaseQuotedIdentifiers()
            || databaseMetaData.supportsMixedCaseQuotedIdentifiers())
        : (databaseMetaData.storesMixedCaseIdentifiers()
            || databaseMetaData.supportsMixedCaseIdentifiers())) {
      return Casing.UNCHANGED;
    } else {
      return Casing.UNCHANGED;
    }
  } catch (SQLException e) {
    throw new IllegalArgumentException("cannot deduce casing", e);
  }
}

Example 2

Source File: SQLIdentifiers.java From netbeans with Apache License 2.0

6 votes

private static int getCaseRule(DatabaseMetaData dbmd) {
    int rule = UC_RULE;

    try {
        if ( dbmd.storesUpperCaseIdentifiers() ) {
            rule = UC_RULE;
        } else if ( dbmd.storesLowerCaseIdentifiers() ) {
            rule = LC_RULE;
        } else if ( dbmd.storesMixedCaseIdentifiers() ) {
            rule = MC_RULE;
        } else {
            rule = UC_RULE;
        }
    } catch ( SQLException sqle ) {
        LOGGER.log(Level.WARNING, "Exception trying to find out how " +
                "the database stores unquoted identifiers, assuming " +
                "upper case: " + sqle.getMessage());
        LOGGER.log(Level.FINE, null, sqle);
    }

    return rule;
}

Example 3

Source File: SqlDialectFactoryImpl.java From calcite with Apache License 2.0

6 votes

private Casing getCasing(DatabaseMetaData databaseMetaData, boolean quoted) {
  try {
    if (quoted
        ? databaseMetaData.storesUpperCaseQuotedIdentifiers()
        : databaseMetaData.storesUpperCaseIdentifiers()) {
      return Casing.TO_UPPER;
    } else if (quoted
        ? databaseMetaData.storesLowerCaseQuotedIdentifiers()
        : databaseMetaData.storesLowerCaseIdentifiers()) {
      return Casing.TO_LOWER;
    } else if (quoted
        ? (databaseMetaData.storesMixedCaseQuotedIdentifiers()
            || databaseMetaData.supportsMixedCaseQuotedIdentifiers())
        : (databaseMetaData.storesMixedCaseIdentifiers()
            || databaseMetaData.supportsMixedCaseIdentifiers())) {
      return Casing.UNCHANGED;
    } else {
      return Casing.UNCHANGED;
    }
  } catch (SQLException e) {
    throw new IllegalArgumentException("cannot deduce casing", e);
  }
}

Example 4

Source File: TableMetaGenerator.java From yugong with GNU General Public License v2.0

5 votes

/**
 * 根据{@linkplain DatabaseMetaData}获取正确的表名
 *
 * <pre>
 * metaData中的storesUpperCaseIdentifiers，storesUpperCaseQuotedIdentifiers，storesLowerCaseIdentifiers,
 * storesLowerCaseQuotedIdentifiers,storesMixedCaseIdentifiers,storesMixedCaseQuotedIdentifiers
 * </pre>
 */
private static String getIdentifierName(String name, DatabaseMetaData metaData) throws SQLException {
    if (metaData.storesMixedCaseIdentifiers()) {
        return name; // 保留原始名
    } else if (metaData.storesUpperCaseIdentifiers()) {
        return StringUtils.upperCase(name);
    } else if (metaData.storesLowerCaseIdentifiers()) {
        return StringUtils.lowerCase(name);
    } else {
        return name;
    }
}