simple singularities

mysterious and unlucky debugging on h2 database

Filed under: java, programming — fri13th September 4, 2007 @ 2:11 pm

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..

No Comments »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a comment