H2 dependency is required for standalone mode. Or you may try cluster mode.
Regards, Weijie ----------------------------------------------- Wu Weijie 吴伟杰 Apache ShardingSphere PMC GitHub@TeslaCN shizhen...@imcoming.cn <shizhen...@imcoming.cn> 于2023年1月5日周四 22:01写道： > Hi, > 最近在集成shardingjdbc5.2.1，配置完成启动时总是报如下错误，有什么解决办法吗？ > 20230103 11:33:59,64 ERROR [RMI TCP Connection(5)-127.0.0.1] > (web.context.ContextLoader:351) Context initialization failed > org.springframework.beans.factory.BeanCreationException: Error creating > bean with name 'bipShardingDataSource': Bean instantiation via constructor > failed; nested exception is > org.springframework.beans.BeanInstantiationException: Failed to instantiate > [org.apache.shardingsphere.driver.jdbc.core.datasource.ShardingSphereDataSource]: > Constructor threw exception; nested exception is > java.lang.RuntimeException: Failed to get driver instance for > jdbcUrl=jdbc:h2:mem:config;DB_CLOSE_DELAY=-1;DATABASE_TO_UPPER=false;MODE=MYSQL > at > org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:275) > at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1148) > at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1050) > at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:512) > at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482) > at > org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306) > at > org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) > at > org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302) > at > org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197) > at > org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:778) > at > org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:843) > at > org.springframework.context.support.AbstractApplicationContext.__refresh(AbstractApplicationContext.java:541) > at > org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:42010) > at > org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:444) > at > org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:326) > at > org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:107) > at > org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4701) > at > org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5167) > at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) > at > org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:743) > at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:719) > at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:705) > at org.apache.catalina.startup.HostConfig.manageApp(HostConfig.java:1720) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) > at > org.apache.tomcat.util.modeler.BaseModelMBean.invoke(BaseModelMBean.java:287) > at > com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:819) > at com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(JmxMBeanServer.java:801) > at > org.apache.catalina.mbeans.MBeanFactory.createStandardContext(MBeanFactory.java:479) > at > org.apache.catalina.mbeans.MBeanFactory.createStandardContext(MBeanFactory.java:428) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) > at > org.apache.tomcat.util.modeler.BaseModelMBean.invoke(BaseModelMBean.java:287) > at > com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:819) > at com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(JmxMBeanServer.java:801) > at > com.sun.jmx.remote.security.MBeanServerAccessController.invoke(MBeanServerAccessController.java:468) > at > javax.management.remote.rmi.RMIConnectionImpl.doOperation(RMIConnectionImpl.java:1468) > at > javax.management.remote.rmi.RMIConnectionImpl.access$300(RMIConnectionImpl.java:76) > at > javax.management.remote.rmi.RMIConnectionImpl$PrivilegedOperation.run(RMIConnectionImpl.java:1309) > at java.security.AccessController.doPrivileged(Native Method) > at > javax.management.remote.rmi.RMIConnectionImpl.doPrivilegedOperation(RMIConnectionImpl.java:1408) > at > javax.management.remote.rmi.RMIConnectionImpl.invoke(RMIConnectionImpl.java:829) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) > at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:357) > at sun.rmi.transport.Transport$1.run(Transport.java:200) > at sun.rmi.transport.Transport$1.run(Transport.java:197) > at java.security.AccessController.doPrivileged(Native Method) > at sun.rmi.transport.Transport.serviceCall(Transport.java:196) > at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:573) > at > sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(TCPTransport.java:834) > at > sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.lambda$run$0(TCPTransport.java:688) > at java.security.AccessController.doPrivileged(Native Method) > at > sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:687) > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) > 03-Jan-2023 11:33:59.086 严重 [RMI TCP Connection(5)-127.0.0.1] > org.apache.catalina.core.StandardContext.startInternal > 一个或多个listeners启动失败，更多详细信息查看对应的容器日志文件 > 03-Jan-2023 11:33:59.087 严重 [RMI TCP Connection(5)-127.0.0.1] > org.apache.catalina.core.StandardContext.startInternal 由于之前的错误，Context[]启动失败 > at java.lang.Thread.run(Thread.java:748) > Caused by: org.springframework.beans.BeanInstantiationException: Failed to > instantiate > [org.apache.shardingsphere.driver.jdbc.core.datasource.ShardingSphereDataSource]: > Constructor threw exception; nested exception is > java.lang.RuntimeException: Failed to get driver instance for > jdbcUrl=jdbc:h2:mem:config;DB_CLOSE_DELAY=-1;DATABASE_TO_UPPER=false;MODE=MYSQL > at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:163) > at > org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:122) > at > org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:267) > ... 62 more > Caused by: java.lang.RuntimeException: Failed to get driver instance for > jdbcUrl=jdbc:h2:mem:config;DB_CLOSE_DELAY=-1;DATABASE_TO_UPPER=false;MODE=MYSQL > at > com.zaxxer.hikari.util.DriverDataSource.<init>(DriverDataSource.java:114) > at com.zaxxer.hikari.pool.PoolBase.initializeDataSource(PoolBase.java:321) > at com.zaxxer.hikari.pool.PoolBase.<init>(PoolBase.java:110) > at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:108) > at > com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112) > at > org.apache.shardingsphere.mode.repository.standalone.jdbc.JDBCRepository.init(JDBCRepository.java:64) > at > org.apache.shardingsphere.infra.util.spi.type.typed.TypedSPIRegistry.findRegisteredService(TypedSPIRegistry.java:66) > at > org.apache.shardingsphere.infra.util.spi.type.typed.TypedSPIRegistry.getRegisteredService(TypedSPIRegistry.java:113) > at > org.apache.shardingsphere.mode.repository.standalone.StandalonePersistRepositoryFactory.getInstance(StandalonePersistRepositoryFactory.java:45) > at > org.apache.shardingsphere.mode.manager.standalone.StandaloneContextManagerBuilder.build(StandaloneContextManagerBuilder.java:47) > at > org.apache.shardingsphere.driver.jdbc.core.datasource.ShardingSphereDataSource.createContextManager(ShardingSphereDataSource.java:76) > at > org.apache.shardingsphere.driver.jdbc.core.datasource.ShardingSphereDataSource.<init>(ShardingSphereDataSource.java:64) > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) > at > sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) > at > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) > at java.lang.reflect.Constructor.newInstance(Constructor.java:423) > at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:147) > ... 64 more > Caused by: java.sql.SQLException: No suitable driver > at java.sql.DriverManager.getDriver(DriverManager.java:315) > at > com.zaxxer.hikari.util.DriverDataSource.<init>(DriverDataSource.java:106) > ... 80 more > > ------------------------------ > > 顺颂商祺! > 师贞军_廉贞星君 > 研发中心 高级架构师 > TEL:15157480642 > EMAIL:shizhen...@imcoming.cn >
