How to load sql script file using INIT=RUNSCRIPT FROM 'mytestscript.sql' and check it's loaded or not

Question

I am trying to execute some sql script using

property name="url" value="someurl;INIT=RUNSCRIPT FROM 'mytestscript.sql';

I am not sure -

Sql script file loaded or not, Since these configuration has been done for Junit using H2 database i can't run query to verify the same in database

Evgenij Ryazanov · Accepted Answer · 2019-10-25 09:07:45Z

0

If you're sure that connection URL is used by your test system as is and the same database is not already open without such INIT parameter, you can be sure that script will be executed completely without any errors, H2 does not open a connection if INIT wasn't completed normally, an SQLException will be thrown on connection attempt.

answered Oct 25, 2019 at 9:07

Evgenij Ryazanov

8,3932 gold badges15 silver badges24 bronze badges

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

1 Comment

userbitu Over a year ago

Thanks @Evgenij. This stackoverflow.com/questions/4490138/… worked for me. I had my script in different directory than resources.

Collectives™ on Stack Overflow

How to load sql script file using INIT=RUNSCRIPT FROM 'mytestscript.sql' and check it's loaded or not

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related