Overview

(1) Manage drivers: Opens a dialogue for managing the database drivers under ./extlib. Note: Please upload JDBC drivers only as .jar files. Afterwards a restart of the Integration Server is necessary. To check whether the driver has been loaded correctly, you can search for the name of your .jar file in file./logs/wrapper.log (Windows) or ./logs/console.txt (Linux).

(2) Business Connector: Selection of a Business Connector (Input Agent cron). Please contact information@lobster.de. Note: See also section "Update Center".

(3) Column left: Indicates whether it is a classic database connection (as you know it) or a Business Connector (plug symbol). You can recognise the database for Lobster Integration itself by the green icon.

Creating new database connection

You can create a new database connection via the plus symbol at the bottom right or via the context menu. Connections that you create here no longer have to be maintained in the configuration file ./etc/database.xml, you can work exclusively in the GUI. In addition, no restart of the Integration Server is necessary, only for newly uploaded drivers (see above).

(4) JDBC Properties: See section DatabaseService for details.

(5) Select template: Here you can select pre-configured connection templates. Note: You can obtain the latest templates via the Update-Center.

• On the left, you will find classic database connections. Replace the placeholders DB_HOST_OR_IP and DB_NAME with your specific values. If required, fill in missing fields and JDBC properties such as Catalog Name, User, Password, etc.

• On the right, you will find Connectors.

(6) Allow empty catalog name: If this checkbox is set, field Catalog Name can be left empty. If the checkbox is not set and the Catalog Name field is empty, the alias name is automatically entered there.

Connection test

You can perform a connection test via the context menu of a selected connection. A standard SQL query is executed in the background. You will receive a simple success or error message as feedback. Note: For CData connections, you must enter a suitable SQL query yourself.

See also the following section.

Database access via GUI tools

• Plugin SQL console.

• Admin Console → SQL monitor.

Database access in Input Agents in phase 1

• Basic SQL (Input Agent cron).

• Business Connector (Input Agent cron) (paid connectors and classes DefaultFileSQLCron, DefaultSQLCron, CrossSQLCron)

Database access via functions in phase 3

• select into list()

• select into map(a,b,[param &1 = c], d,e, f,g,h,i,j], delimiter k, map l,m,n,o,p)

• select into map(a,b,list name c, delimiter d, map e,f,g,h,i)

• select-statement a [[param &1 = c], d,e, f,g,h,i,j], default k,l,m,n dbAlias = b

• call db procedure a, alias b, [c,d,e,f,g,h,i,j],k,l,m,[n],o,[p]

• call db procedure a, alias b,c,d,e,f

• call db procedure a with ResultSet()

• call db procedure a with ResultSet into Map/List()

• update()

• update-statement()

• exists db-row()

• set-vars()

Relevant system variables

• VAR_SYS_EXCEPTION_STACKTRACE

• VAR_SYS_HAS_SQL_ERROR

Database access in phase 4

See section "Phase 4".