|

»

file lock on hsqldb 1.9

View: New views

3 Messages — Rating Filter: Alert me

	file lock on hsqldb 1.9 by Mathieu B :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message Hi all, We are trying to migrate an HsqlDB 1.8 to 1.9 but we met some troubles with file lock. We tried to add in the property file the following parameter : hsqldb.lock_file=false This works at first launch but the property file is erase at next start. The new property file looks like this : #HSQL Database Engine 1.9.0.0 #Fri Nov 06 13:05:15 CET 2009 version=1.9.0 modified=yes The only way to keep the parameter is to add the following line (files_readonly=true) : #HSQL Database Engine 1.9.0.0 #Fri Nov 06 13:05:15 CET 2009 version=1.9.0 modified=yes hsqldb.lock_file=false files_readonly=true but in that case, files is readonly ... So, is there a way to disable the locks on file definitively ? Is there a parameter to avoid the files ".properties" to be reset at each start ? Thanks ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Hsqldb-user mailing list Hsqldb-user@... https://lists.sourceforge.net/lists/listinfo/hsqldb-user
	Re: file lock on hsqldb 1.9 by Fred Toussi-2 :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message Some parts of this message have been removed. Learn more about Nabble's security policy. You should be able to specify the property on the connection URL. If you disable the lock file, you must be sure that database is never accessed by a second process. Fred On Fri, 06 Nov 2009 14:24 +0100, "Mathieu B" <mathieu.b.pro@...> wrote: Hi all, We are trying to migrate an HsqlDB 1.8 to 1.9 but we met some troubles with file lock. We tried to add in the property file the following parameter : hsqldb.lock_file=false This works at first launch but the property file is erase at next start. The new property file looks like this : #HSQL Database Engine 1.9.0.0 #Fri Nov 06 13:05:15 CET 2009 version=1.9.0 modified=yes The only way to keep the parameter is to add the following line (files_readonly=true) : #HSQL Database Engine 1.9.0.0 #Fri Nov 06 13:05:15 CET 2009 version=1.9.0 modified=yes hsqldb.lock_file=false files_readonly=true but in that case, files is readonly ... So, is there a way to disable the locks on file definitively ? Is there a parameter to avoid the files ".properties" to be reset at each start ? Thanks ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Hsqldb-user mailing list Hsqldb-user@... https://lists.sourceforge.net/lists/listinfo/hsqldb-user
	Re: file lock on hsqldb 1.9 by Mathieu B :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message Ok, thanks Fred. We will try with a property on the connection URL. 2009/11/6 Fred Toussi <fredt@...> You should be able to specify the property on the connection URL. If you disable the lock file, you must be sure that database is never accessed by a second process. Fred On Fri, 06 Nov 2009 14:24 +0100, "Mathieu B" <mathieu.b.pro@gmail.com> wrote: Hi all, We are trying to migrate an HsqlDB 1.8 to 1.9 but we met some troubles with file lock. We tried to add in the property file the following parameter : hsqldb.lock_file=false This works at first launch but the property file is erase at next start. The new property file looks like this : #HSQL Database Engine 1.9.0.0 #Fri Nov 06 13:05:15 CET 2009 version=1.9.0 modified=yes The only way to keep the parameter is to add the following line (files_readonly=true) : #HSQL Database Engine 1.9.0.0 #Fri Nov 06 13:05:15 CET 2009 version=1.9.0 modified=yes hsqldb.lock_file=false files_readonly=true but in that case, files is readonly ... So, is there a way to disable the locks on file definitively ? Is there a parameter to avoid the files ".properties" to be reset at each start ? Thanks ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Hsqldb-user mailing list Hsqldb-user@... https://lists.sourceforge.net/lists/listinfo/hsqldb-user ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Hsqldb-user mailing list Hsqldb-user@... https://lists.sourceforge.net/lists/listinfo/hsqldb-user