Loading SQL script in Vertx

Question

I have been trying to load the SQL script schema into MySQL DB using Vertx.
Though, i am able to load or update any single DB command but unable to load complete schema in one go.

The second challenge faced is that, this might be blocking code for Vertx application. If that is the case, how can it be avoided?

Here is the code snippet i have been trying to execute:

  jdbcClient.getConnection(resConn -> {

                    if(resConn.succeeded()) {

                        SQLConnection connection = resConn.result();

                        connection.execute("<Trying to load the SQL Script schema>", resSchema -> {


                            connection.close();
                            if(resSchema.succeeded()) {

                                async.complete();
                            } else {
                                testContext.fail("Failed to load bootstrap schema: " + resSchema.cause().getMessage());
                            }
                        });
                    } else {
                        testContext.fail("Failed to obtain DB connection for schema write");
                    }
                });

Answer 1

The MySQL JDBC driver does not allow to execute a file as a SQL script. You must parse the script and execute individual commands one by one.