You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2020/06/02 03:00:46 UTC
[GitHub] [shardingsphere] baobeidaodao opened a new issue #5882: Sharding 4.1.0 and Spring-boot 2.3.0 incompatible? SQLFeatureNotSupportedException: isValid
baobeidaodao opened a new issue #5882:
URL: https://github.com/apache/shardingsphere/issues/5882
When I use sharding-jdbc-spring-boot-starter:4.1.0 and spring-boot:2.2.7 , it works well .
After upgrade spring-boot:2.3.0 , it throws an exception:
org.springframework.dao.InvalidDataAccessApiUsageException: ConnectionCallback; isValid; nested exception is java.sql.SQLFeatureNotSupportedException: isValid
Is this a bug or compatibility problem ?
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] baobeidaodao commented on issue #5882: Sharding 4.1.0 and Spring-boot 2.3.0 incompatible? SQLFeatureNotSupportedException: isValid
Posted by GitBox <gi...@apache.org>.
baobeidaodao commented on issue #5882:
URL: https://github.com/apache/shardingsphere/issues/5882#issuecomment-637357419
My project dependencies list contains spring-boot-starter-actuator:2.3.0. It will check application health status. also it will check db connections use SQL such as "select 1". During that moment, the exception was thrown.
Maybe this is the problem.
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] wuxingye commented on issue #5882: Sharding 4.1.0 and Spring-boot 2.3.0 incompatible? SQLFeatureNotSupportedException: isValid
Posted by GitBox <gi...@apache.org>.
wuxingye commented on issue #5882:
URL: https://github.com/apache/shardingsphere/issues/5882#issuecomment-643211120
https://blog.csdn.net/qq_33547169/article/details/106648132
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] kimmking closed issue #5882: Sharding 4.1.0 and Spring-boot 2.3.0 incompatible? SQLFeatureNotSupportedException: isValid
Posted by GitBox <gi...@apache.org>.
kimmking closed issue #5882:
URL: https://github.com/apache/shardingsphere/issues/5882
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] kimmking commented on issue #5882: Sharding 4.1.0 and Spring-boot 2.3.0 incompatible? SQLFeatureNotSupportedException: isValid
Posted by GitBox <gi...@apache.org>.
kimmking commented on issue #5882:
URL: https://github.com/apache/shardingsphere/issues/5882#issuecomment-637361753
The root of ex cause: shardingsphere-jdbc/shardingsphere-jdbc-core/src/main/java/org/apache/shardingsphere/driver/jdbc/unsupported/AbstractUnsupportedOperationConnection.java
```
@Override
public final boolean isValid(final int timeout) throws SQLException {
throw new SQLFeatureNotSupportedException("isValid");
}@Override
public final boolean isValid(final int timeout) throws SQLException {
throw new SQLFeatureNotSupportedException("isValid");
}
```
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] cy503328434 commented on issue #5882: Sharding 4.1.0 and Spring-boot 2.3.0 incompatible? SQLFeatureNotSupportedException: isValid
Posted by GitBox <gi...@apache.org>.
cy503328434 commented on issue #5882:
URL: https://github.com/apache/shardingsphere/issues/5882#issuecomment-683647525
because of health check, just close it.
`management.health.db.enabled=false`
or
```
management:
health:
db:
enabled: false
```
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] kimmking commented on issue #5882: Sharding 4.1.0 and Spring-boot 2.3.0 incompatible? SQLFeatureNotSupportedException: isValid
Posted by GitBox <gi...@apache.org>.
kimmking commented on issue #5882:
URL: https://github.com/apache/shardingsphere/issues/5882#issuecomment-642552300
This method for test connection is valid, and could be instead of "select 1" checking.
So we should discuss about supporting it or not.
@terrymanu @menghaoranss
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] wuxingye commented on issue #5882: Sharding 4.1.0 and Spring-boot 2.3.0 incompatible? SQLFeatureNotSupportedException: isValid
Posted by GitBox <gi...@apache.org>.
wuxingye commented on issue #5882:
URL: https://github.com/apache/shardingsphere/issues/5882#issuecomment-643210009
how to solve in current version, 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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] kimmking edited a comment on issue #5882: Sharding 4.1.0 and Spring-boot 2.3.0 incompatible? SQLFeatureNotSupportedException: isValid
Posted by GitBox <gi...@apache.org>.
kimmking edited a comment on issue #5882:
URL: https://github.com/apache/shardingsphere/issues/5882#issuecomment-637361753
The root of ex cause: shardingsphere-jdbc/shardingsphere-jdbc-core/src/main/java/org/apache/shardingsphere/driver/jdbc/unsupported/AbstractUnsupportedOperationConnection.java
```
@Override
public final boolean isValid(final int timeout) throws SQLException {
throw new SQLFeatureNotSupportedException("isValid");
}
```
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org