The HSQLDB tab enables you to modify configuration settings specific to HSQLDB databases.
The HSQLDB tab
HSQLDB is a Java based database server. You need to install our Java preconfigured package to make it working with DWebPro.
You can download a preconfigured package for HSQLDB support in the Add-On Packages topic.
The fields in http.ini specific to
the HSQLDB section are shown below:
[HSQLDB] ; HSQLDB Engine settings Start=1 BaseDir=##DWEBPRO_PATH##\engine\hsqldb DataDir=##DWEBPRO_PATH##\engine\hsqldb\data StartupCustomParams=-database.0 "##DWEBPRO_HSQLDB_DATADIR##\testdb" -dbname.0 test ShutDownCustomParams=-url jdbc:hsqldb:hsql://localhost/test JavaOpts=-Xms64M -Xmx64M ; Network settings Port=9001 FindFreePort=1 ; Startup / Shutdown settings RunLocally=0 ShowShutDownTimeOutMessage=1 ShutDownTimeout=5000 ShutDownOnExit=1 ; File Copy settings DestinationDir=##TEMP##\dwebpro\hsqldb\data DatabaseVersion=1 DeleteOldDatabases=0 ShowCopyProgressWindow=1 Overwrite=0 AskUserForOverwrite=0 AskUserForOverwriteDefaultButton=Yes ClearOnShutDown=0 AskUserForClearOnShutDown=0 AskUserForClearOnShutDownDefaultButton=Yes ; Interactive Install settings UseInteractiveInstall=0 SpaceNeeded=1
HSQLDB Engine settings
Start HSQLDB
Start
Start
HSQLDB specifies whether HSQLDB is started upon start up of
DWebPro
Accepted values: 0, 1
Base Directory
BaseDir
Base
Directory specifies the base path to the directory where the
HSQLDB engine resides. Refer to the DWebPro Internal Constants topic
for additional information on paths.
Accepted values: string
Data Directory
DataDir
Data
Directory specifies the path to the directory where the
HSQLDB database files reside. Refer to the DWebPro Internal Constants topic
for additional information on paths.
Accepted values: string
Startup Params
StartupCustomParams
Startup
Params specifies additional parameters to be passed to
org.hsqldb.Server for starting the database server.
Accepted values: string
Shutdown Params
ShutDownCustomParams
Shutdown
Params specifies additional parameters passed to
org.hsqldb.util.ShutdownServer for stopping the database
server.
Accepted values: string
Java Options
JavaOpts
Java
Options specifies the values used in the JAVA_OPTS
environment variable.
Accepted values: string
Network settings
Port
Port
Port
specifies the port on which HSQLDB listens.
Accepted values: integer
Find Free Port
FindFreePort
Find Free
Port specifies whether DWebPro should search for free ports
on which to start HSQLDB. Refer to the DWebPro Internal Constants topic
for additional information.
Accepted values: 0, 1
Startup / Shutdown settings
Run Locally
RunLocally
When you use HSQLDB from CD/DVD,
DWebPro automatically copies some files to the user's file system
to enable HSQLDB to work correctly. Select the Run Locally option to avoid this copy process.
Note that you may safely select the Run
Locally option only when you run DWebPro from a hard drive
or other writable media. It can be useful to select the
Run Locally option during the
development phase.
Accepted values: 0, 1
Show Shutdown Timeout Message
ShowShutDownTimeOutMessage
Show Shutdown
Timeout Message specifies whether DWebPro prompts the user
prior to closing MySQL.
Accepted values: 0, 1
Shutdown Timeout
ShutDownTimeout
Shutdown
Timeout specifies the timeout, in milliseconds, before
HSQLDB is forced to close.
Accepted values: integer
Shutdown on Exit
ShutDownOnExit
Shutdown on
Exit specifies whether HSQLDB is closed on DWebPro
shutdown.
Accepted values: 0, 1
File Copy settings
Destination Directory
DestinationDir
Destination
Directory specifies the path of the directory to which the
HSQLDB files will be copied. Refer to the DWebPro Internal Constants topic
for additional information on paths.
Accepted values: string
Database Version
DatabaseVersion
Database
Version specifies the version of the HSQLDB database. If you
want to distribute your application with different versions of the
database or distribute an updated version of the database within
the same application, you can use this field to specify which
version of the database you are distributing and let DWebPro
automatically start the database server with the correct
database.
Accepted values: integer
Delete Old Databases
DeleteOldDatabases
Delete Old
Databases specifies whether DWebPro has to delete an
existing HSQLDB database before copying a new one.
Accepted values: 0, 1
Show Copy Progress Window
ShowCopyProgressWindow
Show Copy
Progress Window specifies whether the progress window
displays during file copy routines.
Accepted values: 0, 1
Overwrite Data
Overwrite
Overwrite
Data specifies whether the databases copied to the user's
hard drive are overwritten.
Accepted values: 0, 1
Ask User for Overwrite
AskUserForOverwrite
Ask User for
Overwrite specifies whether DWebPro prompts the user to
confirm the copy of the files if the destination directory already
exists.
Accepted values: 0, 1
Default Button
AskUserForOverwriteDefaultButton
Default
Button specifies the default button on the confirmation form
for files copy.
Accepted values: Yes, No
Clear on Shutdown
ClearOnShutdown
Clear on
Shutdown specifies whether DWebPro deletes the files copied
to the user's file system prior to closing.
Accepted values: 0, 1
Ask User for Clear on Shutdown
AskUserForClearOnShutDown
Ask User
Clear on Shutdown specifies whether DWebPro prompts the user
to confirm the deletions of the files in the destination directory
prior to closing.
Accepted values: 0, 1
Default Button
AskUserForOverwriteDefaultButton
Default
Button specifies the default button on the confirmation form
for files deletion.
Accepted values: Yes, No
Interactive Install settings
Use Interactive Install
UseInteractiveInstall
Use
Interactive Install specifies whether DWebPro uses the
Interactive Installation procedure. Refer to the Interactive Install Workflow
topic for more information.
Accepted values: 0, 1
Space Needed
SpaceNeeded
Space
Needed specifies the needed space for the copy. Use the
drop-down box to the right of this field to specify the units of
space desired. This option is relevant only when using the
Use Interactive Install option.
Refer to the Interactive Install Workflow
topic for more information.
Accepted values: integer
