hsqldb properties -


i using hsqldb having following settings in properties file (not set me)

hsqldb.cache_size_scale=8 readonly=false hsqldb.nio_data_file=true hsqldb.cache_scale=14 version=1.8.0 hsqldb.default_table_type=memory hsqldb.cache_file_scale=1 modified=yes hsqldb.cache_version=1.7.0 hsqldb.original_version=1.8.0 hsqldb.compatible_version=1.8.0 

the db started giving errors in logs java.sql.sqlexception: s1000 general error java.util. nosuchelementexception

some searching on google pointed me because limit of .data file has been reached. size of .data file around 0.7gb. if increase cache_file_size , above error disappear

hsqldb.default_table_type=memory hsqldb.cache_file_scale=1 

if hsqldb.cache_file_scale=3. mean database in memory , require 3gb. if memory issue how can reduced ?

the current setting allows 2gb in data file.

i suggest perform shutdown script clear problems. if have further problems, contact hsqldb project.


Comments

Popular posts from this blog

asp.net - repeatedly call AddImageUrl(url) to assemble pdf document -

java - Android recognize cell phone with keyboard or not? -

iphone - How would you achieve a LED Scrolling effect? -