woshiluoshao commented on issue #23485:
URL:
https://github.com/apache/shardingsphere/issues/23485#issuecomment-1378174616
> Please provide more exception information about ShardingSphere, and it is
recommended to open sql-show to print out logic SQL and actual SQL to
facilitate troubleshooting.
============== Sql Start ==============
Execute ID :
cn.ffcs.cty.modules.templatemanage.mapper.TemplateCfgMapper.selectList
Execute SQL : select * from T_TEMPLATE_CFG T,
readwrite_ds.zhsq.t_dc_org_entity_info B where T.org_code = B.org_code and
T.IS_VALID = '1'
Execute Time: 2023-01-11T10:47:21.711
============== Sql End ==============
2023-01-11 10:47:25,649 INFO [http-nio-8889-exec-1]
org.apache.shardingsphere.infra.executor.sql.log.SQLLogger(74): Logic SQL:
SELECT * FROM T_TEMPLATE_CFG T, readwrite_ds.zhsq.t_dc_org_entity_info B WHERE
T.org_code = B.org_code AND T.IS_VALID = '1'
2023-01-11 10:47:25,649 INFO [http-nio-8889-exec-1]
org.apache.shardingsphere.infra.executor.sql.log.SQLLogger(74): SQLStatement:
OracleSelectStatement(super=SelectStatement(super=AbstractSQLStatement(parameterCount=0,
parameterMarkerSegments=[], commentSegments=[]),
projections=ProjectionsSegment(startIndex=7, stopIndex=7,
projections=[ShorthandProjectionSegment(startIndex=7, stopIndex=7,
owner=Optional.empty, alias=Optional.empty)], distinctRow=false),
from=JoinTableSegment(startIndex=14, stopIndex=48, alias=Optional.empty,
left=SimpleTableSegment(tableName=TableNameSegment(startIndex=14, stopIndex=27,
identifier=IdentifierValue(value=T_TEMPLATE_CFG, quoteCharacter=NONE)),
owner=Optional.empty, alias=Optional[T]), joinType=COMMA,
right=SimpleTableSegment(tableName=TableNameSegment(startIndex=45,
stopIndex=48, identifier=IdentifierValue(value=zhsq, quoteCharacter=NONE)),
owner=Optional[OwnerSegment(startIndex=32, stopIndex=43,
identifier=IdentifierValue(value=readwrite_ds, quote
Character=NONE), owner=Optional.empty)], alias=Optional.empty),
condition=null, using=[]), where=Optional.empty, groupBy=Optional.empty,
having=Optional.empty, orderBy=Optional.empty, combine=Optional.empty),
lock=Optional.empty, modelSegment=Optional.empty, withSegment=Optional.empty)
2023-01-11 10:47:25,649 INFO [http-nio-8889-exec-1]
org.apache.shardingsphere.infra.executor.sql.log.SQLLogger(74): Actual SQL:
write_ds ::: SELECT * FROM T_TEMPLATE_CFG T, zhsq.t_dc_org_entity_info B WHERE
T.org_code = B.org_code AND T.IS_VALID = '1'
2023-01-11 10:47:33,471 INFO [http-nio-8889-exec-1]
org.apache.shardingsphere.infra.executor.sql.log.SQLLogger(74): Logic SQL:
SELECT count(1) FROM T_TEMPLATE_CFG T JOIN
readwrite_ds.zhsq.t_dc_org_entity_info B ON T.org_code = B.org_code WHERE
T.IS_VALID = '1'
2023-01-11 10:47:33,472 INFO [http-nio-8889-exec-1]
org.apache.shardingsphere.infra.executor.sql.log.SQLLogger(74): SQLStatement:
OracleSelectStatement(super=SelectStatement(super=AbstractSQLStatement(parameterCount=0,
parameterMarkerSegments=[], commentSegments=[]),
projections=ProjectionsSegment(startIndex=7, stopIndex=14,
projections=[AggregationProjectionSegment(startIndex=7, stopIndex=14,
type=COUNT, innerExpression=(1),
parameters=[LiteralExpressionSegment(startIndex=13, stopIndex=13, literals=1)],
alias=Optional.empty)], distinctRow=false),
from=SimpleTableSegment(tableName=TableNameSegment(startIndex=21, stopIndex=34,
identifier=IdentifierValue(value=T_TEMPLATE_CFG, quoteCharacter=NONE)),
owner=Optional.empty, alias=Optional[T]), where=Optional.empty,
groupBy=Optional.empty, having=Optional.empty, orderBy=Optional.empty,
combine=Optional.empty), lock=Optional.empty, modelSegment=Optional.empty,
withSegment=Optional.empty)
2023-01-11 10:47:33,472 INFO [http-nio-8889-exec-1]
org.apache.shardingsphere.infra.executor.sql.log.SQLLogger(74): Actual SQL:
write_ds ::: SELECT count(1) FROM T_TEMPLATE_CFG T JOIN
readwrite_ds.zhsq.t_dc_org_entity_info B ON T.org_code = B.org_code WHERE
T.IS_VALID = '1'
org.springframework.jdbc.BadSqlGrammarException:
### Error querying database. Cause: java.sql.SQLSyntaxErrorException:
ORA-00905: 缺失关键字
### The error may exist in file
[D:\workspace\FFCS\cty-project\cty\cty-service\target\classes\cn\ffcs\cty\modules\templatemanage\mapper\TemplateCfgMapper.xml]
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT count(1) FROM T_TEMPLATE_CFG T JOIN
readwrite_ds.zhsq.t_dc_org_entity_info B ON T.org_code = B.org_code WHERE
T.IS_VALID = '1'
### Cause: java.sql.SQLSyntaxErrorException: ORA-00905: 缺失关键字
; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException:
ORA-00905: 缺失关键字
at
org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:93)
at
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70)
at
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:79)
at
org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:91)
at
org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441)
at com.sun.proxy.$Proxy160.selectOne(Unknown Source)
at
org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:160)
at
com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:89)
at
com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:148)
at
com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)
at com.sun.proxy.$Proxy217.selectList2(Unknown Source)
at
cn.ffcs.cty.modules.templatemanage.service.impl.TemplateCfgServiceImpl.searchList(TemplateCfgServiceImpl.java:64)
at
cn.ffcs.cty.modules.templatemanage.service.impl.TemplateCfgServiceImpl$$FastClassBySpringCGLIB$$1.invoke(<generated>)
at
org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
at
org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:783)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at
org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:753)
at
org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123)
at
org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:388)
at
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at
org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:753)
at
org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:698)
at
cn.ffcs.cty.modules.templatemanage.service.impl.TemplateCfgServiceImpl$$EnhancerBySpringCGLIB$$1.searchList(<generated>)
at
org.apache.dubbo.common.bytecode.Wrapper46.invokeMethod(Wrapper46.java)
at
org.apache.dubbo.rpc.proxy.javassist.JavassistProxyFactory$1.doInvoke(JavassistProxyFactory.java:47)
at
org.apache.dubbo.rpc.proxy.AbstractProxyInvoker.invoke(AbstractProxyInvoker.java:84)
at
org.apache.dubbo.config.invoker.DelegateProviderMetaDataInvoker.invoke(DelegateProviderMetaDataInvoker.java:56)
at
org.apache.dubbo.rpc.protocol.InvokerWrapper.invoke(InvokerWrapper.java:56)
at
cn.ffcs.shequ.log.utils.exception.FFCSDubboExceptionFilter.invoke(FFCSDubboExceptionFilter.java:23)
at org.apache.dubbo.rpc.protocol.FilterNode.invoke(FilterNode.java:61)
at
org.apache.dubbo.rpc.protocol.dubbo.filter.TraceFilter.invoke(TraceFilter.java:77)
at org.apache.dubbo.rpc.protocol.FilterNode.invoke(FilterNode.java:61)
at
org.apache.dubbo.rpc.filter.TimeoutFilter.invoke(TimeoutFilter.java:44)
at org.apache.dubbo.rpc.protocol.FilterNode.invoke(FilterNode.java:61)
at
org.apache.dubbo.rpc.filter.ExceptionFilter.invoke(ExceptionFilter.java:52)
at org.apache.dubbo.rpc.protocol.FilterNode.invoke(FilterNode.java:61)
at
org.apache.dubbo.rpc.filter.GenericFilter.invoke(GenericFilter.java:192
--
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]
