schemacrawler java.lang.NullPointerException：无法检索目录

Question

我尝试将 schemacrawler 与 hsqldb 2.51 和 h2 2.x 一起使用，代码如下：

final LimitOptionsBuilder limit = LimitOptionsBuilder.builder()
    .includeSchemas(new IncludeAll())
    .includeTables(new IncludeAll());
final LoadOptionsBuilder load = LoadOptionsBuilder.builder()
    .withSchemaInfoLevel(SchemaInfoLevelBuilder.minimum());
final SchemaCrawlerOptions options = SchemaCrawlerOptionsBuilder.newSchemaCrawlerOptions()
    .withLimitOptions(limit.toOptions())
    .withLoadOptions(load.toOptions());
final Catalog catalog = SchemaCrawlerUtility.getCatalog(connection, options);
// throw NullPointerException
for (final schemacrawler.schema.Table t : catalog.getTables())
{
    //more code...
}

我无法在没有 NullPointerException 错误的情况下获取目录。 我的类路径中有两个档案：

• schemacrawler-16.16.11.jar
• schemacrawler-hsqldb-16.16.11.jar

如果有人有想法......

Answer 1

更改一些代码后，我设法得到了一些有用的东西...

new LoggingConfig(Level.ALL);
final LimitOptionsBuilder limit = LimitOptionsBuilder.builder()
    .includeSchemas(new IncludeAll())
    .includeTables(new IncludeAll());
final LoadOptionsBuilder load = LoadOptionsBuilder.builder()
    .withSchemaInfoLevel(SchemaInfoLevelBuilder.minimum());
final SchemaCrawlerOptions options = SchemaCrawlerOptionsBuilder.newSchemaCrawlerOptions()
    .withLimitOptions(limit.toOptions())
    .withLoadOptions(load.toOptions()); 
final SchemaRetrievalOptions retrieval = SchemaCrawlerUtility.matchSchemaRetrievalOptions(connection);
schemacrawler.crawl.SchemaCrawler crawler = new schemacrawler.crawl.SchemaCrawler(connection, retrieval, options);
final Catalog catalog = crawler.crawl();
for (final schemacrawler.schema.Table t : catalog.getTables())
    {
        //more code...
    }

但是，第一个代码总是给我同样的错误...