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