apache / shardingsphere

Distributed SQL transaction & query engine for data sharding, scaling, encryption, and more - on any database.
Apache License 2.0
19.89k stars 6.73k forks source link

oracle: TableMetaDataLoaderEngine : Dialect load table meta data error #27224

Closed jianyuePro closed 3 months ago

jianyuePro commented 1 year ago

In a connected Oracle19C environment

maven

`

    <!-- ojdbc8 -->
            <dependency>
                <groupId>com.oracle.database.jdbc</groupId>
                <artifactId>ojdbc8</artifactId>
                <version>19.6.0.0</version>
            </dependency>
    <!-- Sharding-JDBC -->
    <dependency>
        <groupId>org.apache.shardingsphere</groupId>
        <artifactId>shardingsphere-jdbc-core-spring-boot-starter</artifactId>
        <version>5.1.0</version>
    </dependency>

    <!-- ShardingJDBC 5.1.0 -->
    <dependency>
        <groupId>org.apache.tomcat</groupId>
        <artifactId>tomcat-dbcp</artifactId>
        <version>10.0.16</version>
    </dependency>

`

exception

` 2023-07-15 18:30:13.803 ERROR 2076 --- [ main] .a.s.i.m.s.b.l.TableMetaDataLoaderEngine : Dialect load table meta data error

org.apache.shardingsphere.infra.exception.ShardingSphereException: java.util.concurrent.ExecutionException: java.lang.NullPointerException at org.apache.shardingsphere.infra.metadata.schema.builder.loader.TableMetaDataLoaderEngine.loadByDialect(TableMetaDataLoaderEngine.java:98) ~[shardingsphere-infra-common-5.1.0.jar:5.1.0] at org.apache.shardingsphere.infra.metadata.schema.builder.loader.TableMetaDataLoaderEngine.load(TableMetaDataLoaderEngine.java:65) ~[shardingsphere-infra-common-5.1.0.jar:5.1.0] at org.apache.shardingsphere.singletable.metadata.SingleTableMetaDataBuilder.load(SingleTableMetaDataBuilder.java:56) [shardingsphere-single-table-core-5.1.0.jar:5.1.0] at org.apache.shardingsphere.singletable.metadata.SingleTableMetaDataBuilder.load(SingleTableMetaDataBuilder.java:43) [shardingsphere-single-table-core-5.1.0.jar:5.1.0] at org.apache.shardingsphere.infra.metadata.schema.builder.TableMetaDataBuilder.load(TableMetaDataBuilder.java:64) [shardingsphere-infra-common-5.1.0.jar:5.1.0] at org.apache.shardingsphere.infra.metadata.schema.loader.SchemaLoader.load(SchemaLoader.java:53) [shardingsphere-infra-common-5.1.0.jar:5.1.0] at org.apache.shardingsphere.mode.metadata.MetaDataContextsBuilder.addSchema(MetaDataContextsBuilder.java:78) [shardingsphere-mode-core-5.1.0.jar:5.1.0] at org.apache.shardingsphere.mode.manager.ContextManager.buildChangedMetaDataContext(ContextManager.java:446) [shardingsphere-mode-core-5.1.0.jar:5.1.0] at org.apache.shardingsphere.mode.manager.ContextManager.alterRuleConfiguration(ContextManager.java:259) [shardingsphere-mode-core-5.1.0.jar:5.1.0] `

strongduanmu commented 1 year ago

Hi @jianyuePro can you try the latest 5.4.0?

jianyuePro commented 1 year ago

Hi @jianyuePro can you try the latest 5.4.0?

OK, thank you

github-actions[bot] commented 1 year ago

There hasn't been any activity on this issue recently, and in order to prioritize active issues, it will be marked as stale.