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 2019/06/03 02:30:48 UTC
[GitHub] [incubator-shardingsphere] MoonPaul commented on issue #2488:
sharding-jdbc 3.0.0 can not use flyway
MoonPaul commented on issue #2488: sharding-jdbc 3.0.0 can not use flyway
URL: https://github.com/apache/incubator-shardingsphere/issues/2488#issuecomment-498093136
sharding-jdbc 3.0.0
spring-boot 2.1
flyway 5.2.1
can not execute the program with error:
Caused by: org.flywaydb.core.internal.exception.FlywaySqlException:
Unable to restore original schema
---------------------------------
SQL State : null
Error Code : 0
Message : setCatalog
at org.flywaydb.core.internal.database.base.Connection$2.call(Connection.java:171) ~[flyway-core-5.2.1.jar:na]
at org.flywaydb.core.internal.database.base.Connection$2.call(Connection.java:165) ~[flyway-core-5.2.1.jar:na]
at org.flywaydb.core.internal.jdbc.TransactionTemplate.execute(TransactionTemplate.java:74) ~[flyway-core-5.2.1.jar:na]
at org.flywaydb.core.internal.database.base.Connection.restoreOriginalSchema(Connection.java:165) ~[flyway-core-5.2.1.jar:na]
at org.flywaydb.core.internal.database.base.Connection.close(Connection.java:159) ~[flyway-core-5.2.1.jar:na]
at org.flywaydb.core.internal.database.base.Database.close(Database.java:473) ~[flyway-core-5.2.1.jar:na]
at org.flywaydb.core.Flyway.execute(Flyway.java:1716) ~[flyway-core-5.2.1.jar:na]
at org.flywaydb.core.Flyway.migrate(Flyway.java:1341) ~[flyway-core-5.2.1.jar:na]
at org.springframework.boot.autoconfigure.flyway.FlywayMigrationInitializer.afterPropertiesSet(FlywayMigrationInitializer.java:66) ~[spring-boot-autoconfigure-2.1.0.RELEASE.jar:2.1.0.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1804) ~[spring-beans-5.1.2.RELEASE.jar:5.1.2.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1741) ~[spring-beans-5.1.2.RELEASE.jar:5.1.2.RELEASE]
... 18 common frames omitted
Caused by: java.sql.SQLFeatureNotSupportedException: setCatalog
at io.shardingsphere.shardingjdbc.jdbc.unsupported.AbstractUnsupportedOperationConnection.setCatalog(AbstractUnsupportedOperationConnection.java:96) ~[sharding-jdbc-core-3.0.0.jar:na]
at org.flywaydb.core.internal.database.mysql.MySQLConnection.doChangeCurrentSchemaOrSearchPathTo(MySQLConnection.java:57) ~[flyway-core-5.2.1.jar:na]
at org.flywaydb.core.internal.database.base.Connection$2.call(Connection.java:169) ~[flyway-core-5.2.1.jar:na]
... 28 common frames omitted
it looks like sharding-jdbc can not work with flyway or i make a mistake?
if sharding 3.0.0 can not work with flyway, is there any other db schema control tools works with sharding well?
or i need to modify the code in sharding-jdbc to support a db scheam control tool?
----------------------------------------------------------------
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
With regards,
Apache Git Services