为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:DM8
【操作系统】:
【CPU】:
【问题描述】*:本地SpringBoot+Camunda项目启动时报错:无效的表或视图名[ACT_GE_PROPERTY]
Caused by: dm.jdbc.driver.DMException: 第1 行附近出现错误:
无效的表或视图名[ACT_GE_PROPERTY]
at dm.jdbc.driver.DBError.throwException(DBError.java:635)
at dm.jdbc.c.a.n.J(MSG.java:221)
at dm.jdbc.c.a.n.G(MSG.java:181)
at dm.jdbc.c.a.n.F(MSG.java:162)
at dm.jdbc.c.a.a(DBAccess.java:759)
at dm.jdbc.c.a.a(DBAccess.java:186)
at dm.jdbc.driver.DmdbPreparedStatement.prepareSql(DmdbPreparedStatement.java:150)
at dm.jdbc.driver.DmdbPreparedStatement.<init>(DmdbPreparedStatement.java:120)
at dm.jdbc.driver.DmdbConnection.do_prepareStatement(DmdbConnection.java:721)
at dm.jdbc.driver.DmdbConnection.do_prepareStatement(DmdbConnection.java:707)
at dm.jdbc.driver.DmdbConnection.prepareStatement(DmdbConnection.java:1312)
at com.alibaba.druid.pool.DruidPooledConnection.prepareStatement(DruidPooledConnection.java:350)
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.springframework.jdbc.datasource.TransactionAwareDataSourceProxy$TransactionAwareInvocationHandler.invoke(TransactionAwareDataSourceProxy.java:241)
at com.sun.proxy.$Proxy162.prepareStatement(Unknown Source)
at org.apache.ibatis.executor.statement.PreparedStatementHandler.instantiateStatement(PreparedStatementHandler.java:86)
at org.apache.ibatis.executor.statement.BaseStatementHandler.prepare(BaseStatementHandler.java:88)
at org.apache.ibatis.executor.statement.RoutingStatementHandler.prepare(RoutingStatementHandler.java:59)
at org.apache.ibatis.executor.BatchExecutor.doQuery(BatchExecutor.java:90)
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325)
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:89)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147)
... 92 common frames omitted
适配方案:参考
https://www.cnblogs.com/hibpm/p/14911761.html
达梦数据库表客户端查询正常:
谁遇到过这个问题,是怎么解决的?
String name=“dm.jdbc.driver.DmDriver”;
String url=“jdbc:dm://192.168.15.35:5236?schema=TEST2”; //使用schema指定当前模式名
String user=“TEST”;
String password=“123456789”;
不在 SQL 中添加”模式名.对象名”的方式来访问数据的方法
表名是大写还是小写,可以提供下建表的DDL语句,看看是不是表名小写加了双引号