Verwaltung - PT.Main.DatenbankMenue 

Page / - last modified by gru on 15.03.2019, 16:31 

PT.Main.DatenbankMenue 
last modified by gru
on 15.03.2019, 16:31

Table of Contents
Database connection
Advanced settings
Database encryption
Migrating data sets
Create or update the database

Content [ Hide ] 
•	Database connection
•	Advanced settings
•	Database encryption
•	Migrating data sets
•	Create or update the database
Xima® Formcycle requires a pre-existing database for storing system related data. When installing Xima® Formcycle, the database structure is initialized automatically by the system. You only need to provide a connection to working database.
Xima® Formcycleno longer supplies database drivers. It is necessary to install the appropriate database driver for the database management system you are using.
Further information can be found here.
Database connection
 
The settings for the database connection. After you change these settings, the database and the system gets updated automatically.
Database type
Select the database type of the database you would like to use.
JDBC connection URL
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.
Database user
User name for the database login.
DB password
Password for the database login.
Advanced settings
Connections
The maximum number of connections between Xima® Formcycle and the database at any given time.
Timeout
The time an open connection between must remain idle for the connection between Xima® Formcycle and the database to be closed. When set to 0, no timeout is applied.
Database encryption
Xima® 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.
To activate encryption, you must set the following options:
Algorithm ===
The encryption alogrithm to be used. The default is PBE with SHA and Twofish-CBC (recommended).
Encrypt form data
Enable this option to encrypt data of submitted forms including all attachments. When you use a mySQL database, form specific data tables are encrypted as well.
Update encryption of data sets
When thic option is checked, the data gets encrypted with the entered password.
Password confirmation
The password used to encrypt the data with the selected algorithm.
When you enter a passwort, the system checks whether that password is valid. This prevents data loss and data from being encrypted twice. Please note that this feature is available only since version 6. When you update from version 5 to version 6, the password cannot be checked.
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.
Migrating data sets
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.
Create or update the database
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.