Hello,
I want to have database environment with several users using base front-end which I developed. I want to use HSQLDB 2.3.4 database on my computer running in server mode, to which users connect.
For the sake of simplicity, I developed base document so far as embedded solution and now I want to split it into front-end and back-end parts.
After reading about splitting database not so thoroughly due to size and complexity of the text, I decided to take simpler approach (e.g. I did it my way :)) :
Since there is no way to connect to a different database from base UI, nor possibility to import forms and reports from another base file, I did it with a “hack”.
- I took odb file A (embedded HSQLDB solution with forms, reports and views), opened it with a zip utility and extracted database files (according to the HSQLDB manual) into separate folder. I started HSQLDB server, which I downloaded from official page with my database.
- I prepared odb file B as an empty Base document, but I prepared connection to my HSQLDB server
- I opened odb file B .odb file with zip utility and extracted content.xml. I copied everything between db:data-source opening and closing XML tag. I closed database B
- I opened odb fileA .odb file and replaced everything between db:data-source opening and closing XML tags with copied text
- For the sake of neatness, I deleted database folder in odb file A
I found that this “hack” solution at my surprise works! I tested it and everything seems fine.
Now, the question: can I expect data corruption/odd behaviour/other problems with this solution?
Everything seems fine so far.
Thanks!