Hi, I have a web application using hsqldb to maintain product license and session data, and it works well on a single app server. Now in a tomcat cluster(2tomcat + jk + Apache), when more than one user login, there will be a Database operation exception, which caused by:
java.sql.SQLException: The database is already in use by another process: org.hsqldb.NIOLockFile@6ab39164[file =C:\conf\license.lck, exist s=true, locked=false, valid=false, fl =null]: java.lang.Exception: The process cannot access the file because another process has locked a portion of the file : C:\conf\license.lck
Is there any good suggestion to let the whole thing work well?
HSQLDB supports several modes, some of which only support a single client. Could it be that you run it in one of those modes?
posted 12 years ago
Great reminder! I actually don't know HSQLDB well so if you don't tell me the mode thing I'll never work in the right direction. Now the problem is easily solved by runing HSQLDB in server mode. Thank you Ulf!