Changes for page DB-Verbindungen


From version 1.1
edited by awa
on 20.01.2021, 16:22
Change comment: Imported from XAR
To version 1.4
edited by jdr
on 10.02.2022, 15:02
Change comment: There is no comment for this version

Summary

Details

Page properties
Author
... ... @@ -1,1 +1,1 @@
1 -XWiki.awa
1 +XWiki.jdr
Content
... ... @@ -1,22 +1,11 @@
1 1  {{content/}}
2 2  
3 -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.
4 -
5 5  {{id name="fig_data_db_con"/}}
6 -{{figure image="data_db_con_en.png"}}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}}
7 7  
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}}
8 8  
9 -{{html wiki="true"}}
10 -<div class='xm-figure xm-float-right xm-clear-global' data-alt='Creating a DB connection in . (1) To the left is a list of existing database connections. (2) On the right users can configure the selected database connection.'><div class='xm-figure-inner' style='width:310px'>{{lightbox image='data_db_con_en.png' width='300' group='$height' group='$group' title='Creating a DB connection in . (1) To the left is a list of existing database connections. (2) On the right users can configure the selected database connection.'/}}<div class='xm-figure-caption'>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.</div></div></div>
11 -{{/html}}
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.
12 12  
13 -
14 -
15 -{{html wiki="true"}}
16 -<div class='xm-figure xm-float-right xm-clear-global' data-alt='Creating a DB connection in . (1) To the left is a list of existing database connections. (2) On the right users can configure the selected database connection.'><div class='xm-figure-inner' style='width:310px'>{{lightbox image='data_db_con_en.png' width='300' group='$height' group='$group' title='Creating a DB connection in . (1) To the left is a list of existing database connections. (2) On the right users can configure the selected database connection.'/}}<div class='xm-figure-caption'>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.</div></div></div>
17 -{{/html}}
18 -
19 -
20 20  == Create database connection ==
21 21  
22 22  * 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"]]).
... ... @@ -25,6 +25,7 @@
25 25  ** **Name**: Name for this database connection.
26 26  ** **Description**: Description of the database connection
27 27  ** **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.
28 28  ** **JDBC URL**: The JDBC URL of the database server
29 29  ** **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"]]
30 30  ** **Username**: Username of the database user.