Display the connection url

[flyway]

Original author: rotscher...@gmail.com (January 22, 2013 10:22:00)

Display the url and user which is used to connect to the database. Especially when having multiple database instances it's always a blind flight if really the correct profile/configuration is activated.

See attached patch as a proposal how this could be implemented.

Original issue: http://code.google.com/p/flyway/issues/detail?id=422

[flyway]

From axel.fontaine.business@gmail.com on January 22, 2013 11:59:22
Hi Roger,

thanks for your suggestion. The however won't work as users are able to pass any DataSource object they wish to Flyway.

A workaround could be for you to wrap your DataSource object with a class that would print out the url and user when DataSource.getConnection is called.

Cheers
Axel

[flyway]

From axel.fontaine.business@gmail.com on January 22, 2013 13:28:41
Well, a little more research shows that it might be possible after all: http://stackoverflow.com/questions/5718952/how-to-get-database-url-from-java-sql-connection

Reopening.

[flyway]

From rotscher...@gmail.com on February 02, 2013 15:29:52
Hi Axel,

I somehow missed your second post :-(

However, when using maven, I don't know how to use a different datasource implementation without subclassing all the Mojos (and I'd like to avoid that).

I'll have a look at this post from stackoverflow. I'll come up with a pull request as soon as I have a solution.

Cheers
Rotsch

[flyway]

From rotscher...@gmail.com on February 08, 2013 10:45:46
The connection thing only works when the connection can be established, that means when the configuration is correct. When the configuratin is not correct there are exceptions and the connection is null. And then I'd like to see the configuration for debugging it.

So, I have another proposal:
https://github.com/rotscher/flyway/commit/964f8c17c27111d014e9b25c30542a8e96722c8f

Cheers
Rotsch