You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by "ChenGengPeng (via GitHub)" <gi...@apache.org> on 2023/03/26 15:53:57 UTC

[GitHub] [shardingsphere] ChenGengPeng opened a new issue, #24843: About the problems encountered in the process of using shardingsphere-proxy, seek solutions! ! !

ChenGengPeng opened a new issue, #24843:
URL: https://github.com/apache/shardingsphere/issues/24843

   Recently, we need to use shardingsphere-proxy to desensitize the data of the old application of the company. The framework is SSH (struct2) built in 2011, which reports errors in some statements. The error information of shardingsphere's log is:
   [ERROR] 2023-03-26 23:21:14.197 [ShardingSphere-Command-22] o.a.s.p.f.c.CommandExecutorTask - Exception occur: 
   java.lang.StringIndexOutOfBoundsException: String index out of range: -19
   	at java.lang.String.substring(String.java:1967)
   	at org.apache.shardingsphere.infra.rewrite.sql.impl.AbstractSQLBuilder.getConjunctionText(AbstractSQLBuilder.java:64)
   	at org.apache.shardingsphere.infra.rewrite.sql.impl.AbstractSQLBuilder.toSQL(AbstractSQLBuilder.java:47)
   	at org.apache.shardingsphere.infra.rewrite.engine.RouteSQLRewriteEngine.addSQLRewriteUnits(RouteSQLRewriteEngine.java:85)
   	at org.apache.shardingsphere.infra.rewrite.engine.RouteSQLRewriteEngine.rewrite(RouteSQLRewriteEngine.java:61)
   	at org.apache.shardingsphere.infra.rewrite.SQLRewriteEntry.rewrite(SQLRewriteEntry.java:75)
   	at org.apache.shardingsphere.infra.context.kernel.KernelProcessor.rewrite(KernelProcessor.java:59)
   	at org.apache.shardingsphere.infra.context.kernel.KernelProcessor.generateExecutionContext(KernelProcessor.java:47)
   	at org.apache.shardingsphere.proxy.backend.communication.jdbc.JDBCDatabaseCommunicationEngine.execute(JDBCDatabaseCommunicationEngine.java:123)
   	at org.apache.shardingsphere.proxy.backend.communication.jdbc.JDBCDatabaseCommunicationEngine.execute(JDBCDatabaseCommunicationEngine.java:73)
   	at org.apache.shardingsphere.proxy.backend.text.data.impl.SchemaAssignedDatabaseBackendHandler.execute(SchemaAssignedDatabaseBackendHandler.java:56)
   	at org.apache.shardingsphere.proxy.frontend.mysql.command.query.text.query.MySQLComQueryPacketExecutor.execute(MySQLComQueryPacketExecutor.java:97)
   	at org.apache.shardingsphere.proxy.frontend.command.CommandExecutorTask.executeCommand(CommandExecutorTask.java:100)
   	at org.apache.shardingsphere.proxy.frontend.command.CommandExecutorTask.run(CommandExecutorTask.java:72)
   	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
   	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
   	at java.lang.Thread.run(Thread.java:748)  ,The query statement is:
   	select   count(*) as  totalCount from (select distinct trealname0_.SEQ as col_0_0_, trealname0_.ORID as col_1_0_, trealname0_.ISCENICID as col_2_0_, esbscenica1_.SZSCENICNAME as col_3_0_, trealname0_.ITICKETTYPEID as col_4_0_, edmtickett2_.SZTICKETTYPENAME as col_5_0_, trealname0_.ICROWDKINDID as col_6_0_, edpcrowdki3_.SZCROWDKINDNAME as col_7_0_, trealname0_.CNAME as col_8_0_, trealname0_.ZJTP as col_9_0_, trealname0_.IDCARD as col_10_0_, trealname0_.ISCHILD as col_11_0_, trealname0_.MBNUMBER as col_12_0_, torder4_.DDZT as col_13_0_, trealname0_.TICKETSTATUS as col_14_0_, trealname0_.TICKETCONSUMEORID as col_15_0_, trealname0_.TICKETNO as col_16_0_, edmcrowdki5_.MACTUALSALEPRICE as col_17_0_ from T_REALNAME trealname0_, ESBSCENICAREATAB esbscenica1_, EDMTICKETTYPETAB edmtickett2_, EDPCROWDKINDTAB edpcrowdki3_, T_ORDER torder4_, EDMCROWDKINDPRICETAB edmcrowdki5_ where trealname0_.PRICEID=edmcrowdki5_.ICROWDKINDPRICEID and trealname0_.ORID=torder4_.ORID and trealname0_.ISCENICID=e
 sbscenica1_.ISCENICID and trealname0_.ITICKETTYPEID=edmtickett2_.ITICKETTYPEID and trealname0_.ICROWDKINDID=edpcrowdki3_.ICROWDKINDID and torder4_.ORID='xxxx')  a


-- 
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: notifications-unsubscribe@shardingsphere.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


[GitHub] [shardingsphere] ChenGengPeng commented on issue #24843: About the problems encountered in the process of using shardingsphere-proxy, seek solutions! ! !

Posted by "ChenGengPeng (via GitHub)" <gi...@apache.org>.
ChenGengPeng commented on issue #24843:
URL: https://github.com/apache/shardingsphere/issues/24843#issuecomment-1489636620

   ### Question
   
   - version:apache-shardingsphere-5.1.1 shading中用的mysql-connector是8.0.29,但应用用的是5(原因是项目太老01年维护至今的代码,升级connextor要修改太多东西)
   - 
   
   > 报错内容如下:
   `[2023-03-30 11:26:03  WARN org.hibernate.util.JDBCExceptionReporter:77] SQL Error: 1997, SQLState: C1997
   [2023-03-30 11:26:03 ERROR org.hibernate.util.JDBCExceptionReporter:78] Runtime exception: [String index out of range: -18]
   org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not execute query; uncategorized SQLException for SQL [select   count(*) as  totalCount from (select distinct trealname0_.ORID as col_0_0_, esbscenica1_.SZSCENICNAME as col_1_0_, edmtickett2_.SZTICKETTYPENAME as col_2_0_, edmcrowdki3_.ICROWDKINDID as col_3_0_, edmcrowdki3_.MACTUALSALEPRICE as col_4_0_, trealname0_.CNAME as col_5_0_, trealname0_.ZJTP as col_6_0_, trealname0_.IDCARD as col_7_0_, trealname0_.TICKETSTATUS as col_8_0_, trealname0_.ISCHILD as col_9_0_, trealname0_.MBNUMBER as col_10_0_, trealname0_.TICKETNO as col_11_0_, trealname0_.TICKETCONSUMEORID as col_12_0_ from T_REALNAME trealname0_, ESBSCENICAREATAB esbscenica1_, EDMTICKETTYPETAB edmtickett2_, EDMCROWDKINDPRICETAB edmcrowdki3_ where esbscenica1_.ISCENICID=trealname0_.ISCENICID and edmtickett2_.ITICKETTYPEID=trealname0_.ITICKETTYPEID and edmcrowdki3_.ICROWDKINDPRICEID=trealname0_.PRICEID and trealname0_.ORID='20230330000000008')  a]; 
 SQL state [C1997]; error code [1997]; Runtime exception: [String index out of range: -18]; nested exception is java.sql.SQLException: Runtime exception: [String index out of range: -18]
   	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
   	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
   	at org.springframework.orm.hibernate3.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:424)
   	at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:410)
   	at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:424)
   	at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:387)
   	at com.ectrip.base.dao.GenericDao.findPage(GenericDao.java:133)
   	at com.ectrip.order.dao.RealnameDao.realNameListByOrid(RealnameDao.java:407)
   	at com.ectrip.order.service.RealnameService.realNameListByOrid(RealnameService.java:165)
   	at com.ectrip.report.system.order.action.AllOrderManageAction.showRealnameList(AllOrderManageAction.java:2088)
   	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 ognl.OgnlRuntime.invokeMethod(OgnlRuntime.java:897)
   	at ognl.OgnlRuntime.callAppropriateMethod(OgnlRuntime.java:1299)
   	at ognl.ObjectMethodAccessor.callMethod(ObjectMethodAccessor.java:68)
   	at com.opensymphony.xwork2.ognl.accessor.XWorkMethodAccessor.callMethodWithDebugInfo(XWorkMethodAccessor.java:117)
   	at com.opensymphony.xwork2.ognl.accessor.XWorkMethodAccessor.callMethod(XWorkMethodAccessor.java:108)
   	at ognl.OgnlRuntime.callMethod(OgnlRuntime.java:1375)
   	at ognl.ASTMethod.getValueBody(ASTMethod.java:91)
   	at ognl.SimpleNode.evaluateGetValueBody(SimpleNode.java:212)
   	at ognl.SimpleNode.getValue(SimpleNode.java:258)
   	at ognl.Ognl.getValue(Ognl.java:470)
   	at ognl.Ognl.getValue(Ognl.java:434)
   	at com.opensymphony.xwork2.ognl.OgnlUtil$3.execute(OgnlUtil.java:362)
   	at com.opensymphony.xwork2.ognl.OgnlUtil.compileAndExecuteMethod(OgnlUtil.java:414)
   	at com.opensymphony.xwork2.ognl.OgnlUtil.callMethod(OgnlUtil.java:360)
   	at com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:430)
   	at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:290)
   	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:251)
   	at com.ectrip.interceptor.CheckAdminLgoinInterceptor.doIntercept(CheckAdminLgoinInterceptor.java:159)
   	at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
   	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245)
   	at org.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept(DebuggingInterceptor.java:256)
   	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245)
   	at com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:168)
   	at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
   	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245)
   	at com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:265)
   	at org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:76)
   	at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
   	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245)
   	at com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:138)
   	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245)
   	at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:229)
   	at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
   	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245)
   	at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:229)
   	at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
   	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245)
   	at com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:191)
   	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245)
   	at org.apache.struts2.interceptor.MultiselectInterceptor.intercept(MultiselectInterceptor.java:73)
   	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245)
   	at org.apache.struts2.interceptor.CheckboxInterceptor.intercept(CheckboxInterceptor.java:91)
   	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245)
   	at org.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:253)
   	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245)
   	at com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept(ModelDrivenInterceptor.java:100)
   	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245)
   	at com.opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor.intercept(ScopedModelDrivenInterceptor.java:141)
   	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245)
   	at com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:145)
   	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245)
   	at com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(PrepareInterceptor.java:171)
   	at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
   	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245)
   	at com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:140)
   	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245)
   	at org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigInterceptor.java:164)
   	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245)
   	at com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasInterceptor.java:193)
   	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245)
   	at com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:189)
   	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245)
   	at org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:54)
   	at org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:575)
   	at org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(ExecuteOperations.java:81)
   	at org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter.doFilter(StrutsPrepareAndExecuteFilter.java:99)
   	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
   	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
   	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:96)
   	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
   	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
   	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
   	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
   	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
   	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494)
   	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
   	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
   	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:1025)
   	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
   	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:445)
   	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1137)
   	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)
   	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1775)
   	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1734)
   	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
   	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
   	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
   	at java.lang.Thread.run(Thread.java:750)
   Caused by: java.sql.SQLException: Runtime exception: [String index out of range: -18]
   	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
   	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
   	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
   	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
   	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
   	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
   	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)
   	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734)
   	at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1885)
   	at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
   	at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
   	at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
   	at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
   	at org.hibernate.loader.Loader.doQuery(Loader.java:674)
   	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
   	at org.hibernate.loader.Loader.doList(Loader.java:2220)
   	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
   	at org.hibernate.loader.Loader.list(Loader.java:2099)
   	at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:289)
   	at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1695)
   	at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:142)
   	at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:152)
   	at com.ectrip.base.dao.GenericDao$2.doInHibernate(GenericDao.java:156)
   	at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:419)
   	... 97 more
   `
   [表结构.zip](https://github.com/apache/shardingsphere/files/11107480/default.zip)
   
   


-- 
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: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


Re: [I] About the problems encountered in the process of using shardingsphere-proxy, seek solutions! ! ! [shardingsphere]

Posted by "terrymanu (via GitHub)" <gi...@apache.org>.
terrymanu closed issue #24843: About the problems encountered in the process of using shardingsphere-proxy, seek solutions! ! !
URL: https://github.com/apache/shardingsphere/issues/24843


-- 
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: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


[GitHub] [shardingsphere] RaigorJiang commented on issue #24843: About the problems encountered in the process of using shardingsphere-proxy, seek solutions! ! !

Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.
RaigorJiang commented on issue #24843:
URL: https://github.com/apache/shardingsphere/issues/24843#issuecomment-1487916355

   Hi @ChenGengPeng 
   1. Please use the issue template to ask questions, we don't know which version you are using, what is the configuration like.
   2. It is recommended that you use markdown to organize the text, the current content is difficult to read.
   3. I want to investigate this issue, can you provide the table structure? so that I can execute the same SQL.


-- 
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: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


[GitHub] [shardingsphere] ChenGengPeng commented on issue #24843: About the problems encountered in the process of using shardingsphere-proxy, seek solutions! ! !

Posted by "ChenGengPeng (via GitHub)" <gi...@apache.org>.
ChenGengPeng commented on issue #24843:
URL: https://github.com/apache/shardingsphere/issues/24843#issuecomment-1491339098

   Version: The mysql-connector used in apache-shardingsphere-5. 1.1 Shading is 8.0. 29, but the application uses 5 (because the project is too old, the code maintained since 2001, and there are too many things to modify to upgrade the connector)


-- 
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: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


[GitHub] [shardingsphere] RaigorJiang commented on issue #24843: About the problems encountered in the process of using shardingsphere-proxy, seek solutions! ! !

Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.
RaigorJiang commented on issue #24843:
URL: https://github.com/apache/shardingsphere/issues/24843#issuecomment-1489762452

   > ### Question
   > * version:apache-shardingsphere-5.1.1 shading中用的mysql-connector是8.0.29,但应用用的是5(原因是项目太老01年维护至今的代码,升级connextor要修改太多东西)
   > 
   > > 报错内容如下:
   > > `[2023-03-30 11:26:03  WARN org.hibernate.util.JDBCExceptionReporter:77] SQL Error: 1997, SQLState: C1997 
   
   @ChenGengPeng Hi, for English only, thank you!


-- 
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: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org