GBase 8s
安装配置
问答

springboot + jpa + sharding 集成启动报错

发表于2025-09-22 10:10:06114次浏览7个评论

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。

【GBase版本】: GBase 8s Server 8.8

【操作系统】:windows idea环境

【CPU】:

【问题描述】*:

启动项目报错 
日志:

Caused by: org.springframework.beans.BeanInstantiationException: Failed to instantiate [javax.sql.DataSource]: Factory method 'shardingDataSource' threw exception; nested exception is java.lang.NoClassDefFoundError: org/apache/shardingsphere/infra/instance/metadata/InstanceMetaDataBuilder
    at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:185) ~[spring-beans-5.3.20.jar:5.3.20]
    at org.springframework.beans.factory.support.ConstructorResolver.instantiate(ConstructorResolver.java:653) ~[spring-beans-5.3.20.jar:5.3.20]
    ... 35 common frames omitted
Caused by: java.lang.NoClassDefFoundError: org/apache/shardingsphere/infra/instance/metadata/InstanceMetaDataBuilder
    at org.apache.shardingsphere.driver.jdbc.core.datasource.ShardingSphereDataSource.createContextManager(ShardingSphereDataSource.java:72) ~[shardingsphere-jdbc-core-5.4.1.jar:5.4.1]
    at org.apache.shardingsphere.driver.jdbc.core.datasource.ShardingSphereDataSource.<init>(ShardingSphereDataSource.java:66) ~[shardingsphere-jdbc-core-5.4.1.jar:5.4.1]
    at org.apache.shardingsphere.driver.api.ShardingSphereDataSourceFactory.createDataSource(ShardingSphereDataSourceFactory.java:95) ~[shardingsphere-jdbc-core-5.4.1.jar:5.4.1]
    at org.apache.shardingsphere.driver.api.ShardingSphereDataSourceFactory.createDataSource(ShardingSphereDataSourceFactory.java:78) ~[shardingsphere-jdbc-core-5.4.1.jar:5.4.1]
    at org.apache.shardingsphere.driver.api.ShardingSphereDataSourceFactory.createDataSource(ShardingSphereDataSourceFactory.java:139) ~[shardingsphere-jdbc-core-5.4.1.jar:5.4.1]
    at org.apache.shardingsphere.shardingjdbc.spring.boot.SpringBootConfiguration.shardingDataSource(SpringBootConfiguration.java:64) ~[classes/:na]
    at org.apache.shardingsphere.shardingjdbc.spring.boot.SpringBootConfiguration$$EnhancerBySpringCGLIB$$6084ff86.CGLIB$shardingDataSource$1(<generated>) ~[classes/:na]
    at org.apache.shardingsphere.shardingjdbc.spring.boot.SpringBootConfiguration$$EnhancerBySpringCGLIB$$6084ff86$$FastClassBySpringCGLIB$$d6876139.invoke(<generated>) ~[classes/:na]
    at org.springframework.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:244) ~[spring-core-5.3.20.jar:5.3.20]
    at org.springframework.context.annotation.ConfigurationClassEnhancer$BeanMethodInterceptor.intercept(ConfigurationClassEnhancer.java:331) ~[spring-context-5.3.20.jar:5.3.20]
    at org.apache.shardingsphere.shardingjdbc.spring.boot.SpringBootConfiguration$$EnhancerBySpringCGLIB$$6084ff86.shardingDataSource(<generated>) ~[classes/:na]
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_144]
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_144]
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_144]
    at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_144]
    at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:154) ~[spring-beans-5.3.20.jar:5.3.20]
    ... 36 common frames omitted
Caused by: java.lang.ClassNotFoundException: org.apache.shardingsphere.infra.instance.metadata.InstanceMetaDataBuilder
    at java.net.URLClassLoader.findClass(URLClassLoader.java:381) ~[na:1.8.0_144]
    at java.lang.ClassLoader.loadClass(ClassLoader.java:424) ~[na:1.8.0_144]
    at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:335) ~[na:1.8.0_144]
    at java.lang.ClassLoader.loadClass(ClassLoader.java:357) ~[na:1.8.0_144]
    ... 52 common frames omitted

 

配置:

spring:
  shardingsphere:
    # 数据源配置
    datasource:
      names: gbase
      gbase:
        datasource-class-name: com.zaxxer.hikari.HikariDataSource
        type: com.zaxxer.hikari.HikariDataSource
        driver-class-name: com.gbasedbt.jdbc.Driver
        jdbc-url: jdbc:gbasedbt-sqli://192.168.2.231:19088/testdb:GBASEDBTSERVER=gbase01;SQLMOD=Gbase;DELIMIDENT=Y;
        username: your_username
        password: your_password
    
    # 规则配置(这里简单配置,实际根据分片需求调整)
    rules:
      none:
    # 属性配置
    props:
      sql-show: true
    # 是否启用
    enabled: true

依赖:

<dependencies>
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-web</artifactId>
    </dependency>
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-data-jpa</artifactId>
    </dependency>
    
    <dependency>
        <groupId>org.projectlombok</groupId>
        <artifactId>lombok</artifactId>
        <optional>true</optional>
    </dependency>
    
    <!-- ShardingSphere JDBC -->
    <dependency>
        <groupId>org.apache.shardingsphere</groupId>
        <artifactId>sharding-jdbc-spring-boot-starter</artifactId>
        <version>4.0.1</version>
        <exclusions>
            <exclusion>
                <artifactId>sharding-jdbc-core</artifactId>
                <groupId>org.apache.shardingsphere</groupId>
            </exclusion>
        </exclusions>
    </dependency>
    
    <dependency>
        <groupId>org.apache.shardingsphere</groupId>
        <artifactId>shardingsphere-parser-sql-gbase8s</artifactId>
        <version>5.4.1</version>
    </dependency>
    <dependency>
        <groupId>org.apache.shardingsphere</groupId>
        <artifactId>shardingsphere-parser-sql-gbasemy8s</artifactId>
        <version>5.4.1</version>
    </dependency>
    <dependency>
        <groupId>org.apache.shardingsphere</groupId>
        <artifactId>shardingsphere-infra-database-gbase8s</artifactId>
        <version>5.4.1</version>
    </dependency>
    <dependency>
        <groupId>org.apache.shardingsphere</groupId>
        <artifactId>shardingsphere-jdbc-core</artifactId>
        <version>5.4.1</version>
    </dependency>
    
    
    <dependency>
        <groupId>com.gbase</groupId>
        <artifactId>gbase8x</artifactId>
        <version>1.0</version>
        <scope>system</scope>
        <systemPath>${pom.basedir}/lib/gbase-jdbc-3.6.3.32.jar</systemPath>
    </dependency>
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-test</artifactId>
        <scope>test</scope>
    </dependency>
</dependencies>

悬赏:10吉币
回答被发帖人采纳后可获得赏金

评论

登录后才可以发表评论
用户头像
路路路发表于 10个月前
稍等
诸侯饲养员发表于 10个月前
@路路路:好的
用户头像
琳大大发表于 10个月前
按照这个步骤进行操作后重启应用:
1)进入到需要安装的jar的根目录下
2)单次执行如下命令
mvn install:install-file -Dfile=shardingsphere-parser-sql-gbase8s-5.4.1.jar -DgroupId=org.apache.shardingsphere -DartifactId=shardingsphere-parser-sql-gbase8s -Dversion=5.4.1 -Dpackaging=jar
mvn install:install-file -Dfile=shardingsphere-infra-database-gbase8s-5.4.1.jar -DgroupId=org.apache.shardingsphere -DartifactId=shardingsphere-infra-database-gbase8s -Dversion=5.4.1 -Dpackaging=jar

mvn install:install-file -Dfile=shardingsphere-infra-binder-5.4.1.jar -DgroupId=org.apache.shardingsphere -DartifactId=shardingsphere-infra-binder -Dversion=5.4.1 -Dpackaging=jar
mvn install:install-file -Dfile=shardingsphere-infra-database-core-5.4.1.jar -DgroupId=org.apache.shardingsphere -DartifactId=shardingsphere-infra-database-core -Dversion=5.4.1 -Dpackaging=jar
mvn install:install-file -Dfile=shardingsphere-jdbc-core-5.4.1.jar -DgroupId=org.apache.shardingsphere -DartifactId=shardingsphere-jdbc-core -Dversion=5.4.1 -Dpackaging=jar
mvn install:install-file -Dfile=shardingsphere-parser-sql-statement-5.4.1.jar -DgroupId=org.apache.shardingsphere -DartifactId=shardingsphere-parser-sql-statement -Dversion=5.4.1 -Dpackaging=jar
mvn install:install-file -Dfile=shardingsphere-sharding-core-5.4.1.jar -DgroupId=org.apache.shardingsphere -DartifactId=shardingsphere-sharding-core -Dversion=5.4.1 -Dpackaging=jar
mvn install:install-file -Dfile=shardingsphere-transaction-xa-core-5.4.1.jar -DgroupId=org.apache.shardingsphere -DartifactId=shardingsphere-transaction-xa-core -Dversion=5.4.1 -Dpackaging=jar
3)pom引入如下文件:

org.apache.shardingsphere
shardingsphere-parser-sql-gbase8s
5.4.1


org.apache.shardingsphere
shardingsphere-jdbc-core
5.4.1
最佳回答
诸侯饲养员发表于 10个月前
@琳大大:感谢,是我引入太多了
用户头像
GBase用户28017发表于 10个月前
看似是没加载上啊。
曾云林发表于 2个月前
三人行必有我师
GBase用户51840发表于 2个月前
等待有缘人解答。