How can we help you today? How can we help you today?
tpurcell
Activity overview Badges (0) Posts (1) Comments (4)

Comments

Sort by recent activity
Peter Thanks for your response. Here are the versions in my pom:         <flyway.version>9.17.0</flyway.version>         <spanner.plugin.version>9.17.0-beta</spanner.plugin.version> As for your output, I see the same thing but if you review my post from 4/27 you'll notice that Flyway succeeds on firstConnect but then everything falls apart later in the process: 2023-04-27 16:46:10,795 INFO  IAN=           REMOTE=                   [com.ingrid.ibp.SpannerAdmin] (main) ugh Unsupported Database: Google Cloud Spanner 1.0 org.flywaydb.core.api.FlywayException: Unsupported Database: Google Cloud Spanner 1.0         at org.flywaydb.core.internal.database.DatabaseTypeRegister.getDatabaseTypeForConnection(DatabaseTypeRegister.java:105)         at org.flywaydb.core.internal.jdbc.JdbcConnectionFactory.<init>(JdbcConnectionFactory.java:75)         at org.flywaydb.core.FlywayExecutor.execute(FlywayExecutor.java:140)         at org.flywaydb.core.Flyway.migrate(Flyway.java:129)         at com.ingrid.ibp.SpannerAdmin.flywayDatasource(SpannerAdmin.java:156) It looks like SORTED_DATABASE_TYPES in DatabaseTypeRegister is set to a new instance of PluginRegister: private static final List<DatabaseType> SORTED_DATABASE_TYPES = new PluginRegister().getPlugins(DatabaseType.class).stream().sorted().collect(Collectors.toList()); As a result it ignores the configured values. Thanks Tom / comments
  1. Community
  2. Flyway (General Discussion)
  3. Java API fails accessing GCP Spanner
PeterThanks for your response. Here are the versions in my pom:        <flyway.version>9.17.0</flyway.version>        <spanner.plugin.version>9.17.0-beta</spanner.plugin.version> As for your output...
0 votes
Hello I have found a solution. In my 4/28 post I indicated that I "solved" the issue by: I downloaded the flyway source from git: https://github.com/flyway/flyway I updated this file: https://github.com/flyway/flyway/blob/main/flyway-core/src/main/resources/META-INF/services/org.flywaydb.core.extensibility.Plugin By adding:       org.flywaydb.database.spanner.SpannerDatabaseType       org.flywaydb.database.SpannerDatabaseExtension The I built a flyway snapshot, built my code with that, then ran the code. I have found a similar solution that does not require rebuilding Flyway source. In my java project I added the following file:      src/main/resources/META-INF/services/org.flywaydb.core.extensibility.Plugin The contents of the file: org.flywaydb.database.spanner.SpannerDatabaseType org.flywaydb.database.SpannerDatabaseExtension org.flywaydb.core.internal.schemahistory.BaseAppliedMigration org.flywaydb.core.internal.resource.CoreResourceTypeProvider org.flywaydb.core.internal.command.clean.CleanModeConfigurationExtension org.flywaydb.core.internal.configuration.resolvers.EnvironmentVariableResolver org.flywaydb.core.internal.proprietaryStubs.CommandExtensionStub org.flywaydb.core.api.output.InfoHtmlRenderer org.flywaydb.core.internal.reports.json.InfoResultDeserializer org.flywaydb.core.api.output.MigrateHtmlRenderer org.flywaydb.core.internal.reports.json.MigrateResultDeserializer org.flywaydb.core.api.output.HoldingRenderer org.flywaydb.core.api.output.DashboardRenderer With that all migrations, both Java and SQL, run successfully. Thanks Tom / comments
  1. Community
  2. Flyway (General Discussion)
  3. Java API fails accessing GCP Spanner
HelloI have found a solution. In my 4/28 post I indicated that I "solved" the issue by:I downloaded the flyway source from git: https://github.com/flyway/flywayI updated this file: https://github....
0 votes
Okay,   So I've changed my code slightly to altered the configuration:             SpannerDatabaseType spannerDatabaseType = new SpannerDatabaseType();             SpannerDatabaseExtension spannerDatabaseExtension = new SpannerDatabaseExtension();             ClassicConfiguration classicConfiguration = new ClassicConfiguration();             classicConfiguration.getPluginRegister().REGISTERED_PLUGINS.add(spannerDatabaseExtension);             classicConfiguration.getPluginRegister().REGISTERED_PLUGINS.add(spannerDatabaseType);             classicConfiguration.setDataSource(jdbcDataSource);             Flyway flyway = Flyway.configure().configuration(classicConfiguration).load(); As I step through the code in a debugger I find that everything goes fine up to:              org.flywaydb.core.internal.jdbc.JdbcConnectionFactory#JdbcConnectionFactory In that class the following line succeeds and gets the first connection to the database:             this.databaseType = DatabaseTypeRegister.getDatabaseTypeForConnection(firstConnection); At this point this what REGISTERED_PLUGINS looks like:             configuration.getPluginRegister().REGISTERED_PLUGINS result = {ArrayList@5234}  size = 22              0 = {SpannerDatabaseExtension@5236}              1 = {SpannerDatabaseType@5237} "Google Cloud Spanner"              2 = {CockroachDBDatabaseType@5238} "CockroachDB"              3 = {RedshiftDatabaseType@5239} "Redshift"              4 = {DB2DatabaseType@5240} "DB2"              5 = {DerbyDatabaseType@5241} "Derby"              6 = {H2DatabaseType@5242} "H2"              7 = {HSQLDBDatabaseType@5243} "HSQLDB"              8 = {InformixDatabaseType@5244} "Informix"              9 = {OracleDatabaseType@5245} "Oracle"              10 = {PostgreSQLDatabaseType@5246} "PostgreSQL"              11 = {SAPHANADatabaseType@5247} "SAP HANA"              12 = {SnowflakeDatabaseType@5248} "Snowflake"              13 = {SQLiteDatabaseType@5249} "SQLite"              14 = {SybaseASEJConnectDatabaseType@5250} "Sybase ASE"              15 = {SybaseASEJTDSDatabaseType@5251} "Sybase ASE"              16 = {TestContainersDatabaseType@5252} "Test Containers"              17 = {BaseAppliedMigration@5253}              18 = {CoreResourceTypeProvider@5254}              19 = {PostgreSQLConfigurationExtension@5255}              20 = {CleanModeConfigurationExtension@5256}              21 = {EnvironmentVariableResolver@5257} And firstConnection: result = {JdbcConnection@5222}              typeMap = {HashMap@5273}  size = 0              connectionUrl = "jdbc:cloudspanner://localhost:9010/projects/<obfuscated>?usePlainText=true"              options = {ConnectionOptions@5275} "cloudspanner://localhost:9010/<obfuscated>?usePlainText=true"              spanner = {ConnectionImpl@5276}              clientInfo = {Properties@5277}  size = 0              parser = null              firstWarning = null              lastWarning = null So we have successfully connected to the spanner instance. But then in DatabaseTypeRegister.getDatabaseTypeForConnection SORTED_DATABASE_TYPES resolves to: result = {ArrayList@5423}  size = 15              0 = {CockroachDBDatabaseType@5425} "CockroachDB"              1 = {RedshiftDatabaseType@5426} "Redshift"              2 = {DB2DatabaseType@5427} "DB2"              3 = {DerbyDatabaseType@5428} "Derby"              4 = {H2DatabaseType@5429} "H2"              5 = {HSQLDBDatabaseType@5430} "HSQLDB"              6 = {InformixDatabaseType@5431} "Informix"              7 = {OracleDatabaseType@5432} "Oracle"              8 = {PostgreSQLDatabaseType@5433} "PostgreSQL"              9 = {SAPHANADatabaseType@5434} "SAP HANA"              10 = {SnowflakeDatabaseType@5435} "Snowflake"              11 = {SQLiteDatabaseType@5436} "SQLite"              12 = {SybaseASEJConnectDatabaseType@5437} "Sybase ASE"              13 = {SybaseASEJTDSDatabaseType@5438} "Sybase ASE"              14 = {TestContainersDatabaseType@5439} "Test Containers" NOTE: SpannerDatabaseType is gone from the list. And so: 2023-04-27 16:46:10,795 INFO  IAN=           REMOTE=                   [com.ingrid.ibp.SpannerAdmin] (main) ugh Unsupported Database: Google Cloud Spanner 1.0 org.flywaydb.core.api.FlywayException: Unsupported Database: Google Cloud Spanner 1.0         at org.flywaydb.core.internal.database.DatabaseTypeRegister.getDatabaseTypeForConnection(DatabaseTypeRegister.java:105)         at org.flywaydb.core.internal.jdbc.JdbcConnectionFactory.<init>(JdbcConnectionFactory.java:75)         at org.flywaydb.core.FlywayExecutor.execute(FlywayExecutor.java:140)         at org.flywaydb.core.Flyway.migrate(Flyway.java:129)         at com.ingrid.ibp.SpannerAdmin.flywayDatasource(SpannerAdmin.java:156) It looks like SORTED_DATABASE_TYPES in DatabaseTypeRegister is set to a new instance of PluginRegister: private static final List<DatabaseType> SORTED_DATABASE_TYPES = new PluginRegister().getPlugins(DatabaseType.class).stream().sorted().collect(Collectors.toList()); As a result it ignores the configured values. Please let me know if I'm missing something in the config or should be taking a different approach. Thanks Tom / comments
  1. Community
  2. Flyway (General Discussion)
  3. Java API fails accessing GCP Spanner
Okay, So I've changed my code slightly to altered the configuration:             SpannerDatabaseType spannerDatabaseType = new SpannerDatabaseType();            SpannerDatabaseExtension spannerData...
0 votes
All right I got this to work but I don't think its the best solution. I downloaded the flyway source from git: https://github.com/flyway/flyway I updated this file: https://github.com/flyway/flyway/blob/main/flyway-core/src/main/resources/META-INF/services/org.flywaydb.core.extensibility.Plugin By adding:       org.flywaydb.database.spanner.SpannerDatabaseType       org.flywaydb.database.SpannerDatabaseExtension The I built a flyway snapshot, built my code with that, then ran the code. Everything worked. I'd rather not continue to use a locally built snapshot. Is there some configuration setting I can use yo add the GCP Spanner classes to the services META-INF? Thanks Tom / comments
  1. Community
  2. Flyway (General Discussion)
  3. Java API fails accessing GCP Spanner
All rightI got this to work but I don't think its the best solution.I downloaded the flyway source from git: https://github.com/flyway/flywayI updated this file: https://github.com/flyway/flyway/...
0 votes
Total activity
6
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
1