DatabaseService
Databases and JDBC drivers used to access databases are third-party products and are neither supported nor provided by Lobster. Any support or advice on databases or JDBC drivers that may nevertheless be provided by the Lobster support is voluntary and in no way implies a transfer of responsibility to them. The installation, operation and maintenance of databases/JDBC drivers, or measures carried out on them, are always and without exception the responsibility of the customer.
The Lobster support will of course be happy to assist you with the configurations necessary in Lobster_data to connect functioning third-party systems.
The DatabaseService allows neutral access to databases. The following is supported.
Connection pooling - Links to databases are opened and kept open in advance, so they can be accessed more quickly within applications.
Data type neutralisation - Database specific peculiarities of standard data types are neutralised, e.g. the format of date and time, so that no database-dependent conversions on the application side are necessary.
Automatic reconnection - The validity of an existing database connection is checked in regular intervals and reestablished automatically in the event of a connection loss.
Each connected database is represented by a so-called database alias, in which all database-relevant information is stored (connection parameters, etc.). The alias is used to access the database. A change of the underlying database is greatly facilitated this way.