identifiers = Identifiers.identifiers().withConnection(connection) .build(); identifiers = Identifiers.identifiers().withIdentifierQuoteString("\"") .build();
/** * Constructs a list of database object identifiers from SQL 2003 * keywords, and from the database server. Also obtains the * identifier quote string from the database server. * * @param connection * Live database connection * @throws SQLException * @return Builder */ public Builder withConnection(final Connection connection) throws SQLException { requireNonNull(connection, "No connection provided"); final DatabaseMetaData metaData = requireNonNull(connection .getMetaData(), "No database metadata obtained"); reservedWords.addAll(lookupReservedWords(metaData)); if (!isIdentifierQuoteStringSet()) { final String metaDataIdentifierQuoteString = metaData .getIdentifierQuoteString(); if (metaDataIdentifierQuoteString != null) { identifierQuoteString = metaDataIdentifierQuoteString; } } return this; }
return toUpperCase(reservedWords);
.getIdentifierQuoteString(); final Identifiers identifiers = Identifiers.identifiers() .withIdentifierQuoteString(identifierQuoteString).build();
.getIdentifierQuoteString(); final Identifiers identifiers = Identifiers.identifiers() .withIdentifierQuoteString(identifierQuoteString).build();
identifiers = Identifiers.identifiers().withConnection(connection) .build(); identifiers = Identifiers.identifiers().withIdentifierQuoteString("\"") .build();
identifiers = Identifiers.identifiers().withConnection(connection) .build(); identifiers = Identifiers.identifiers().withIdentifierQuoteString("\"") .build();
.withIdentifierQuoteString(identifierQuoteString) .withIdentifierQuotingStrategy(options.getIdentifierQuotingStrategy()) .build();
.withIdentifierQuoteString(identifierQuoteString) .withIdentifierQuotingStrategy(options.getIdentifierQuotingStrategy()) .build();
return toUpperCase(reservedWords);
return toUpperCase(reservedWords);
/** * Constructs a list of database object identifiers from SQL 2003 * keywords, and from the database server. Also obtains the * identifier quote string from the database server. * * @param connection * Live database connection * @throws SQLException * @return Builder */ public Builder withConnection(final Connection connection) throws SQLException { requireNonNull(connection, "No connection provided"); final DatabaseMetaData metaData = requireNonNull(connection .getMetaData(), "No database metadata obtained"); reservedWords.addAll(lookupReservedWords(metaData)); if (!isIdentifierQuoteStringSet()) { final String metaDataIdentifierQuoteString = metaData .getIdentifierQuoteString(); if (metaDataIdentifierQuoteString != null) { identifierQuoteString = metaDataIdentifierQuoteString; } } return this; }
/** * Constructs a list of database object identifiers from SQL 2003 * keywords, and from the database server. Also obtains the * identifier quote string from the database server. * * @param connection * Live database connection * @throws SQLException * @return Builder */ public Builder withConnection(final Connection connection) throws SQLException { requireNonNull(connection, "No connection provided"); final DatabaseMetaData metaData = requireNonNull(connection .getMetaData(), "No database metadata obtained"); reservedWords.addAll(lookupReservedWords(metaData)); if (!isIdentifierQuoteStringSet()) { final String metaDataIdentifierQuoteString = metaData .getIdentifierQuoteString(); if (metaDataIdentifierQuoteString != null) { identifierQuoteString = metaDataIdentifierQuoteString; } } return this; }
public SchemaRetrievalOptionsBuilder fromConnnection(final Connection connection) { if (connection == null) { return this; } DatabaseMetaData metaData; try { metaData = connection.getMetaData(); } catch (final SQLException e) { // Ignore metaData = null; } identifierQuoteString = lookupIdentifierQuoteString(metaData); identifiers = Identifiers.identifiers().withConnectionIfPossible(connection) .withIdentifierQuoteString(identifierQuoteString).build(); supportsCatalogs = lookupSupportsCatalogs(metaData); supportsSchemas = lookupSupportsSchemas(metaData); if (!overridesTypeMap.isPresent()) { overridesTypeMap = Optional.of(new TypeMap(connection)); } return this; }
public SchemaRetrievalOptionsBuilder fromConnnection(final Connection connection) { if (connection == null) { return this; } DatabaseMetaData metaData; try { metaData = connection.getMetaData(); } catch (final SQLException e) { // Ignore metaData = null; } identifierQuoteString = lookupIdentifierQuoteString(metaData); identifiers = Identifiers.identifiers().withConnectionIfPossible(connection) .withIdentifierQuoteString(identifierQuoteString).build(); supportsCatalogs = lookupSupportsCatalogs(metaData); supportsSchemas = lookupSupportsSchemas(metaData); if (!overridesTypeMap.isPresent()) { overridesTypeMap = Optional.of(new TypeMap(connection)); } return this; }
/** * Tries to use the connection, but does not throw any exceptions. * * @see #withConnection(Connection connection) * @param connection * Live database connection * @return Builder */ public Builder withConnectionIfPossible(final Connection connection) { try { withConnection(connection); } catch (NullPointerException | SQLException e) { // Ignore } return this; }
private void buildFullName() { if (fullName != null) { return; } final Schema schema = getSchema(); if (!isBlank(schema.getFullName())) { final Identifiers identifiers = Identifiers.identifiers() .withIdentifierQuoteString("\"").build(); fullName = identifiers.quoteFullName(this); } else { // System data-types are reserved words, but should not be quoted fullName = getName(); } }
private void buildFullName() { if (fullName != null) { return; } final Schema schema = getSchema(); if (!isBlank(schema.getFullName())) { final Identifiers identifiers = Identifiers.identifiers() .withIdentifierQuoteString("\"").build(); fullName = identifiers.quoteFullName(this); } else { // System data-types are reserved words, but should not be quoted fullName = getName(); } }
/** * Lookup a list of reserved words for a database system, using * database metadata. */ private static Collection<String> lookupReservedWords(final DatabaseMetaData metaData) { String sqlKeywords = ""; try { sqlKeywords = metaData.getSQLKeywords(); } catch (final Exception e) { LOGGER .log(Level.WARNING, "Could not retrieve SQL keywords metadata", e); } return toUpperCase(Arrays.asList(sqlKeywords.split(","))); }
/** * Lookup a list of reserved words for a database system, using * database metadata. */ private static Collection<String> lookupReservedWords(final DatabaseMetaData metaData) { String sqlKeywords = ""; try { sqlKeywords = metaData.getSQLKeywords(); } catch (final Exception e) { LOGGER .log(Level.WARNING, "Could not retrieve SQL keywords metadata", e); } return toUpperCase(Arrays.asList(sqlKeywords.split(","))); }