java.sql.DatabaseMetaData#storesLowerCaseIdentifiers

Source File: UKTableMetaData.java From youkefu with Apache License 2.0

6 votes

/**
 * 
 * @param meta
 * @throws SQLException
 */
private void initColumns(DatabaseMetaData meta , boolean upcase) throws SQLException {
	ResultSet rs = null;

	try {
		if (meta.storesUpperCaseIdentifiers()) {
			rs = meta.getColumns(StringHelper.toUpperCase(catalog),
					StringHelper.toUpperCase(schema), StringHelper
							.toUpperCase(name), "%");
		} else if (meta.storesLowerCaseIdentifiers()) {
			rs = meta.getColumns(StringHelper.toLowerCase(catalog),
					StringHelper.toLowerCase(schema), StringHelper
							.toLowerCase(name), "%");
		} else {
			rs = meta.getColumns(catalog, schema, name, "%");
		}
		while (rs.next())
			addColumn(rs , upcase);
	}catch(Exception ex){
		ex.printStackTrace();
	}finally {
		if (rs != null)
			rs.close();
	}
}

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);
  }
}

Source File: MyBatisAccessor.java From jstarcraft-core with Apache License 2.0

6 votes

public synchronized StorageCaseStrategy getCaseStrategy() {
	try {
		if (caseStrategy == null) {
			// 获取表名与列名是否需要转大写或者小写?
			DatabaseMetaData metaData = template.getConnection().getMetaData();
			if (metaData.storesLowerCaseIdentifiers()) {
				caseStrategy = StorageCaseStrategy.LOWER;
			} else if (metaData.storesUpperCaseIdentifiers()) {
				caseStrategy = StorageCaseStrategy.UPPER;
			} else {
				caseStrategy = StorageCaseStrategy.MIXED;
			}
		}
		return caseStrategy;
	} catch (Exception exception) {
		throw new StorageException(exception);
	}
}

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;
}

Source File: MetaDataRegressionTest.java From r-course with MIT License

6 votes

public void testBug31187() throws Exception {
    createTable("testBug31187", "(field1 int)");

    Connection nullCatConn = getConnectionWithProps("nullCatalogMeansCurrent=false");
    DatabaseMetaData dbmd = nullCatConn.getMetaData();
    ResultSet dbTblCols = dbmd.getColumns(null, null, "testBug31187", "%");

    boolean found = false;

    while (dbTblCols.next()) {
        String catalog = dbTblCols.getString("TABLE_CAT");
        String table = dbTblCols.getString("TABLE_NAME");
        boolean useLowerCaseTableNames = dbmd.storesLowerCaseIdentifiers();

        if (catalog.equals(nullCatConn.getCatalog())
                && (((useLowerCaseTableNames && "testBug31187".equalsIgnoreCase(table)) || "testBug31187".equals(table)))) {
            found = true;
        }
    }

    assertTrue("Didn't find any columns for table named 'testBug31187' in database " + this.conn.getCatalog(), found);
}

Source File: MetaDataRegressionTest.java From Komondor with GNU General Public License v3.0

6 votes

public void testBug31187() throws Exception {
    createTable("testBug31187", "(field1 int)");

    Connection nullCatConn = getConnectionWithProps("nullCatalogMeansCurrent=false");
    DatabaseMetaData dbmd = nullCatConn.getMetaData();
    ResultSet dbTblCols = dbmd.getColumns(null, null, "testBug31187", "%");

    boolean found = false;

    while (dbTblCols.next()) {
        String catalog = dbTblCols.getString("TABLE_CAT");
        String table = dbTblCols.getString("TABLE_NAME");
        boolean useLowerCaseTableNames = dbmd.storesLowerCaseIdentifiers();

        if (catalog.equals(nullCatConn.getCatalog())
                && (((useLowerCaseTableNames && "testBug31187".equalsIgnoreCase(table)) || "testBug31187".equals(table)))) {
            found = true;
        }
    }

    assertTrue("Didn't find any columns for table named 'testBug31187' in database " + this.conn.getCatalog(), found);
}

Source File: DatabaseUtil.java From scipio-erp with Apache License 2.0

6 votes

public String getSchemaName(DatabaseMetaData dbData) throws SQLException {
    if (!isLegacy && this.datasourceInfo.getUseSchemas() && dbData.supportsSchemasInTableDefinitions()) {
        if (UtilValidate.isNotEmpty(this.datasourceInfo.getSchemaName())) {
            if (dbData.storesLowerCaseIdentifiers()) {
                return this.datasourceInfo.getSchemaName().toLowerCase();
            } else if (dbData.storesUpperCaseIdentifiers()) {
                return this.datasourceInfo.getSchemaName().toUpperCase();
            } else {
                return this.datasourceInfo.getSchemaName();
            }
        } else {
            return dbData.getUserName();
        }
    }
    return null;
}

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);
  }
}

Source File: MetadataSource.java From sis with Apache License 2.0

6 votes

/**
 * If the metadata schema does not exist in the database, creates it and inserts the pre-defined metadata values.
 * The current implementation has the following restrictions:
 *
 * <ul>
 *   <li>Metadata standard must be {@link MetadataStandard#ISO_19115} or compatible.</li>
 *   <li>The schema name must be {@code "metadata"}, as this is the name used unquoted in SQL scripts.</li>
 * </ul>
 *
 * Maintenance note: this method is invoked by reflection in {@code non-free:sis-embedded-data} module.
 * If we make this method public in a future Apache SIS version, then we can remove the reflection code.
 *
 * @throws SQLException if an error occurred while inserting the metadata.
 */
final synchronized void install() throws IOException, SQLException {
    final Connection connection = connection();
    final DatabaseMetaData md = connection.getMetaData();
    if (md.storesUpperCaseIdentifiers()) {
        schema = schema.toUpperCase(Locale.US);
    } else if (md.storesLowerCaseIdentifiers()) {
        schema = schema.toLowerCase(Locale.US);
    }
    quoteSchema = false;
    try (ResultSet result = md.getTables(catalog, schema, "Citation", null)) {
        if (result.next()) {
            return;
        }
    }
    final Installer installer = new Installer(connection);
    installer.run();
}

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

5 votes

@Override
public int getColumnStringLength(String tableName, String columnName) throws DatabaseInformationException {
	columnName = columnName.toUpperCase();
	
	TableAndColumn tableAndColumn = new TableAndColumn(tableName, columnName);
	Integer columnLength = columnLengthMap.get(tableAndColumn);
	
	if(columnLength != null) {
		return columnLength;
	} else {
		try(Connection connection = datasource.getConnection()) {
			DatabaseMetaData metaData = connection.getMetaData();

			if (metaData.storesLowerCaseIdentifiers()) {
				tableName = tableName.toLowerCase();
			} else if (metaData.storesUpperCaseIdentifiers()) {
				tableName = tableName.toUpperCase();
			}

			try(ResultSet resultSet = metaData.getColumns(null, null, tableName, columnName)) {
				if(!resultSet.next()) {
					throw new UnknownTableOrColumnException(tableName, columnName);
				}
				
				int length = resultSet.getInt("COLUMN_SIZE");		// According to JDBC API, "COLUMN_SIZE" has type "int"
				
				if(resultSet.next()) {
					throw new TooMuchColumnsException(tableName, columnName);
				}
				
				columnLengthMap.put(tableAndColumn, length);
				
				return length;
			}
		} catch(SQLException e) {
			throw new DatabaseInformationException(String.format("Error reading column information (table: %s, column: %s)", tableName, columnName), e);
		}
	}
}

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;
    }
}

Source File: DBMetadataUtils.java From DBMetadata with MIT License

5 votes

private void initLetterCase() {
    try {
        DatabaseMetaData databaseMetaData = getConnection().getMetaData();
        if (databaseMetaData.storesLowerCaseIdentifiers()) {
            letterCase = LetterCase.LOWER;
        } else if (databaseMetaData.storesUpperCaseIdentifiers()) {
            letterCase = LetterCase.UPPER;
        } else {
            letterCase = LetterCase.NORMAL;
        }
    } catch (SQLException e) {
        throw new RuntimeException(e);
    }
}

Source File: Analyzer.java From sis with Apache License 2.0

5 votes

/**
 * Creates a new analyzer for the database described by given metadata.
 *
 * @param  source     the data source, usually given by user at {@code SQLStore} creation time.
 * @param  metadata   Value of {@code source.getConnection().getMetaData()}.
 * @param  listeners  Value of {@code SQLStore.listeners}.
 * @param  locale     Value of {@code SQLStore.getLocale()}.
 */
Analyzer(final DataSource source, final DatabaseMetaData metadata, final StoreListeners listeners,
         final Locale locale) throws SQLException
{
    this.source      = source;
    this.metadata    = metadata;
    this.listeners   = listeners;
    this.locale      = locale;
    this.strings     = new HashMap<>();
    this.escape      = metadata.getSearchStringEscape();
    this.functions   = new SpatialFunctions(metadata);
    this.nameFactory = DefaultFactories.forBuildin(NameFactory.class);
    /*
     * The following tables are defined by ISO 19125 / OGC Simple feature access part 2.
     * Note that the standard specified those names in upper-case letters, which is also
     * the default case specified by the SQL standard.  However some databases use lower
     * cases instead.
     */
    String crs  = "SPATIAL_REF_SYS";
    String geom = "GEOMETRY_COLUMNS";
    if (metadata.storesLowerCaseIdentifiers()) {
        crs  = crs .toLowerCase(Locale.US).intern();
        geom = geom.toLowerCase(Locale.US).intern();
    }
    ignoredTables = new HashSet<>(4);
    ignoredTables.add(crs);
    ignoredTables.add(geom);
    final Dialect dialect = Dialect.guess(metadata);
    if (dialect == Dialect.POSTGRESQL) {
        ignoredTables.add("geography_columns");     // Postgis 1+
        ignoredTables.add("raster_columns");        // Postgis 2
        ignoredTables.add("raster_overviews");
    }
    /*
     * Information to be collected during table analysis.
     */
    tables   = new HashMap<>();
    warnings = new LinkedHashSet<>();
}

Source File: IdentifierHelperBuilder.java From lams with GNU General Public License v2.0

4 votes

public void applyIdentifierCasing(DatabaseMetaData metaData) throws SQLException {
	if ( metaData == null ) {
		return;
	}

	final int unquotedAffirmatives = ArrayHelper.countTrue(
			metaData.storesLowerCaseIdentifiers(),
			metaData.storesUpperCaseIdentifiers(),
			metaData.storesMixedCaseIdentifiers()
	);

	if ( unquotedAffirmatives == 0 ) {
		log.debug( "JDBC driver metadata reported database stores unquoted identifiers in neither upper, lower nor mixed case" );
	}
	else {
		// NOTE : still "dodgy" if more than one is true
		if ( unquotedAffirmatives > 1 ) {
			log.debug( "JDBC driver metadata reported database stores unquoted identifiers in more than one case" );
		}

		if ( metaData.storesUpperCaseIdentifiers() ) {
			this.unquotedCaseStrategy = IdentifierCaseStrategy.UPPER;
		}
		else if ( metaData.storesLowerCaseIdentifiers() ) {
			this.unquotedCaseStrategy = IdentifierCaseStrategy.LOWER;
		}
		else {
			this.unquotedCaseStrategy = IdentifierCaseStrategy.MIXED;
		}
	}


	final int quotedAffirmatives = ArrayHelper.countTrue(
			metaData.storesLowerCaseQuotedIdentifiers(),
			metaData.storesUpperCaseQuotedIdentifiers(),
			metaData.storesMixedCaseQuotedIdentifiers()
	);

	if ( quotedAffirmatives == 0 ) {
		log.debug( "JDBC driver metadata reported database stores quoted identifiers in neither upper, lower nor mixed case" );
	}
	else {
		// NOTE : still "dodgy" if more than one is true
		if ( quotedAffirmatives > 1 ) {
			log.debug( "JDBC driver metadata reported database stores quoted identifiers in more than one case" );
		}

		if ( metaData.storesMixedCaseQuotedIdentifiers() ) {
			this.quotedCaseStrategy = IdentifierCaseStrategy.MIXED;
		}
		else if ( metaData.storesLowerCaseQuotedIdentifiers() ) {
			this.quotedCaseStrategy = IdentifierCaseStrategy.LOWER;
		}
		else {
			this.quotedCaseStrategy = IdentifierCaseStrategy.UPPER;
		}
	}
}

Source File: FrameworkUtils.java From carbon-identity-framework with Apache License 2.0

4 votes

/**
 * Check whether the specified column of the specified table exists in the Identity database.
 *
 * @param tableName name of the table.
 * @param columnName name of the column.
 * @return true if column exists.
 */
public static boolean isTableColumnExists(String tableName, String columnName) {

    try (Connection connection = IdentityDatabaseUtil.getDBConnection()) {

        DatabaseMetaData metaData = connection.getMetaData();
        if (metaData.storesLowerCaseIdentifiers()) {
            tableName = tableName.toLowerCase();
            columnName = columnName.toLowerCase();
        }

        String schemaPattern = null;
        if (metaData.getDriverName().contains("Oracle")){
            if (log.isDebugEnabled()) {
                log.debug("DB type detected as Oracle. Setting schemaPattern to " + metaData.getUserName());
            }
            // Oracle checks the availability of the table column
            // in all users in the DB unless specified.
            schemaPattern = metaData.getUserName();
        }
        try (ResultSet resultSet = metaData.getColumns(null, schemaPattern, tableName, columnName)) {
            if (resultSet.next()) {
                if (log.isDebugEnabled()) {
                    log.debug("Column - " + columnName + " in table - " + tableName + " is available in the " +
                            "Identity database.");
                }
                IdentityDatabaseUtil.commitTransaction(connection);
                return true;
            }
            IdentityDatabaseUtil.commitTransaction(connection);
        } catch (SQLException ex) {
            IdentityDatabaseUtil.rollbackTransaction(connection);
            if (log.isDebugEnabled()) {
                log.debug("Column - " + columnName + " in table - " + tableName + " is not available in the " +
                        "Identity database.");
            }
            return false;
        }

    } catch (SQLException e) {
        if (log.isDebugEnabled()) {
            log.debug("Column - " + columnName + " in table - " + tableName + " is not available in the " +
                    "Identity database.");
        }
        return false;
    }
    if (log.isDebugEnabled()) {
        log.debug("Column - " + columnName + " in table - " + tableName + " is not available in the " +
                "Identity database.");
    }
    return false;
}

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