You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ojb-dev@db.apache.org by Armin Waibel <ar...@apache.org> on 2004/12/19 03:59:17 UTC

[OJB1.1] test suite and hsql

Hi all,

today I made a big check in of modified classes and test cases. When I
run test suite against maxDB I get 1/3 error/failures in PB-api and
2/2 in odmg and 1/3 in otm - seems ok some Spring specific tests fails 
and a QuotedTest (pass with hsql).

Only problem I have is running the test-suite against hsql since we
updated to version 1.7.2/3. Something changed in file handling by hsql 
between 1.7.1 and higher versions? Seems hsql DB-file was locked by the 
PB tests when odmg-tests start. Or dosen't OJB free all used resources 
when end PB tests?

<stack trace>
[org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl] ERROR: 
Error getting Connection from DriverManager with url 
(jdbc:hsqldb:../OJB) and driver (org.hsqldb.jdbcDriver)
The database is already in use by another process: 
org.hsqldb.NIOLockFile@f196e1b6[file 
=E:\dev\ojb-work\db-ojb\target\test\OJB.lck.lck, exists=true, 
locked=false, valid=false, fl =null]: java.lang.Exception: 
checkHeartbeat(): lock file 
[E:\dev\ojb-work\db-ojb\target\test\OJB.lck.lck] is presumably locked by 
another process.


regards,
Armin


---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-dev-help@db.apache.org


Re: [OJB1.1] test suite and hsql

Posted by Armin Waibel <ar...@apache.org>.
Hi Jakob,

Jakob Braeuchi wrote:
> hi armin,
> 
> splitting up the junit-target did not help, but i could solve the 
> problem by adding a small testcase performing a shutdown as last 
> testcase in AllTests.

+1, I don't have a better idea ;-)

regards,
Armin


> there may eventually be a more elegant solution ;)
> 
> jakob
> 
> Jakob Braeuchi schrieb:
> 
>> hi armin,
>>
>> afaik the older versions of hsqldb did a 'shutdown' when the last 
>> connection was closed. the new version 1.7.2/3 requires a manual 
>> shutdown. i do not know whether it helps to split up the unit test in 
>> several junit-targets.
>>
>> jakob
>>
>> Armin Waibel schrieb:
>>
>>> Hi all,
>>>
>>> today I made a big check in of modified classes and test cases. When I
>>> run test suite against maxDB I get 1/3 error/failures in PB-api and
>>> 2/2 in odmg and 1/3 in otm - seems ok some Spring specific tests 
>>> fails and a QuotedTest (pass with hsql).
>>>
>>> Only problem I have is running the test-suite against hsql since we
>>> updated to version 1.7.2/3. Something changed in file handling by 
>>> hsql between 1.7.1 and higher versions? Seems hsql DB-file was locked 
>>> by the PB tests when odmg-tests start. Or dosen't OJB free all used 
>>> resources when end PB tests?
>>>
>>> <stack trace>
>>> [org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl] 
>>> ERROR: Error getting Connection from DriverManager with url 
>>> (jdbc:hsqldb:../OJB) and driver (org.hsqldb.jdbcDriver)
>>> The database is already in use by another process: 
>>> org.hsqldb.NIOLockFile@f196e1b6[file 
>>> =E:\dev\ojb-work\db-ojb\target\test\OJB.lck.lck, exists=true, 
>>> locked=false, valid=false, fl =null]: java.lang.Exception: 
>>> checkHeartbeat(): lock file 
>>> [E:\dev\ojb-work\db-ojb\target\test\OJB.lck.lck] is presumably locked 
>>> by another process.
>>>
>>>
>>> regards,
>>> Armin
>>>
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
>>> For additional commands, e-mail: ojb-dev-help@db.apache.org
>>>
>>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
>> For additional commands, e-mail: ojb-dev-help@db.apache.org
>>
>>
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-dev-help@db.apache.org
> 
> 
> 

---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-dev-help@db.apache.org


Re: [OJB1.1] test suite and hsql

Posted by Jakob Braeuchi <jb...@gmx.ch>.
hi armin,

splitting up the junit-target did not help, but i could solve the 
problem by adding a small testcase performing a shutdown as last 
testcase in AllTests.
there may eventually be a more elegant solution ;)

jakob

Jakob Braeuchi schrieb:
> hi armin,
> 
> afaik the older versions of hsqldb did a 'shutdown' when the last 
> connection was closed. the new version 1.7.2/3 requires a manual 
> shutdown. i do not know whether it helps to split up the unit test in 
> several junit-targets.
> 
> jakob
> 
> Armin Waibel schrieb:
> 
>> Hi all,
>>
>> today I made a big check in of modified classes and test cases. When I
>> run test suite against maxDB I get 1/3 error/failures in PB-api and
>> 2/2 in odmg and 1/3 in otm - seems ok some Spring specific tests fails 
>> and a QuotedTest (pass with hsql).
>>
>> Only problem I have is running the test-suite against hsql since we
>> updated to version 1.7.2/3. Something changed in file handling by hsql 
>> between 1.7.1 and higher versions? Seems hsql DB-file was locked by 
>> the PB tests when odmg-tests start. Or dosen't OJB free all used 
>> resources when end PB tests?
>>
>> <stack trace>
>> [org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl] 
>> ERROR: Error getting Connection from DriverManager with url 
>> (jdbc:hsqldb:../OJB) and driver (org.hsqldb.jdbcDriver)
>> The database is already in use by another process: 
>> org.hsqldb.NIOLockFile@f196e1b6[file 
>> =E:\dev\ojb-work\db-ojb\target\test\OJB.lck.lck, exists=true, 
>> locked=false, valid=false, fl =null]: java.lang.Exception: 
>> checkHeartbeat(): lock file 
>> [E:\dev\ojb-work\db-ojb\target\test\OJB.lck.lck] is presumably locked 
>> by another process.
>>
>>
>> regards,
>> Armin
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
>> For additional commands, e-mail: ojb-dev-help@db.apache.org
>>
>>
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-dev-help@db.apache.org
> 
> 

---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-dev-help@db.apache.org


Re: [OJB1.1] test suite and hsql

Posted by Jakob Braeuchi <jb...@gmx.ch>.
hi armin,

afaik the older versions of hsqldb did a 'shutdown' when the last 
connection was closed. the new version 1.7.2/3 requires a manual 
shutdown. i do not know whether it helps to split up the unit test in 
several junit-targets.

jakob

Armin Waibel schrieb:
> Hi all,
> 
> today I made a big check in of modified classes and test cases. When I
> run test suite against maxDB I get 1/3 error/failures in PB-api and
> 2/2 in odmg and 1/3 in otm - seems ok some Spring specific tests fails 
> and a QuotedTest (pass with hsql).
> 
> Only problem I have is running the test-suite against hsql since we
> updated to version 1.7.2/3. Something changed in file handling by hsql 
> between 1.7.1 and higher versions? Seems hsql DB-file was locked by the 
> PB tests when odmg-tests start. Or dosen't OJB free all used resources 
> when end PB tests?
> 
> <stack trace>
> [org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl] ERROR: 
> Error getting Connection from DriverManager with url 
> (jdbc:hsqldb:../OJB) and driver (org.hsqldb.jdbcDriver)
> The database is already in use by another process: 
> org.hsqldb.NIOLockFile@f196e1b6[file 
> =E:\dev\ojb-work\db-ojb\target\test\OJB.lck.lck, exists=true, 
> locked=false, valid=false, fl =null]: java.lang.Exception: 
> checkHeartbeat(): lock file 
> [E:\dev\ojb-work\db-ojb\target\test\OJB.lck.lck] is presumably locked by 
> another process.
> 
> 
> regards,
> Armin
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-dev-help@db.apache.org
> 
> 

---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-dev-help@db.apache.org