It is possible to have a completely empty properties file. In this
case properties file must be in the
current directory. InstantDB will then use defaults for all of the properties.
Property | Default | Usage |
altStringHashing | 0 | If set to 1 then String hashes use the JDK Object.hashCode()
function. By default, uses InstantDB's String hashing. |
cacheAmount | 256 or 10 | The amount of each column to cache, expressed either
as an absolute number of rows or as a percentage figure. |
cacheCondition | CACHE_ROWS | Must be one of CACHE_ROWS or CACHE_PERCENT. Determines
whether to cache columns in tables based on an absolute number of rows, or the
percentage number of rows in the table. |
currencyDecimal | 2 | Number of digits after decimal point in currency outputs. |
currencySymbol | $ | Currency symbol used in currency outputs. |
cacheResetPercent | 10 | The percentage cache hit improvement required in
order to move the cache to a new location in a column. |
dateFormat | "yyyy-mm-dd" | Default format for date columns. |
exportSQL | 0 | Non-zero means include SQL statements in the export file. |
fastUpdate | 0 | Non-zero means that database changes do not get
written to the database immediately. See tuning.htm. |
ignoreKeywords | | Allows selected InstantDB keywords to be un-reserved.
e.g. ignoreKeywords=url,quote would allow the keywords url and quote to be used as table
or column names. |
indexLoad | 5 | Percentage of free space in an index that must be present
before the index reorganises itself. |
indexPath | tablePath | Path where index tables are held. Can be absolute
or relative to the properties file. |
likeIgnoreCase | 0 | Set to 1 to cause LIKE clauses
to always perform case insensitive comparisons. |
milleniumBoundary | 0 | If set, then all two digit dates less than its
value are interpreted as 21st century dates. |
missesInCacheStats | 100 | The number of cache misses to include in calculations
of the next base for the cache. |
noBanner | 0 | Non-zero means suppress the opening copyright message.
Note - this is set on the java command line not in the database properties file.
e.g. java -DnoBanner=1 ... |
readOnly | 0 | Non-zero means database is opened in read only mode. |
recoveryPolicy | 0 |
0 (default) means do not perform recovery
1 means perform automatic recovery
2 means prompt the user using standard in |
relativeToProperties | 0 | Non-zero means paths are relative to the properties file. |
resultsOnDisk | 0 | Non-zero means that results sets get instantiated on disk. |
resultsSetCache | CACHE_ROWS | cacheCondition setting to use for results sets. |
resultsSetCacheAmount | 100 | cacheAmount setting to use in results sets. |
rowCacheSize | 20 | Number of rows to read into the disk look ahead buffer.
Recommended to be set somewhere around 128 to 256. |
strictLiterals | 0 | Same as SET LITERAL STRICT_ON. Prevents string
literals being interpreted as column names or numbers. |
systemPath | tablePath | Path where system tables are held.
Can be absolute or relative to the properties file. |
tablePath | . | Path where database tables are held. Can be absolute
or relative to the properties file. |
tmpPath | tablePath | Path where results set tables are held. Can be absolute
or relative to the properties file. |
traceConsole | 0 | Non-zero means trace output also directed to console. |
traceFile | | Relative or absolute path where exporting and tracing goes |
traceLevel | 0 | Bitmap of various items that can be traced.
See import.htm. |
transLevel | 1 | Sets the level of transaction journalling.
See trans.htm. |
transImports | 100 | When doing an import, defines the number of rows imported
before the transaction is committed. Recommended value 8192. |
| | |