mysterious and unlucky debugging on h2 database
i faced some serious issues in h2 database, the h2 data saved in local file system are disapeared whenever tomcat is restarted only in window mode. i found easily that this problem is based on the db url parameter.
like this:
LOCK_MODE=0;LOG=0;MULTI_THREADED=1;DEFAULT_TABLE_TYPE=MEMORY;RECOVER=1;
ASSERT=0;CACHE_SIZE=200000;DEFAULT_LOCK_TIMEOUT=5000;TRACE_LEVEL_SYSTEM_OUT=0;
TRACE_LEVEL_FILE=0;LOCK_TIMEOUT=5000;
it’s tuned for fastest speed. and you know debugging is always a matter of choice. i choosed most suspicious options first. and test and test. but i can’t found till there left only one option, LOG=0, and finally i remove it, the program works so smoothly with no error..
i spend almost 2 hours for this simple test which would be ended in 10 mins. i know i’m an unlucky guy, i always have been. it will not be overcome soon..
