#13 Problem with reloading Layouts from DB

[Kelly Carter]

Hi Bruce,
I'm getting this error when I click the "Roload from DB" button to reload layouts:

DataBase Connection error: The database is already in use by another process: lockFile: org.hsqldb.persist.LockFile@df16567e[file =C:\Program Files (x86)\RecordEditor\Database\recordedit.lck, exists=false, locked=false, valid=false, ] method: openRAF reason: java.io.FileNotFoundException: C:\Program Files (x86)\RecordEditor\Database\recordedit.lck (Access is denied)

Can you help?

Thanks

[Kelly Carter]

I'm running Java SE Runtime Environment 8 Update 281

[Bruce Martin]

I will have a look in to it. But
Assuming you are using the hsql version, I would suggest trying

• Backup your database
• Get out of the record editor.
• Shut the db server down, there is an option for this
• look for a file recordedit.lck and try and delete it. It should be in C:\Users\username\RecordEditor_HSQL\Database

[Kelly Carter]

I was able to get past the first problem. Now I'm getting this message when I open the application:

********************   Warning ***************************

Tried to Connect to the HSQL Data Base Server and failed. Will run in Database embedded mode.
This package works best in Data Base Server Mode (option on menu, exit this program before you start the Server).

If you wish to use the package in imbeded Mode, You may wish to reveiw the Database
Options (Menu option Edit >>> Edit Startup options)
1) Properties >>>> Defaults then click on the Default DB tab. You can now select the Normal DB Connection
2) JDBC Parameters >>> JDBC Properties ~ Auto Close Connection. Setting it to Y will alow
multiple versions of the RecordEditor to be run at once, but you may have update problems

I was not able to find an option on the menu or how to switch to "Normal DB Connection."

I have also not been able to find the "Improving the running of RecordEditor HSQL" section in the documentation to better understand the information above.

Bruce, any help you can provide would be appreciated.

[Bruce Martin]

Can you send me zip up and send me the Database directory

It should be
c:\Users\????\RecordEditor_HSQL\Database

[Kelly Carter]

Here it is.

[Anonymous]

Any progress on this?