Wiki source code of DB-Verbindungen

Hide last authors
awa 1.1 1 {{content/}}
2
3 {{id name="fig_data_db_con"/}}
4
fse 7.1 5 {{figure image="data_db_con_en.png" clear="h1"}}Creating a DB connection in {{formcycle case="dat"/}}. (1) To the left is a list of existing database connections. (2) On the right users can configure the selected database connection.{{/figure}}
awa 1.1 6
fse 7.1 7 Database connections pose a possibility to record data connections to different data bases, apart from location and type, centrally. You can access deposited file connections later comfortably, for example in ""actions" (data base) or "[[DB querys>>doc:DBQueries]]", without all users having to know the access information.
awa 1.1 8
fse 7.1 9 == Create database connection ==
awa 1.1 10
fse 7.1 11 * Open the module "DB-connections" and click on the button "New" {{ficon name="plus-circle-outline"/}} in the header of the list (see [[figure>>||anchor="fig_data_db_con"]]).
12 * Allocate a various alias and an optional description.
13 * For the data base connection itself, the following data is necessary:
14 ** **Name**: Name for this database connection.
15 ** **Description**: Description of the database connection
16 ** **Type:** Type of the database management system. Currently we support Oracle® MySQL, Oracle® Database, PostgreSQL, Microsoft® SQL Server and "Other (JDBC)".
17 {{version major="7" minor="0" patch="10"}}{{/version}} The H2 database driver is no longer supplied by {{formcycle/}} since version 7.0.10 and has to be installed manually like the drivers of the other database types.
18 ** **JDBC URL**: The JDBC URL of the database server
19 ** **JDBC driver**:The name of the JDBC driver if the type is //Other (JDBC)//. This value can automatically be set with the button "Determine", otherwise please refer to [[database drivers>>doc:Formcycle.SystemSettings.DatabaseDrivers||rel="__blank"]]
20 ** **Username**: Username of the database user.
21 ** **Password**: Password of the data base user.
22 ** **Number of connections at once**: Number of connections to the data base at once. On a great many of accesses to this connection, the value should be > 10. Notice here the utilization of the database server if necessary and accommodate the settings correspondingly. Normally the default setting 10 should be enough. Confirm the information with the button "Save".
23 ** **Timeout**: The idle timeout in milliseconds before the a database-connection is closed.
awa 1.1 24
fse 7.1 25 * After creating the DB-connection, it appears in the left part (list) of the connections.
awa 1.1 26
fse 7.1 27 Before saving you have the opportunity to test the connection. Press the button //Test connection// to check if the connection can be established. If no connection could be established, read the error message carefully. If it does not help you, contact a system administrator.
awa 1.1 28
fse 7.1 29 == Upload and execute script data ==
awa 1.1 30
fse 7.1 31 If you want to run an {{smallcaps}}Sql{{/smallcaps}} script, press the button //Upload SQL file and execute//. This lets you upload a file with the extension //sql//. It will be run immediately against the database connection.
awa 1.1 32
fse 7.1 33 == Delete database connections ==
34
35 A database connection can only be deleted {{ficon name="trash-alt2"/}} when it is not referenced by an action or database query anymore.