注册

shardingsphere启动报错

笑沧海 2024/01/12 871 2

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】: DM7
【操作系统】:统信UOS
【CPU】:
【问题描述】*:

配置如下:

spring.shardingsphere.datasource.ds0.driver=dm.jdbc.driver.DmDriver
spring.shardingsphere.datasource.ds0.url=jdbc:dm://127.0.0.1:5236/SYSDBA
spring.shardingsphere.datasource.ds0..username=SYSDBA
spring.shardingsphere.datasource.ds0..password=

无效的表或视图名[DBMS_LOCK_ALLOCATED]
        at org.springframework.beans.factory.support.ConstructorResolver.instantiate(ConstructorResolver.java:627)
        at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:456)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1288)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1127)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:538)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:498)
        at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:320)
        at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
        at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:318)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199)
        at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:273)
        at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1237)
        at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1164)
        at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:857)
        at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:760)
        ... 73 common frames omitted
Caused by: org.springframework.beans.BeanInstantiationException: Failed to instantiate [javax.sql.DataSource]: Factory method 'shardingDataSource' threw exception; nested exception is java.sql.SQLException: 第1 行附近出现错误:
无效的表或视图名[DBMS_LOCK_ALLOCATED]
        at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:185)
        at org.springframework.beans.factory.support.ConstructorResolver.instantiate(ConstructorResolver.java:622)
        ... 87 common frames omitted
Caused by: java.sql.SQLException: 第1 行附近出现错误:
无效的表或视图名[DBMS_LOCK_ALLOCATED]
        at dm.jdbc.dbaccess.DBError.throwSQLException(DBError.java:44)
        at dm.jdbc.dbaccess.Request_Response.resp_checkErr(Request_Response.java:2590)
        at dm.jdbc.dbaccess.Request_Response.resp_execute(Request_Response.java:1111)
        at dm.jdbc.dbaccess.Request_Response.resp_prepare(Request_Response.java:700)
        at dm.jdbc.dbaccess.DmdbCSI.prepareSQL(DmdbCSI.java:225)
        at dm.jdbc.driver.DmdbStatement_bs.directExec(DmdbStatement_bs.java:1731)
        at dm.jdbc.driver.DmdbStatement_bs.executeInner(DmdbStatement_bs.java:2125)
        at dm.jdbc.driver.DmdbStatement_bs.executeQuery(DmdbStatement_bs.java:352)
        at dm.jdbc.driver.DmdbStatement.do_executeQuery(DmdbStatement.java:1301)
        at dm.jdbc.filter.FilterChain.Statement_executeQuery(FilterChain.java:988)
        at dm.jdbc.driver.DmdbStatement.executeQuery(DmdbStatement.java:136)
        at com.alibaba.druid.pool.DruidPooledStatement.executeQuery(DruidPooledStatement.java:230)
        at org.apache.shardingsphere.sql.parser.binder.metadata.column.ColumnMetaDataLoader.load(ColumnMetaDataLoader.java:75)
        at org.apache.shardingsphere.sql.parser.binder.metadata.schema.SchemaMetaDataLoader.load(SchemaMetaDataLoader.java:84)
        at org.apache.shardingsphere.sql.parser.binder.metadata.schema.SchemaMetaDataLoader.load(SchemaMetaDataLoader.java:76)
        at org.apache.shardingsphere.core.metadata.ShardingMetaDataLoader.loadDefaultSchemaMetaData(ShardingMetaDataLoader.java:142)
        at org.apache.shardingsphere.core.metadata.ShardingMetaDataLoader.load(ShardingMetaDataLoader.java:126)
        at org.apache.shardingsphere.shardingjdbc.jdbc.core.context.ShardingRuntimeContext.loadSchemaMetaData(ShardingRuntimeContext.java:65)
        at org.apache.shardingsphere.shardingjdbc.jdbc.core.context.MultipleDataSourcesRuntimeContext.createMetaData(MultipleDataSourcesRuntimeContext.java:57)

回答 0
暂无回答
扫一扫
联系客服