Multiple SQL statements in flyway.initSql

Question

Is something like this possible and if yes, is initSql executed each time a connection is established? For example i want to make sure that on each connection the time zone is set to UTC. Or is there a better way to execute connection-init-sql statements?

flyway:
  datasources:
      default:
          initSql: SET ROLE test_role; SET time zone 'UTC'; <--- is this second statement executed?

Thanks!

Kendra Little · Accepted Answer · 2021-01-07 09:47:44Z

3

Yes, initsql supports multiple statements. It is run "to initialize a new database connection immediately after opening it," so yes, it's run each time a connection is established.

For example, against a test SQL Server database, I ran:

flyway -initSql="select 1; select 2" info

This output the normal content of flyway info, but also included the following after the usual connection info header:

answered Jan 7, 2021 at 9:47

Kendra Little

4202 silver badges6 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

svrdoljak Over a year ago

Thank you! I did solve my issue just like you explained :)

Collectives™ on Stack Overflow

Multiple SQL statements in flyway.initSql

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related