Я интегрировал файл YAML с необходимыми конфигурациями для Shardingsphere. Я хочу создать осколки моей таблицы пользователей; Однако при запуске микросервиса я получаю ошибку:
Не удалось инициализировать пул: реализация JAXB-API не была обнаружена на пути модуля или ClassPath. /> at com.zaxxer.hikari.pool.hikaripool.throwpoolinitializationexception (hikaripool.java:605) ~ [hikaricp-6.3.0.jar: na]
at com.zaxxer.hikari.pool.hikaripool.checkfail (hikaripool.jekari. ~ [Hikaricp-6.3.0.jar: na]
at com.zaxxer.hikari.pool.hikaripool. (Hikaripool.java:101) ~ [hikaricp-6.3.0.jar: na]
at com.zaxxer.hikari.hikaridatasource.getConnection (hikaridatasource.java:111) ~ [hikaricp-6.3.0.jar: na]
at org.hibernate.engine.jdbc.connections.internal.datasourceConnectionProviderImpl.getConnection (dataSourceConnectionProviderImpl.java:126) ~ [hibernate-cor-6.6.15.final.jar: 6.6.15. org.hibernate.engine.jdbc.env.internal.jdbcenvironmentionItiator $ connectionProviderJdbcConnectionAccess.obtainConnection (jdbcenvironmentionItiator.java:483) ~ [Hibernate-Core-6.15.final.jar: 6.6.15.p. org.hibernate.resource.transaction.backend.jdbc.internal.jdbcisolationdelegate.delegatework (jdbcisolationdelegate.java:61) ~ [hibernate-cor-6.6.15.final.jar: 6.6.15.final]
at org.hibernate.engine.jdbc.env.internal.jdbcenvironmentinitiator.getjdbcenvironmentusingjdbcmetadata (jdbcenvironmentinitiator.java:336) ~ [hibernate-core-6.15.final.jar: 6.6.15.pn. org.hibernate.engine.jdbc.env.internal.jdbcenvironmentinitiator.initiateService (jdbcenvironmentionItiator.java:129) ~ [hibernate-cor-6.6.15.final.jar: 6.6.15.final]
at org.hibernate.engine.jdbc.env.internal.jdbcenvironmentionItiator.initiateService (jdbcenvironmentionItiator.java:81) ~ [hibernate-core-6.6.15.final.jar: 6.6.15.final]
at org.hibernate.boot.registry.internal.standardserviceRegistryImpl.ItiateService (StormarderServiceRegistryImpl.java:130) ~ [Hibernate-Core-6.6.15.final.jar: 6.6.15.final]
at org.hibernate.service.internal.abstractserviceRegistryImpl.createService (AbstractServiceRegistryImpl.java:263) ~ [Hibernate-Core-6.6.15.final.jar: 6.6.15.final]
at org.hibernate.service.internal.abstractServiceRegistryImpl.ItialIserservice (AbstractServiceRegistryImpl.java:238) ~ [Hibernate-Core-6.6.15.final.jar: 6.6.15.final]
at org.hibernate.service.internal.abstractserviceRegistryImpl.getService (AbstractServiceRegistryImpl.java:215) ~ [Hibernate-Core-6.6.15.final.jar: 6.6.15.final]
at org.hibernate.boot.model.relational.database. (Database.java:45) ~ [hibernate-core-6.6.15.final.jar: 6.6.15.final]
at org.hibernate.boot.internal.inflightmetAdatacollectorimpl.getDatabase (FullightMetAdatacollectorimpl.java:226) ~ [Hibernate-Core-6.6.15.final.jar: 6.6.15.final]
at org.bhibernate.boot.internal.inflightmetadatacollectorimpl. (OffightMetAdatacollectorimpl.java:194) ~ [Hibernate-Core-6.6.15.final.jar: 6.6.15.final]
at org.hibernate.boot.model.process.spi.metadatabuildingprocess.complete (metadatabuildingprocess.java:171) ~ [hibernate-core-6.6.15.final.jar: 6.6.15.final]
at org.hibernate.jpa.boot.internal.entitymanagerfactorybuilderimpl.metadata (EntityManagerFactoryBuilderimpl.java:1442) ~ [hibernate-cor-6.6.15.final.jar: 6.6.15.final]
at org.hibernate.jpa.boot.internal.entitymanagerfactorybuilderimpl.build (EntityManagerFactoryBuilderimpl.java:1513) ~ [hibernate-cor-6.6.15.final.jar: 6.6.15.final]
at org.springframework.orm.jpa.vendor.springhibernatejpapersistenceprovider.createcontainerentityManagerFactory (SpringhibernateJpaperSistenceProvider.java:66) ~ [Spring-orm-6.2.7.jar: 6.2.7]
at at at at at at at at at at at ate org.springframework.orm.jpa.localcontainerentitymanagerfactorybean.createnatientityManagerFactory (LocalContainerentItyManagerFactoryBean.java:390) ~ [Spring-orm-6.2.7.Jar: 6.2.7]
at org.springframework.orm.jpa.abstractentitymanagerfactorybean.buildativeentityManagerFactory (AbstractentityManagerFactoryBean.java:419) ~ [Spring-Orm-6.2.7.jar: 6.2.7]
at org.springframework.orm.jpa.abstractentitymanagerfactorybean.afterpropertiesset (AbstractentityManagerFactoryBean.java:400) ~ [Spring-6.2.7.jar: 6.2.7]
at org.springframework.orm.jpa.localcontainerentitymanagerfactorybean.afterpropertiesset (localcontainerentitymanagerfactorybean.java:366) ~ [Spring-orm-6.2.7.jar: 6.2.7]
at org.springframework.beans.factory.support.abstractautowirecapablebeanfactory.invokeinitmethods (Abstractautowirecapablebeanfactory.java:1873) ~ [Spring-Beans-6.2.7.jar: 6.2.7]
at org.springframework.beans.factory.support.abstractautowirecapablebeanfactory.initializebean (Abstractautowirecapablebeanfactory.java:1822) ~ [Spring-Beans-6.2.7.Jar: 6.2.7]
at org.springframework.beans.factory.support.abstractautowirecapablebeanfactory.docreateebean (Abstractautowirecapablebeanfactory.java:607) ~ [Spring-Beans-6.2.7.jar: 6.2.7]
at org.springframework.beans.factory.support.abstractautowirecapablebeanfactory.createbean (Abstractautowirecapablebeanfactory.java:529) ~ [Spring-Beans-6.2.7.jar: 6.2.7]
at org.springframework.beans.factory.support.abstractbeanfactory.lambda $ dogetbean $ 0 (Abstractbeanfactory.java:339) ~ [Spring-Beans-6.2.7.jar: 6.2.7]
at org.springframework.beans.factory.support.defaultsingletonbeanregistry.getsingleton (defaultingletonbeanregistry.java:373) ~ [Spring-Beans-6.2.7.jar: 6.2.7]
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:337) ~[spring-beans-6.2.7.jar:6.2.7]
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:207) ~ [Spring-Beans-6.2.7.jar: 6.2.7]
at org.springframework.context.support.abstractapplicationcontext.finishbeanfactoryinialization (AbstractapplicationContext.java:970) ~ [Spring-Context-6.2.7.Jar: 6.2.7] AT org.springframework.context.support.abstractapplicationcontext.refresh (AbstractApplicationContext.java:627) ~ [Spring-Context-6.2.7.jar: 6.2.7]
at org.springframework.boot.web.servlet.context.servletwebserverApplicationContext.REFRESH (ServletWebServerApplicationContext.java:146) ~ [Spring-Boot-3.5.0.jar: 3.5.0]
at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:753) ~[spring-boot-3.5.0.jar:3.5.0]
at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:439) ~[spring-boot-3.5.0.jar:3.5.0]
at org.springframework.boot.springapplication.run (springapplication.java:318) ~ [Spring-boot-3.5.0.jar: 3.5.0]
at org.springframework.boot.springapplication.run (Springapplication.java:1362) ~ [3.5.5.0.1.0.1.0.run (springapplication.java:1362) />at org.springframework.boot.SpringApplication.run(SpringApplication.java:1351) ~[spring-boot-3.5.0.jar:3.5.0]
at com.luispiquinrey.MicroservicesUsers.MicroservicesUsersApplication.main(MicroservicesUsersApplication.java:14) ~ [Classes /: na]
, вызванное: javax.xml.bind.jaxbexception: реализация JAXB-API не была обнаружена на пути модуля или класса. javax.xml.bind.contextfinder.find (ContextFinder.java:421) ~ [JAXB-API-2.3.0.jar: 2.3.0]
at javax.xml.bind.jaxbcontext.newinstance (jaxbcontext.java:721) ~ [Jaxb-API-2.0. javax.xml.bind.jaxbcontext.newinstance (jaxbcontext.java:662) ~ [jaxb-api-2.3.0.jar: 2.3.0]
at org.apache.shardingsphere.mode.repository.standalone.jdbc.sql.jdbcrepositorysqloader.loadfromjar (jdbcrepositorysqloader.java:114) ~ [shardingsphere-standalone-mode-repository-jdbc-5,0.0. org.apache.shardingsphere.mode.repository.standalone.jdbc.sql.jdbcrepositorysqloader.load (jdbcrepositorysqloader.java:72) ~ [shardingsphere-standalone-mode-repository-jdbc-5.0.0.jar: 5.0]
at org.apache.shardingsphere.infra.util.spi.type.typed.typedspiloader.findservice (typedspiloader.java:74) ~ [shardingsphere-infra-util-5.4.0.jar: 5.4.0]
at org.apache.shardingsphere.infra.util.spi.type.typed.typedspiloader.getservice (typedspiloader.java:127) ~ [shardingsphere-infra-util-5.4.0.jar: 5.4.0]
at org.apache.shardingsphere.mode.manager.standalone.standalonecontextmanagerbuilder.build (Standalonecontextmanagerbuilder.java:47) ~ [shardingsphere-standalone-mode-core-5.4.0.jar: 5.4.0]
at org.apache.shardingsphere.driver.jdbc.core.datasource.shardingspheredatasource.createcontextmanager (shardingspheredatasource.java:82) ~ [shardingsphere-jdbc-core-5.4.0.jar: 5.4.0]
at org.apache.shardingsphere.driver.jdbc.core.datasource.shardingspheredatasource. (shardingspheredatasource.java:69) ~ [shardingsphere-jdbc-core-5.4.0.jar: 5.4.0]
at org.apache.shardingsphere.driver.api.shardingspheredatasourcefactory.createdatasource (shardingspheredatasourcefactory.java:95) ~ [shardingsphere-jdbc-core-5.4.0.jar: 5.4.0]
at org.apache.shardingsphere.driver.api.yaml.yamlshardingspheredatasourcefactory.createdatasource (yamlshardingspheredatasourcefactory.java:167) ~ [shardingsphere-jdbc-core-5.4.0.jar: 5.4 org.apache.shardingsphere.driver.api.yaml.yamlshardingspheredatasourcefactory.createdatasource (yamlshardingspheredatasourcefactory.java:102) ~ [shardingsphere-jdbc-core-5.4.0.jar: 5.4 org.apache.shardingsphere.driver.jdbc.core.driver.driverdatasourcecheche.createdatasource (DriverDataSourceCheche.java:51) ~ [shardingsphere-jdbc-core-5.4.0.jar: 5.4.0]
at java.base /java.util.concurrent.concurrenthashmap.computeifabsent (concurrenthashmap.java:1708) ~ [na: na]
at org.apache.shardingsphere.driver.jdbc.core.driver.driverdatasourceche.age (riverdatasourccec.jache.jache.jachecache.hrache.Jdbc.core.driver.driverdatas ~ [shardingsphere-jdbc-core-5.4.0.jar: 5.4.0]
at org.apache.shardingsphere.driver.shardingspheredriver.connect (shardingspheredriver.java:51) ~ [shardingsphere-jdbc-core- com.zaxxer.hikari.util.driverdatasource.getConnection (riverdatasource.java:122) ~ [hikaricp-6.3.0.jar: na]
at com.zaxxer.hikari.pool.poolbase.newconnection (poolbase.java:368) ~ [Hikaricp-6.3.0.jar: na]
at com.zaxxer.hikari.pool.poolbase.newpoolentry (poolbase.java:205) ~ [hikaricp-6.3.0.jar: na]
at com.zaxxer.hikari.pool.hikaripool.createpoolentry (hikaripool.java:483) ~ [hikaricp-6.3.0.jar: na]
at com.zaxxer.hikari.pool.hikaripool.Checkfailsast (hikaripool.java:577777777777777777777777777777777777771.hikaripool.checkfail. ~ [Hikaricp-6.3.0.jar: na]
... 40 общих кадров опущены
, вызванные: java.lang.classnotfoundexception: com.sun.xml.internal.bind.v2.contextfactory
at java.base /jdk.internal.loader.builtinclassloader.loadclass (buildinclassloader.java:641) ~ [na: na]
at java.base /jdk.internal.loader.classloaders $ appclasslocklass (classloaders.java:188) ~ apclasslocklass. java.base /java.lang.classloader.loadclass (classloader.java:526) ~ [na: na]
at javax.xml.bind.serviceLoaderutil.nullsafeloadclass (ServiceLoaderutil.java:122) ~ [Jaxb-aapi-2.0. javax.xml.bind.serviceloaderutil.safeloadclass (ServiceLoaderutil.java:155) ~ [Jaxb-API-2.3.0.jar: 2.3.0]
at javax.xml.bind.contextfinder.newinstance (контекст. ~ [JAXB-API-2.3.0.jar: 2.3.0]
... 63 Общие кадры опущены < /p>
Я попытался добавить зависимости, чтобы решить проблему, но ничего не работает. Может быть, я не использую необходимые зависимости или они устарели. Поскольку я также не могу найти много ресурсов о том, как использовать его вместе с JPA, я застрял. com.mysql.jdbc.driver
jdbcurl: jdbc: mysql: // localhost: 3309 /ds0? /> maxlifetiMemilliseconds: 1800000
maxpoolsize: 65
minpoolsize: 1 < /p>
Режим:
type: standalone
< /p>
/> [*]! Sharding
таблицы:
Обзоры:
actualdatanodes: master.users _ $-> {0..1}
tabletrategy:
stand:
shardingcolumn: id_user
shardinggoralgorThmname: inline />inline:
type: INLINE
props:
algorithm-expression: master_$->{id_user % 2}
allow-range-query-with-inline-sharding: true
props:
proxy-hint-enabled: true
sql-show: true
И это мое приложение yml:
Spring:
Приложение:
Имя: microservicesusers
dataSource:
-класс-класс: org.apache.shardingsphere.driver.shardingspheredriver
url: jdbc: shardingsphere: sharding. /> Свойства:
hibernate:
dialect: org.hibernate.dialect.mysql8dialect
open-in-view: false
ddl-auto: none
config:
import:
appserver: http: // localhost: 8071 /
> jwtsem: // localhost: 8071 /
> jwtsec. /> и My pom: < /p>
< /p>
4.0.0
org.springframework.boot
spring-boot-starter-parent
3.5.0
com.luispiquinrey
MicroservicesUsers
0.0.1-SNAPSHOT
MicroservicesUsers
21
org.springframework.boot
spring-boot-starter-data-jpa
org.springframework.boot
spring-boot-starter-security
org.springframework.boot
spring-boot-starter-web
org.apache.shardingsphere
shardingsphere-jdbc-core
5.4.0
org.apache.shardingsphere
shardingsphere-cluster-mode-core
5.4.0
org.apache.shardingsphere
shardingsphere-cluster-mode-repository-zookeeper
5.4.0
org.apache.shardingsphere
shardingsphere-cluster-mode-repository-api
5.4.0
org.springframework.cloud
spring-cloud-starter-config
4.3.0
io.jsonwebtoken
jjwt-api
0.12.6
io.jsonwebtoken
jjwt-impl
0.12.6
runtime
io.jsonwebtoken
jjwt-jackson
0.12.6
runtime
org.springframework.boot
spring-boot-starter-actuator
com.mysql
mysql-connector-j
runtime
org.springframework.boot
spring-boot-starter-test
test
org.springframework.boot
spring-boot-starter-hateoas
org.springframework.security
spring-security-test
test
org.springframework.boot
spring-boot-maven-plugin
Подробнее здесь: https://stackoverflow.com/questions/796 ... ngsphere-w
