Question 164:

When starting BL Banking the error message Can not open the database. appears.

Answer

Further in the error message there is: Database may be already in use.

This error message appears in multi-user installations, when a second user tries to start the program.

Please check the file jdbc.properties in the workspace directory. If you use the H2 database, the line for the URL should look as follows:

jdbc.url=jdbc\:h2\:${workspace_loc}/bl;AUTO_SERVER=true;AUTO_SERVER_PORT=9090;MVCC=true

If the part ;AUTO_SERVER=true;AUTO_SERVER_PORT=9090;MVCC=true is missing, please add it.

You can find further information on error messages of the H2 database here.

For multi-user installations an external database is recommended, e. g. MySQL. Then the line looks for example like this:

jdbc.url=jdbc\:mysql\://10.1.2.3\:3306/blbanking

where 10.1.2.3 is the IP address and blbanking the database name. Also then the line below for the driver is different:

jdbc.driver=com.mysql.jdbc.Driver