1

I am developing a web project with HSQLDB persistence. My database instance is on server mode, therefore, I need to run a cmd script/ Java method to access my schema.

Tomcat is the container I use to drop my war on port 8080. Gradle is my build system.

Currently I am using the following main method before I deploy my app to properly access my database on runtime:

public static void main(String[] args) throws IOException, ServerAcl.AclFormatException {

    final String URL = "file:~/db/cursago";
    String user = "user";
    String password = "password";
    HsqlProperties p = new HsqlProperties();
    p.setProperty("server.database.0",URL+";user="+user+";password="+password);
    p.setProperty("server.dbname.0","cursago");

    Server server = new Server();
    server.setProperties(p);
    server.setLogWriter(null);
    server.setErrWriter(null);
    server.start();
    System.out.println("Database is running with path: " + URL);
    System.out.println("Username: " + user+", Password: " + password);

}

I would like to know if there's a way of making Tomcat/Gradle/IntelliJ IDEA run this main method before a project deploy, instead of running this script by hand.

best wishes
  • 5,789
  • 1
  • 34
  • 59
Lautaro Paskevicius
  • 185
  • 3
  • 14
  • why not create a jar containing this code lets name that jar hsqldb-runner. run that jar using `java -jarhsqldb-runner.jar` and then start the tomcat. – best wishes Apr 07 '18 at 15:35
  • I am currently runnning this main method before I start tomcat; I think creating a jar and running it would be the same – Lautaro Paskevicius Apr 07 '18 at 15:55

1 Answers1

0

from here:

you could run the content of your main in the onApplicationEvent like:

public class ApplicationListenerBean implements ApplicationListener<ContextRefreshedEvent> {

        @Override
        public void onApplicationEvent(ContextRefreshedEvent event) {
        final String URL = "file:~/db/cursago";
        String user = "user";
        String password = "password";
        HsqlProperties p = new HsqlProperties();
        p.setProperty("server.database.0",URL+";user="+user+";password="+password);
        p.setProperty("server.dbname.0","cursago");

        Server server = new Server();
        server.setProperties(p);
        server.setLogWriter(null);
        server.setErrWriter(null);
        server.start();
        System.out.println("Database is running with path: " + URL);
        System.out.println("Username: " + user+", Password: " + password);               
    }
}

This will trigger on every event, that could be application started or redeployed and happens before your application handles requests.

You also can wire in your properties.

There are some difficulties if the server is already running and it can't run in this scope only.

sschrass
  • 7,014
  • 6
  • 43
  • 62