xigongxiaoche opened a new issue, #31419:
URL: https://github.com/apache/shardingsphere/issues/31419
5.4.1 start proxy failed, reported Property useServerPrepStmts does not
exist on target class com.zaxxer.hikari.HikariDataSource, how to solve the
problem? Does it need me to modify the source code of hikarip and recompile it?
mysql version: 8.0.31
shardingsphere proxy: 5.4.1
config:
```
databaseName: benchmarksql
localRoot:
databaseName: benchmarksql
dataSources:
benchmarksql:
dataSourceClassName: com.zaxxer.hikari.HikariDataSource
driverClassName: com.mysql.cj.jdbc.Driver
url:
jdbc:mysql://***:3306/benchmarksql?useSSL=false&allowPublicKeyRetrieval=true
username: ***
password: ***
```
stack:
```
Exception in thread "main" java.lang.RuntimeException: Property
useServerPrepStmts does not exist on target class
com.zaxxer.hikari.HikariDataSource
at com.zaxxer.hikari.util.PropertyElf.setProperty(PropertyElf.java:135)
at
com.zaxxer.hikari.util.PropertyElf.lambda$setTargetFromProperties$0(PropertyElf.java:59)
at
java.base/java.util.concurrent.ConcurrentHashMap.forEach(ConcurrentHashMap.java:1603)
at java.base/java.util.Properties.forEach(Properties.java:1422)
at
com.zaxxer.hikari.util.PropertyElf.setTargetFromProperties(PropertyElf.java:54)
at
com.zaxxer.hikari.pool.PoolBase.initializeDataSource(PoolBase.java:328)
at com.zaxxer.hikari.pool.PoolBase.<init>(PoolBase.java:114)
at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:108)
at
com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112)
at
org.apache.shardingsphere.infra.datasource.pool.CatalogSwitchableDataSource.getConnection(CatalogSwitchableDataSource.java:46)
at
org.apache.shardingsphere.infra.state.datasource.DataSourceStateManager.checkState(DataSourceStateManager.java:86)
at
org.apache.shardingsphere.infra.state.datasource.DataSourceStateManager.initState(DataSourceStateManager.java:81)
at
org.apache.shardingsphere.infra.state.datasource.DataSourceStateManager.lambda$initStates$0(DataSourceStateManager.java:72)
at java.base/java.util.LinkedHashMap.forEach(LinkedHashMap.java:721)
at
org.apache.shardingsphere.infra.state.datasource.DataSourceStateManager.initStates(DataSourceStateManager.java:72)
at
org.apache.shardingsphere.mode.metadata.NewMetaDataContextsFactory.lambda$checkDataSourceStates$2(NewMetaDataContextsFactory.java:129)
at java.base/java.util.LinkedHashMap.forEach(LinkedHashMap.java:721)
at
org.apache.shardingsphere.mode.metadata.NewMetaDataContextsFactory.checkDataSourceStates(NewMetaDataContextsFactory.java:127)
at
org.apache.shardingsphere.mode.metadata.NewMetaDataContextsFactory.create(NewMetaDataContextsFactory.java:90)
at
org.apache.shardingsphere.mode.metadata.NewMetaDataContextsFactory.create(NewMetaDataContextsFactory.java:71)
at
org.apache.shardingsphere.mode.manager.standalone.NewStandaloneContextManagerBuilder.build(NewStandaloneContextManagerBuilder.java:53)
```
--
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]
