注册

连接地址信息中填写了模式名,SQL未指定模式名,但执行SQL报错

魔法披风 2024/03/29 693 3

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

连接地址信息中填写了模式名,SQL未指定模式名,但执行SQL报错:

### Error querying database.  Cause: dm.jdbc.driver.DMException: Error in line: 3
Invalid table or view name [T_BUSINESS]
### The error may exist in ..BusinessesMapper.java (best guess)
### The error may involve ..BusinessesMapper.selectList
### The error occurred while executing a query
### SQL: SELECT   db_name   FROM t_business
### Cause: dm.jdbc.driver.DMException: Error in line: 3
Invalid table or view name [T_BUSINESS]
; Error in line: 3
Invalid table or view name [T_BUSINESS]; nested exception is dm.jdbc.driver.DMException: Error in line: 3
Invalid table or view name [T_BUSINESS] 

配置:

spring: datasource: url: ${SPRING_DATASOURCE_URL:jdbc:dm://127.0.0.1:5238?schema=模式名?allowMultiQueries=true} username: ${SPRING_DATASOURCE_USERNAME:SYSDBA} password: ${SPRING_DATASOURCE_PASSWORD:SYSDBA} driver-class-name: dm.jdbc.driver.DmDriver
回答 0
暂无回答
扫一扫
联系客服