Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Redshift JDBC 4.2 driver support #1733

Closed
jeffreytli opened this issue Aug 2, 2017 · 2 comments
Closed

Redshift JDBC 4.2 driver support #1733

jeffreytli opened this issue Aug 2, 2017 · 2 comments

Comments

@jeffreytli
Copy link

@jeffreytli jeffreytli commented Aug 2, 2017

What version of Flyway are you using?

4.2.0

Which client are you using? (Command-line, Java API, Maven plugin, Gradle plugin, SBT plugin, ANT tasks)

Command-line

What database are you using (type & version)?

Redshift JDBC 4.2

What operating system are you using?

Mac OS 10.11.6

What did you do?

(Please include the content causing the issue, any relevant configuration settings, and the command you ran)
I tried running the following command: flyway migrate with the username, password, and url defined in flyway.conf.

What did you expect to see?

I expected it to succeed and output:

Creating Metadata table: "PUBLIC"."schema_version"
Current version of schema "PUBLIC": << Empty Schema >>
Migrating schema "PUBLIC" to version 1 - Create person table
Successfully applied 1 migration to schema "PUBLIC" (execution time 00:00.062s).
What did you see instead?

After running the above mentioned command, I get the following error: ERROR: Unable to instantiate JDBC driver: com.amazon.redshift.jdbc42.Driver : com.amazon.redshift.jdbc42.Driver.

Other notes

I downloaded the Redshift JDBC driver from here, and moved the 4.2 driver into the drivers directory. After digging around, I'm seeing that only 4.1 is currently supported. Are there any plans on supporting 4.2 in the near future? Or is this already supported and I'm just not configuring Flyway properly?

@axelfontaine
Copy link
Contributor

@axelfontaine axelfontaine commented Aug 3, 2017

What is the output if you add -X?

aleskiewicz added a commit to aleskiewicz/flyway that referenced this issue Aug 28, 2017
Universal Driver classname was intoduced in Amazon Redshift JDBC Driver 1.2.7. It simplifies usage of Redshift with different JDBC versions (fixes flyway#1733)
aleskiewicz added a commit to aleskiewicz/flyway that referenced this issue Aug 28, 2017
Universal Driver classname was introduced in Amazon Redshift JDBC Driver
1.2.1. It simplifies usage of Redshift with different JDBC versions
(fixes flyway#1733)
@axelfontaine axelfontaine changed the title Redshift JDBC 4.2 not supported? Redshift JDBC 4.2 driver support Nov 15, 2017
@axelfontaine
Copy link
Contributor

@axelfontaine axelfontaine commented Nov 15, 2017

This has now been implemented.

@axelfontaine axelfontaine added this to the Flyway 5.0.0 milestone Nov 15, 2017
axelfontaine added a commit to flyway/flywaydb.org that referenced this issue Nov 15, 2017
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
2 participants