@Override public DatabaseSpecificOverrideOptionsBuilder getDbSpecificOptionsBuilder(Connection conn, PhysicalSchema physicalSchema, boolean searchAllTables) { return new DatabaseSpecificOverrideOptionsBuilder(); }
@Override public DatabaseSpecificOverrideOptionsBuilder getDatabaseSpecificOverrideOptionsBuilder() { final DatabaseSpecificOverrideOptionsBuilder databaseSpecificOverrideOptionsBuilder = super.getDatabaseSpecificOverrideOptionsBuilder(); databaseSpecificOverrideOptionsBuilder.doesNotSupportCatalogs(); return databaseSpecificOverrideOptionsBuilder; }
@Override public DatabaseSpecificOverrideOptionsBuilder getDbSpecificOptionsBuilder(Connection conn, PhysicalSchema physicalSchema, boolean searchAllTables) { DatabaseSpecificOverrideOptionsBuilder builder = super.getDbSpecificOptionsBuilder(conn, physicalSchema, searchAllTables); if (!searchAllTables) { // the default schemacrawler logic is optimized to search for all tables in Oracle. But it is very slow for single-table lookups // See the original logic in the class OracleDatabaseConnector. builder.withTableColumnRetrievalStrategy(MetadataRetrievalStrategy.metadata) .withForeignKeyRetrievalStrategy(MetadataRetrievalStrategy.metadata) .withIndexRetrievalStrategy(MetadataRetrievalStrategy.metadata); } return builder; } }
dbSpecificOptionsBuilder.withTableColumnRetrievalStrategy(MetadataRetrievalStrategy.metadata); " SYSCAT.VIEWS.SEQNO " + "WITH UR "; dbSpecificOptionsBuilder.withInformationSchemaViews().withViewsSql( sql ); dbSpecificOptionsBuilder.withInformationSchemaViews().withSequencesSql( "SELECT\n" + " NULLIF(1, 1)\n" +
@Override public DatabaseSpecificOverrideOptionsBuilder getDbSpecificOptionsBuilder(Connection conn, PhysicalSchema physicalSchema, boolean searchAllTables) { DatabaseSpecificOverrideOptionsBuilder dbSpecificOptionsBuilder = super.getDbSpecificOptionsBuilder(conn, physicalSchema, searchAllTables); String sequenceSql = getSequenceSql(physicalSchema); if (sequenceSql != null) { // if null, then setting the sequences object to null won't help either dbSpecificOptionsBuilder.withInformationSchemaViews().withSequencesSql(sequenceSql); } return dbSpecificOptionsBuilder; }
DatabaseSpecificOverrideOptions dbSpecificOptions = dbSpecificOptionsBuilder.toOptions(); this.enrichSchemaCrawlerOptions(conn, options, physicalSchema, tableName, procedureName);
@Override public DatabaseSpecificOverrideOptionsBuilder getDatabaseSpecificOverrideOptionsBuilder() { final DatabaseSpecificOverrideOptionsBuilder databaseSpecificOverrideOptionsBuilder = super.getDatabaseSpecificOverrideOptionsBuilder(); databaseSpecificOverrideOptionsBuilder.doesNotSupportCatalogs(); // Unlike the regular JDBC driver, catalogs are not supported return databaseSpecificOverrideOptionsBuilder; }