You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ojb-user@db.apache.org by Stas Ostapenko <st...@gmail.com> on 2005/06/03 10:46:57 UTC
hsqldb setup problem
Hi !
I have problems with setting up hsqldb 1.8.0 RC10 to work with OJB 1.0.1.
Hypersonic SQL is supported platform, but how about hsqldb ?
When I do
> ant prepare-testdb
I get such exception :
-----
insert-sql:
[torque-sql-exec] Our new url ->
jdbc:hsqldb:/temp/SearchReporting/HSQL_OJB_Files
BUILD FAILED
C:\build\db-ojb-1.0.1\build.xml:390: The following error occurred while
executing this line:
C:\build\db-ojb-1.0.1\build-torque.xml:339: java.sql.SQLException: The
database is already in use by another process:
org.hsqldb.persist.NIOLockFile@9b698c74[file
=C:\temp\SearchReporting\HSQL_OJB_Files.lck, exists=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:\temp\SearchReporting\HSQL_OJB_Files.lck
------
The same situation when I using latest stable version hsqdb
1.7.3.3<http://1.7.3.3>.
How it can be resolved ?
<http://sourceforge.net/project/showfiles.php?group_id=23316&release_id=287789>
Re: hsqldb setup problem
Posted by Jakob Braeuchi <jb...@gmx.ch>.
hi stas,
why not ? afaik it's version 1.7.1 of hsqldb.
jakob
Stas Ostapenko schrieb:
> Hi !
>
> Ok, thanks. hsqldb.jar came from OJB distribution works fine. But can I use
> it in production ?
>
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org
Re: hsqldb setup problem
Posted by Martin Kalén <mk...@apache.org>.
Stas Ostapenko wrote:
> Ok, thanks. hsqldb.jar came from OJB distribution works fine. But can I use
> it in production ?
Yes, it's a (badly named) HSQLDB binary release JAR.
Unless you are dependent on a specific bugfix in later version of HSQLDB,
you will not have any problems with the JAR included in the OJB release.
Regards,
Martin
P.S. The reason for build properties platform naming
(ie "hypersonic" vs "hsqldb") is due to Torque SQL-generation.
The Torque HSQLDB platform is named "hypersonic" for
legacy reasons.)
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org
Re: hsqldb setup problem
Posted by Stas Ostapenko <st...@gmail.com>.
Hi !
Ok, thanks. hsqldb.jar came from OJB distribution works fine. But can I use
it in production ?
Re: hsqldb setup problem
Posted by Jakob Braeuchi <jb...@gmx.ch>.
hi stas,
you should use the hsqldb.jar that is delivered with ojb 1.0.1 to avoid
this problem. ojb 1.1 works with the current version (1.7.3) of hsqldb.
hth
jakob
Stas Ostapenko schrieb:
> Hi !
> I have problems with setting up hsqldb 1.8.0 RC10 to work with OJB 1.0.1.
> Hypersonic SQL is supported platform, but how about hsqldb ?
> When I do
>
>>ant prepare-testdb
>
> I get such exception :
> -----
> insert-sql:
> [torque-sql-exec] Our new url ->
> jdbc:hsqldb:/temp/SearchReporting/HSQL_OJB_Files
>
> BUILD FAILED
> C:\build\db-ojb-1.0.1\build.xml:390: The following error occurred while
> executing this line:
> C:\build\db-ojb-1.0.1\build-torque.xml:339: java.sql.SQLException: The
> database is already in use by another process:
> org.hsqldb.persist.NIOLockFile@9b698c74[file
> =C:\temp\SearchReporting\HSQL_OJB_Files.lck, exists=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:\temp\SearchReporting\HSQL_OJB_Files.lck
> ------
>
> The same situation when I using latest stable version hsqdb
> 1.7.3.3<http://1.7.3.3>.
>
> How it can be resolved ?
> <http://sourceforge.net/project/showfiles.php?group_id=23316&release_id=287789>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org