We are trying to test the HSQL database for our application.We are creating an application which runs from the cd, and shows the details of information stored in the database and performs some query operations. Application uses java. Every thing is working fine on desktop, but when we created a autorun cd, it is giving the following error..
java.sql.SQLException: The database is already in use by another process
at org.hsqldb.Trace.getError(Unknown Source)
at org.hsqldb.Trace.error(Unknown Source)
at org.hsqldb.Log.open(Unknown Source)
at org.hsqldb.Database$Logger.openLog(Unknown Source)
at org.hsqldb.Database.open(Unknown Source)
at org.hsqldb.Database.<init>(Unknown Source)
at org.hsqldb.jdbcConnection.openStandalone(Unknown Source)
at org.hsqldb.jdbcConnection.<init>(Unknown Source)
at org.hsqldb.jdbcDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at test.TestHSQLDB.<init>(TestHSQLDB.java:24)
at test.TestHSQLDB.main(TestHSQLDB.java:267)
We copied the following files along with our application for HSQL (These files are freely placed in same folder, not in a jar or any package)
.data
.properties
.script
files
The problem we found is, these files are becoming readonly on copying to cd, we verified this by making readonly files on the harddrive, these files are changed from readonly.
Please see to the problem, and reply for the post about the possibility of the applcation.
Regards,
S.M.Rahman
Project Leader
acpl
Hyderabad, India.
email: rahman@accesscenter.net
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Anonymous
-
2013-01-30
I'm having a similar issues when running off a DVD, but the error is "java.io.IOException: Access is denied"
I've tried iterations of several of the db properties, including readonly and files_readonly, as well as several of the cached vs memory options. Any help would be MUCH appreciated. Queries run, but complex queries that are (presumably) trying to create a lot of temp data, throw this error.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi,
We are trying to test the HSQL database for our application.We are creating an application which runs from the cd, and shows the details of information stored in the database and performs some query operations. Application uses java. Every thing is working fine on desktop, but when we created a autorun cd, it is giving the following error..
java.sql.SQLException: The database is already in use by another process
at org.hsqldb.Trace.getError(Unknown Source)
at org.hsqldb.Trace.error(Unknown Source)
at org.hsqldb.Log.open(Unknown Source)
at org.hsqldb.Database$Logger.openLog(Unknown Source)
at org.hsqldb.Database.open(Unknown Source)
at org.hsqldb.Database.<init>(Unknown Source)
at org.hsqldb.jdbcConnection.openStandalone(Unknown Source)
at org.hsqldb.jdbcConnection.<init>(Unknown Source)
at org.hsqldb.jdbcDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at test.TestHSQLDB.<init>(TestHSQLDB.java:24)
at test.TestHSQLDB.main(TestHSQLDB.java:267)
We copied the following files along with our application for HSQL (These files are freely placed in same folder, not in a jar or any package)
.data
.properties
.script
files
The problem we found is, these files are becoming readonly on copying to cd, we verified this by making readonly files on the harddrive, these files are changed from readonly.
Please see to the problem, and reply for the post about the possibility of the applcation.
Regards,
S.M.Rahman
Project Leader
acpl
Hyderabad, India.
email: rahman@accesscenter.net
You should set the 'readonly=true' property in the .properties file for the database.
Thanks,
S.M.Rahman
I'm having a similar issues when running off a DVD, but the error is "java.io.IOException: Access is denied"
I've tried iterations of several of the db properties, including readonly and files_readonly, as well as several of the cached vs memory options. Any help would be MUCH appreciated. Queries run, but complex queries that are (presumably) trying to create a lot of temp data, throw this error.