Layfolk-zcy opened a new issue, #4914:
URL: https://github.com/apache/shenyu/issues/4914
### Is there an existing issue for this?
- [X] I have searched the existing issues
### Current Behavior
The sql script of oracle on the master cannot be started using shenyu admin.
Many key reserved words in oracle conflict with the 'column' in sql. Has nobody
maintained the sql script of oracle
### Expected Behavior
_No response_
### Steps To Reproduce
_No response_
### Environment
```markdown
ShenYu version(s):2.5.1
```
### Debug logs
```java
### The error may exist in file
[D:\xydsvn\sungrid-ops-console\sungrid-policycen\target\classes\mappers\shenyu-dict-sqlmap.xml]
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT id, `type`,
dict_code, dict_name, dict_value, `desc`, sort,
enabled, date_created, date_updated
FROM shenyu_dict WHERE dict_code = ? AND dict_name = ?
### Cause: java.sql.SQLSyntaxErrorException: ORA-00911: 无效字符
; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException:
ORA-00911: 无效字符
at
org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:93)
~[spring-jdbc-5.3.15.jar:5.3.15]
at
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70)
~[spring-jdbc-5.3.15.jar:5.3.15]
at
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:79)
~[spring-jdbc-5.3.15.jar:5.3.15]
at
org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:91)
~[mybatis-spring-2.0.7.jar:2.0.7]
at
org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441)
~[mybatis-spring-2.0.7.jar:2.0.7]
at com.sun.proxy.$Proxy147.selectOne(Unknown Source) ~[na:na]
at
org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:160)
~[mybatis-spring-2.0.7.jar:2.0.7]
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:87)
~[mybatis-3.5.10.jar:3.5.10]
at
org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:145)
~[mybatis-3.5.10.jar:3.5.10]
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86)
~[mybatis-3.5.10.jar:3.5.10]
at com.sun.proxy.$Proxy162.selectByDictCodeAndDictName(Unknown Source)
~[na:na]
at
com.sunyard.grid.admin.service.impl.ShenyuDictServiceImpl.findByDictCodeName(ShenyuDictServiceImpl.java:111)
~[classes/:na]
at
com.sunyard.grid.admin.service.impl.ShenyuDictServiceImpl$$FastClassBySpringCGLIB$$52d23522.invoke(<generated>)
~[classes/:na]
at
org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
~[spring-core-5.3.15.jar:5.3.15]
at
org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:783)
~[spring-aop-5.3.15.jar:5.3.15]
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
~[spring-aop-5.3.15.jar:5.3.15]
at
org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:753)
~[spring-aop-5.3.15.jar:5.3.15]
at
org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97)
~[spring-aop-5.3.15.jar:5.3.15]
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
~[spring-aop-5.3.15.jar:5.3.15]
at
org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:753)
~[spring-aop-5.3.15.jar:5.3.15]
at
org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:698)
~[spring-aop-5.3.15.jar:5.3.15]
at
com.sunyard.grid.admin.service.impl.ShenyuDictServiceImpl$$EnhancerBySpringCGLIB$$82d22e20.findByDictCodeName(<generated>)
~[classes/:na]
at
com.sunyard.grid.admin.service.manager.impl.LoadServiceDocEntryImpl.isEnabledLoad(LoadServiceDocEntryImpl.java:115)
~[classes/:na]
at
com.sunyard.grid.admin.service.manager.impl.LoadServiceDocEntryImpl.loadApiDocument(LoadServiceDocEntryImpl.java:84)
~[classes/:na]
at
com.sunyard.grid.admin.listener.ApplicationStartListener.onApplicationEvent(ApplicationStartListener.java:50)
~[classes/:na]
at
com.sunyard.grid.admin.listener.ApplicationStartListener.onApplicationEvent(ApplicationStartListener.java:34)
~[classes/:na]
at
org.springframework.context.event.SimpleApplicationEventMulticaster.doInvokeListener(SimpleApplicationEventMulticaster.java:176)
~[spring-context-5.3.15.jar:5.3.15]
at
org.springframework.context.event.SimpleApplicationEventMulticaster.invokeListener(SimpleApplicationEventMulticaster.java:169)
~[spring-context-5.3.15.jar:5.3.15]
at
org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:143)
~[spring-context-5.3.15.jar:5.3.15]
at
org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:421)
~[spring-context-5.3.15.jar:5.3.15]
at
org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:378)
~[spring-context-5.3.15.jar:5.3.15]
at
org.springframework.boot.web.servlet.context.WebServerStartStopLifecycle.start(WebServerStartStopLifecycle.java:46)
~[spring-boot-2.6.3.jar:2.6.3]
at
org.springframework.context.support.DefaultLifecycleProcessor.doStart(DefaultLifecycleProcessor.java:178)
~[spring-context-5.3.15.jar:5.3.15]
... 19 common frames omitted
Caused by: java.sql.SQLSyntaxErrorException: ORA-00911: 无效字符
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509)
~[ojdbc8-19.3.0.0.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461)
~[ojdbc8-19.3.0.0.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104)
~[ojdbc8-19.3.0.0.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:550)
~[ojdbc8-19.3.0.0.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:268)
~[ojdbc8-19.3.0.0.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:655)
~[ojdbc8-19.3.0.0.jar:19.3.0.0.0]
at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:270)
~[ojdbc8-19.3.0.0.jar:19.3.0.0.0]
at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:91)
~[ojdbc8-19.3.0.0.jar:19.3.0.0.0]
at
oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:807)
~[ojdbc8-19.3.0.0.jar:19.3.0.0.0]
at
oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:983)
~[ojdbc8-19.3.0.0.jar:19.3.0.0.0]
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
~[ojdbc8-19.3.0.0.jar:19.3.0.0.0]
at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3666)
~[ojdbc8-19.3.0.0.jar:19.3.0.0.0]
at
oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1426)
~[ojdbc8-19.3.0.0.jar:19.3.0.0.0]
at
oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3778)
~[ojdbc8-19.3.0.0.jar:19.3.0.0.0]
at
oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1081)
~[ojdbc8-19.3.0.0.jar:19.3.0.0.0]
at
com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3446)
~[druid-1.2.11.jar:1.2.11]
at
com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_execute(FilterEventAdapter.java:434)
~[druid-1.2.11.jar:1.2.11]
at
com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3444)
~[druid-1.2.11.jar:1.2.11]
at
com.alibaba.druid.filter.FilterAdapter.preparedStatement_execute(FilterAdapter.java:1063)
~[druid-1.2.11.jar:1.2.11]
at
com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3444)
~[druid-1.2.11.jar:1.2.11]
at
com.alibaba.druid.filter.FilterAdapter.preparedStatement_execute(FilterAdapter.java:1063)
~[druid-1.2.11.jar:1.2.11]
at
com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3444)
~[druid-1.2.11.jar:1.2.11]
at
com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.execute(PreparedStatementProxyImpl.java:152)
~[druid-1.2.11.jar:1.2.11]
at
com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:483)
~[druid-1.2.11.jar:1.2.11]
at
org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:64)
~[mybatis-3.5.10.jar:3.5.10]
at
org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79)
~[mybatis-3.5.10.jar:3.5.10]
at
org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63)
~[mybatis-3.5.10.jar:3.5.10]
at
org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325)
~[mybatis-3.5.10.jar:3.5.10]
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
~[mybatis-3.5.10.jar:3.5.10]
at
org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
~[mybatis-3.5.10.jar:3.5.10]
at
com.github.pagehelper.PageInterceptor.intercept(PageInterceptor.java:132)
~[pagehelper-5.3.1.jar:na]
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62)
~[mybatis-3.5.10.jar:3.5.10]
at com.sun.proxy.$Proxy275.query(Unknown Source) ~[na:na]
at
org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151)
~[mybatis-3.5.10.jar:3.5.10]
at
org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145)
~[mybatis-3.5.10.jar:3.5.10]
at
org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
~[mybatis-3.5.10.jar:3.5.10]
at
org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:76)
~[mybatis-3.5.10.jar:3.5.10]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[na:1.8.0_201]
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
~[na:1.8.0_201]
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[na:1.8.0_201]
at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_201]
at
org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)
~[mybatis-spring-2.0.7.jar:2.0.7]
... 47 common frames omitted
Caused by: oracle.jdbc.OracleDatabaseException: ORA-00911: 无效字符
```
### Anything else?
_No response_
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
