This dialog guides the user through the installation of a new database connection. Currently the Battery Manager supports databases like Oracle, MySQL, and Apache Derby (embedded database) which are normally provided by a server.
In the first step you can choose which database type to use. Here, the embedded database shipped with the Battery Manager (Apache Derby) or an external database may be selected. A new function here is to import connections from existing connection files where no manual editing is necessary any longer. Please choose the appropriate option here, then specify a file with connection data in the next step which has been e-mailed to you if you obtained a Leisenfels database hosting package.
![]() ![]() |
Please remember that multiple sessions with different database types (i.e. Oracle, MySQL) are supported only by the Enterprise Edition. The Personal Edition allows the use of the embedded database only while the Professional Edition is limited to connections for one single database type. |
If the embedded database has been chosen (default) the wizard navigates to the last page since all necessary settings have already been configured by the program. The embedded database is configured during the Battery Manager installation and has just to be started at this point in most cases and is ready for work then. With the Create new session option the wizard creates a new session window tab for you once the dialog has been closed using the Finish button.
If an external database has been chosen the database type like Oracle or MySQL is required now. Below this chooser please specify a unique name for the new connection. This name later appears as title of the session tab for this connection.
In the next step the wizard requests all parameters necessary for this connection of the desired database type where the values strongly depend on the local configuration of your database. The structure of this input form is the same as described by the input form for database connections section below and shall not be discussed here redundantly.
Once all settings are done and Next is clicked the wizard switches over to the last page where the connection is checked. With the Create new session option the wizard creates a new session window tab for you once the dialog has been closed using the Finish button. If the connection check has not been successful please move back using the Back button, modify the unproper settings, and try again.
The dialog for the management of database connections allows to create and maintain connections with local or remote servers. On the left side of the dialog window new connections can be created (plus symbol), existing connections can be deleted (red X), and selected connections can be copied (symbol with double document). Connections may be imported from files using the folder symbol, the associated save function is provided by the button to the right showing the diskette symbol. The order of the connection items can be alphabetically or in the order of creation. If the connections are shown as created (unordered) then the connections can be sorted manually by moving the items up or down. Invalid connections due to invalid configurations (e.g. because the used DBMS type is not supported) are shown with a stroke. The tool tip shows a message.
In order to adjust the existing connections please select the entry in the list. The settings for this connection are then displayed on the right side of the dialog. To check the current settings, please click the Check button at the bottom. A special dialog is opened where a connection can be established using the current settings. If the connection could not be established e.g. due to a missing password an appropriate message is displayed. Sometimes the log file of the software contains a hint why problems have occurred during connection tests (blocked/wrong ports, wrong password etc.).
Each connection can be given an appropriate name on the right side which can be adjusted later. At the top you can select the DBMS to be used. The combobox shows the available types like Oracle or MySQL. Depending on the selected DBMS the settings below may vary from connection to connection.
The connection settings are devided into Server and Expert options. The server options include:
If user name and password are required please edit the data in the text fields. If the password may be stored permanently so that is available for the next connects please enable the Save password flag. If the password shall be used for the next connect only please disable the flag. The password is not remembered then and has to be typed again the next time.
If your database has only one single schema for Battery Manager please modify the Database Schema entries appropriately (double-click the teble cell, save with ENTER). Instead of BATTMANDATA and BATTMANSYS you can set BATTMAN here for example. All tables are then created together in this schema.
The Expert options include:
Once all settings shown by the dialog are as desired you can connect to the selected servers by clicking the Connect button at the bottom of the dialog. If the selected connections are valid this button is enabled, disabled otherwise. For each connection a separate tab with the name of the connection will be displayed by the session window. With a click on the OK button the current settings will only be saved without creating new connections.
The database connection management may be called also from the tool bar by clicking a button. The preferences provide further settings for database connections, for example if connections of the session window shall be restored or not when the program is restarted.
With the New Session menu one can establish connections with configured server systems. The currently selected connection within the tool bar is used for this. This selection is automatically set to the current list selection each time the management dialog is closed so that one can work directly with the connection that has been edited last. For each connection a separate tab with the name of the connection will be displayed by the session window. If configured for the connection the management dialog is presented here where you can edit user name and password to login.
The function to create a new session may be called also from the tool bar by clicking a button.
The Connect menu is enabled if the session window is visible and the active connection tab is disabled which means that currently there is not connection to the server. Together with the Disconnect menu it is easily possible to keep connection tabs (sessions) permanently on the screen (see preferences) while the connection is established on demand and disconnected after use.
The Disconnect menu is enabled if the session window is visible and the active connection tab is enabled which means that the tab is currently connected to the server. Together with the Connect menu it is easily possible to keep connection tabs (sessions) permanently on the screen (see preferences) while the connection is established on demand and disconnected after use.
The Reconnect menu is enabled if the session window is visible and the active connection tab is enabled which means that the tab is currently connected to the server. If the menu is called the user is asked for user name and password so that the connection can be established for a different database user.
The embedded database shipped with Battery Manager may be started and stopped directly from the running application. A separate program does not exist to do this. Depending on the current state a symbol is displayed by the program status bar where the switch between the states on/off may be performed directly.
The final state of the embedded database (on/off) will be automatically restored the next time the program is started.
The embedded database shipped with Battery Manager may be started and stopped directly from the running application. A separate program does not exist to do this. Depending on the current state a symbol is displayed by the program status bar where the switch between the states on/off may be performed directly. Active sessions for the embedded database in the session window will be automatically deactivated when the database gets stopped.
The final state of the embedded database (on/off) will be automatically restored the next time the program is started.
For external databases it is required that users login using the deposited passwords. In order to reach a maximum of security passwords should be changed from time to time. This may be done by administrators using the appropriate database tools or by the users themselves. This task may be done by calling the Set/Change Password menu.
It is required that the current/old password is specified first, then the new password must be edited twice in order to avoid errors here. Once the password has been changed successfully the current connection is reconnected automatically based on the new settings. If the password for an external database is "changeme" then the user is automatically asked for a password change if a new session is created. This automatism allows for an easy first login and ensures that simple user passwords are changed to more secure values.
By default no password is set for the embedded database so that authentication with password is not necessary. If the database access shall be restricted a password may be deposited using a dialog here. This password has to be specified each time a new connection is established later. An existing password may be deactivated by deleting the password (leave the input fields empty).
Like other database applications also Battery Manager now provides support for user roles. A role is a special user group with specific access permissions for the software functions. Currently the database users can be assigned the following roles:
An administrator may add arbitrary users for the current database. The login depends on the user name each user logs into the database. Each database user can be assigned to one single role as listed above. If there are no roles defined by the database then each user is treated as an administrator with full access to the database. If at least one user has been assigned a role then the defined users and roles are automatically activated. While administrators have full access to database functions, read-only users may only view datasets (no write access).
Users (read-write) have full access to the database functions except for the backup routines (create/restore), the administration of users and roles, as well as the database table management. These functions are only allowed for administrators and normally not needed by normal users working with the database. Users (read-only) are more restricted than read-write users: only viewing is allowed for the database data. For example read-only users are not allowed to store or import measurements into the database or to edit datasets using the various forms. This role is useful for users like trainees who learn to use the Battery Manager software and are not allowed to apply any changes to the database.
The new role concept is used for external databases like Oracle or MySQL only, not for the embedded database since this has only one single user which is always an administrator.
A dialog is displayed where the datasets in the database tables of the active session in the session window are listed. Here you can delete all datasets using the Clear Tables button. This is necessary for example before backups may be restored (see section Database Backup).
![]() |
Please backup your database before the database tables are deleted with this function.
The data will be lost and may not be restored! |
Each license for the Battery Manager software contains pieces of information about the licensee (client). In order to associate each database connection with a client, parts of this information is stored also into the database.
If you have registered a new license please create a connection to your database in the session window and call the Edit Client Data menu item. Then choose a client from the license with the Client combobox to be used for this database. You can adjust the licensee data in the input fields below to your needs. For example some of these values are used for printing.