Node of System
The node to edit basic attributes of the system including database configurations.
<System Name, Version, Launch Button>
Values are shown as the title of login dialog and menu when X-TEA Driver
is launched. You can launch the system by pushing the button or pressing
F5. This is not the only way to launch system; you can do so using a short
cut icon on the desktop. Refer to README of install folder for details.
< Tab of Descriptions>
Write remarks and descriptions of the system as needed.
< Tab of Database Config>
Main DB, User, Password
Specify the definition of the database connection. If you change their
values, restart Editor to re-connect to the database. Available types of
JDBC and definition formats are as follow:
JavaDB(Apache Derby)
jdbc:derby://[host IP]/[folder name(*1)]
H2
jdbc:h2:tcp://[host IP]/[folder name(*1)]
MySQL(MariaDB)
jdbc:mysql://[host IP]/[database name]?zeroDateTimeBehavior=convertToNull
PostgreSQL
jdbc:postgresql://[host IP]/[database name]
Oracle
jdbc:oracle:thin:@[host IP]:
SQLServer
jdbc:sqlserver://[host IP][\instance name];[databaseName=database name];
MS Access
jdbc:ucanaccess://[path of .mdb/.accdb file];memory=false(*2)
(*1)You can express the name of content file folder by the string "<CURRENT>" in folder name.
(*2)Set New database sort order of Access Option as "General" if you need to add tables. Note
that although you can create/ delete Access tables, you can not use ALTER
TABLE operations(ie. to add/drop columns) in X-TEA Editor.
Changing DBMS
Default value of database connection is for Apache Derby(JavaDB) for
its portability. You have to be aware of differences between types of DBMS
when you change them. For example if you change into MySQL, you should
use DATETIME in stead of TIMESTAMP for the date-time field. And if you
change into PostgreSQL, names of table and field must be in lower-case
letters (XEAD Editor shows them in upper-case letters).
JavaDB for Client-Server environment
If you use JavaDB in server mode, you need to edit 2 rows if the bat file
...\bin\startNetworkServer.bat as follows:
Before change
... org.apache.derby.drda.NetworkServerControl start %DERBY_CMD_LINE_ARGS%
After change
... org.apache.derby.drda.NetworkServerControl -h 0.0.0.0 start %DERBY_CMD_LINE_ARGS%
You do not need to "Start Database" on clients. JavaDB is not required on clients in the first place.
DBCP Oprions
Oprions for database connection pooling. Default is "MaxActive=10,
MaxIdle=10, MaxWait=5000". It is required for 2Tiered System.
DB-Method URL
URL of servelet for db operations. It is required for 2Tiered System.
System Control Tables
Specify table IDs to 10 types of system control. Each table has to got prescribed table format. Refer to Skeleton system for those formats.
Sub DB
You can integrate other databases as Sub DB with Main DB. Difference of
Sub DB is that it is the read-only database; this is because of difficulty
of cross-network committing.
< Login Script>
Login Scripta are executed when starting sessions. They are usually used
to setup "session attributes". Use setUserAttribute(String id,
String value) of session-object to operate them in scripts. You can also use them to close sessions. Here
is example:
// Steps executed in starting sessions
if (session.getStatus() == 'ACT') {
...
}
// Steps executed in closing sessions
if (session.getStatus() == 'END' || session.getStatus() == 'ERR') {
...
}
You can use short-cut-keys to edit them like Ctrl+I(Indent), Ctrl+/(Comment),
Ctrl+Z/Y(Undo/Redo), F3(Scan String), F7(Syntacs Error Check). Note that
you can not use instance-object in those scripts as it is a pointer to
the related function which is executing script, and no function is launched
when you start/finish the session.
< Script Functions>
Common-used subroutine functions for scripts. These are copied and placed
after each script code before being executed.
< Other>
Image Folder
Image Folder is where image files are stored for this system. Specify the
name of folder without "\" at the end. You can use keyword of
<CURRENT> to express the folder where system definition file(*.xeaf)
stored. You can also use expression like http://123.123.123.123/images.
Welcome Page
Welcome Page is shown above the menu when users login to the system. Specify
URL for the page. If not specified, it will show the image file named as
"WelcomePageDefaultImage.jpg" on the content file folder.
Output Folder
The folder where this system output files(.xls, .pdf) into. Specify the name of folder without "\" at the end. You can use keyword of <CURRENT> to express the folder where system definition file(*.xeaf) stored. If not specified, files will be deleted after browsed.
Log File Folder/ Logging Size
The folder where table operation log files will be placed. they will be
created in case that log size is longer than logging size specified. Default
folder is "log" under the folder where content file placed. And
default logging size is 3000(letters).
Get DB-Connection to edit
By checking this, Editor will connet to DB when launched. Even if it failed
to connect you can use Editor with limited feachers.
Date Format
Date format for Driver. Select one of listed.
Font
The font for Driver. Specify the font name which is installed in your client.
Hash Format
User's login password is stored as a hashed value according to Hash Format. Default value is "MD5;1;false" which means that hash algorithm
is MD5 and expanding once and hashing without salted value. Available algorithms
are MD2,MD5,SHA-1(SHA,SHA1),SHA-256,SHA-384,SHA-512. Note that some of
those demand longer password field.
Skip Module-checking to start Editor
It will take while to finish module-chicking when you start Editor for system with numerous tables. You check this box to omit the process for quick testing.
Editor User/ Password/ VM Options/ Skip Preloading
Configurations to launch Driver from Editor. You can skip login dialog
by specifying User and Password. VM Option is for Java VM. You can skip
preloading application drivers by checking Skip Preloading.
SMTP Host/ Port/ User ID/ Password
SMTP configurations for the function of session#sendmail in script.
Print Font
Font for PDF. Select the row to edit and list print functions that is using
the font.
< Maintenance Log>
Log records of how sytem definitions are changed.
|