[Springframework-developer] HSQL DB locking problem using part4 tutorial of SPRING FRAMEWORK

[V. A. <vk...@ya...>]

Tutorial:
http://www.springframework.org/docs/MVC-step-by-step/Spring-MVC-step-by-step-Part-4.html

================
ant junit  (complains of locking !! - Any clues).
================

C:\springapp>ant junit
Buildfile: build.xml

build:

clearData:
     [echo] CLEAR DATA USING: org.hsqldb.jdbcDriver
jdbc:hsqldb:db/test
      [sql] Executing commands
      [sql] 1 of 1 SQL statements executed
successfully

loadData:
     [echo] LOAD DATA USING: org.hsqldb.jdbcDriver
jdbc:hsqldb:db/test
      [sql] Executing commands
      [sql] 3 of 3 SQL statements executed
successfully

    [junit] Testcase:
testIncreasePrice(tests.TestProductManagerDaoJdbc):
Caused an ERROR
    [junit] Could not get JDBC connection; nested
exception is java.sql.SQLExcep
tion: The database is already in use by another
process: org.hsqldb.NIOLockFile@
e7d0d2d8[file =C:\springapp\db\test.lck, exists=true,
locked=false, valid=false,
 fl =null]: java.lang.Exception: The process cannot
access the file because anot
her process has locked a portion of the file :
C:\springapp\db\test.lck
    [junit]
org.springframework.jdbc.CannotGetJdbcConnectionException:
Could not
 get JDBC connection; nested exception is
java.sql.SQLException: The database is
 already in use by another process:
org.hsqldb.NIOLockFile@e7d0d2d8[file =C:\spr
ingapp\db\test.lck, exists=true, locked=false,
valid=false, fl =null]: java.lang
.Exception: The process cannot access the file because
another process has locke
d a portion of the file : C:\springapp\db\test.lck
    [junit] java.sql.SQLException: The database is
already in use by another pro
cess: org.hsqldb.NIOLockFile@e7d0d2d8[file
=C:\springapp\db\test.lck, exists=tru
e, 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:\s
pringapp\db\test.lck
    
    [junit] Testcase:
testGetProductList(tests.TestProductManagerDaoJdbc):
Caused an ERROR
    [junit] Could not get JDBC connection; nested
exception is java.sql.SQLExcep
tion: The database is already in use by another
process: org.hsqldb.NIOLockFile@
e7d0d2d8[file =C:\springapp\db\test.lck, exists=true,
locked=false, valid=false,
 fl =null]: java.lang.Exception: The process cannot
access the file because anot
her process has locked a portion of the file :
C:\springapp\db\test.lck
    [junit]
org.springframework.jdbc.CannotGetJdbcConnectionException:
Could not
 get JDBC connection; nested exception is
java.sql.SQLException: The database is
 already in use by another process:
org.hsqldb.NIOLockFile@e7d0d2d8[file =C:\spr
ingapp\db\test.lck, exists=true, locked=false,
valid=false, fl =null]: java.lang
.Exception: The process cannot access the file because
another process has locke
d a portion of the file : C:\springapp\db\test.lck
    [junit] java.sql.SQLException: The database is
already in use by another pro
cess: org.hsqldb.NIOLockFile@e7d0d2d8[file
=C:\springapp\db\test.lck, exists=tru
e, 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:\s
pringapp\db\test.lck
   
BUILD FAILED
===============
I seems to lock itself. Spring Framework supposed to
connect and disconnect to Database automatically.
It uses all the stuff in the tutorial.
==============
Thanks.


		
__________________________________ 
Do you Yahoo!? 
Yahoo! Small Business - Try our new resources site!
http://smallbusiness.yahoo.com/resources/