> 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.

> H O M E