Wiki source code of Datenbank


Show last authors
1 {{content/}}
2
3 {{formcycle/}} requires a pre-existing database for storing system related data. When installing {{formcycle/}}, the database structure is initialized automatically by the system. You only need to provide a connection to working database.
4
5 {{warning}}
6 {{formcycle case="dat"/}}no longer supplies database drivers. It is necessary to install the appropriate database driver for the database management system you are using.
7
8 {{version major="7" minor="0" patch="10"}}{{/version}} Starting with {{formcycle/}} version 7.0.10, this also applies to the H2 database driver that was still included in earlier releases.
9
10 Further information can be found [[here>>doc:Formcycle.SystemSettings.DatabaseDrivers]].
11 {{/warning}}
12
13 == Database connection ==
14
15 {{figure image="database_settings_en.png" width="600"}}
16 The settings for the database connection. After you change these settings, the database and the system gets updated automatically.
17 {{/figure}}
18
19 ; Database type
20 : Select the database type of the database you would like to use.
21 ; JDBC connection URL
22 : Every database has got slightly different URL for establishing a connection. Click on the //example// button to the right to see a list of common URLs.
23 ; Database user
24 : User name for the database login.
25 ; DB password
26 : Password for the database login.
27
28 == Advanced settings ==
29
30 {{info}}
31 {{version major="7" minor="1"/}} You can also use the JVM parameters //xfcAutoUpdate// and //xfcUpdateCallbackEmails// to override the settings for the auto update.
32 {{/info}}
33
34
35 ; {{version major="7" minor="1"/}} Apply pending updates automatically on system start
36 : When enabled, all pending database and system updates are run automatically when the {{formcycle/}} application is started. This avoids having to run the updates manually and helps to reduces down times during updates.
37 ; {{version major="7" minor="1"/}} Send notification about update results to the following email addresses
38 : A list of email addresses. When the automatic update finishes, a status report is sent to these email addresses (requires a valid mail server configuration). The report contains information about the update status (success or error) and any error messages in case of an error.
39 ; Connections
40 : The maximum number of connections between {{formcycle/}} and the database at any given time.
41 ; Timeout
42 : The time an open connection between must remain idle for the connection between {{formcycle/}} and the database to be closed. When set to 0, no timeout is applied.
43
44 == Database encryption ==
45
46 {{formcycle/}} provides the option to enable encryption for the database to prevent against unauthorized access. Meta data is always encrypted and form data may be encrypted optionally.
47
48 To activate encryption, you must set the following options:
49
50 ; Algorithm
51 : The encryption alogrithm to be used. The default is //PBE with SHA and Twofish-CBC (recommended)//.
52 ; Encrypt form data
53 : Enable this option to encrypt data of submitted forms including all attachments. When you use a mySQL database, [[form specific data tables>>Formcycle.UserInterface.MyForms.Inbox]] are encrypted as well.
54 ; Update encryption of data sets
55 : When thic option is checked, the data gets encrypted with the entered password.
56 ; Password confirmation
57 : The password used to encrypt the data with the selected algorithm.
58
59 {{warning}}
60 Depening on the chosen encryption algorithm, the password and the Java version you are using it may become necessary to install the //Java Cryptography Extension (JCE) Unlimited Strength Jurisdiction Policy Files//. If these files are missing, an appropriate error message will be displayed.
61 {{/warning}}
62
63 == Migrating data sets ==
64
65 Enable the option //Update encryption of data sets// to migrate existing, encrypted data. The encrypted data is decrypted with the password entered in //Password confirmation// and encrypted again with the new password.
66
67 == Create or update the database ==
68
69 Click on //Save and update// to continue to update the database and system. If the database is empty, new tables will be created. Otherwise, the database is updated. Once the database is up-to-date, all necessary system updates are run automatically.