https://bugs.documentfoundation.org/show_bug.cgi?id=94341
--- Comment #9 from David <[email protected]> --- (Please view this text with any monospaced font to preserve formatting). ////////////////////////////////////////////////////////// /// HOW TO ACCESS THE EXTERNAL DATABASE WITH L.O. BASE /// ////////////////////////////////////////////////////////// Here are the instructions again to run the test database as a server and then access it with the ODB file. The error saying that the driver was not found was because L.O. was not set up correctly. Please follow these instructions to set up L.O. and run the database. START HERE: ----------- 1. Unzip the testDB to drive C on your PC. RUN THE DATABASE IN SERVER MODE: -------------------------------- 2. Adjust the java path in the batch file "runServer-TestDB.bat". (See foot note 2). 3. Then using the batch file, run the HSQLDB database. It will run in server mode. CONFIGURE L.O. TO ACCESS THE EXTERNAL DATABASE ---------------------------------------------- 4. Open LibreOffice, and click on TOOLS > OPTIONS > LIBREOFFICE (tab) > ADVANCED (tab) 5. Select a 32-bit java installation. (See foot note 5). 6. Add the HSQLDB.jar to the classpath. Click the button CLASSPATH, then ADD ARCHIVE. Navigate to the HSQLDB.jar provided. Click OPEN, then OK. (See foot note 6). OPEN THE TESTDB.ODB FILE ------------------------ 7. Open the ODB file. 8. Open the CADASTRO form. CHECK FOR THE BUG ----------------- 9. Click to go ahead one record (from 1 to 2). 10. Click to go to the last record. It may take several seconds to come up. 11. The total record number in the toolbar should be garbled. If it's not, then reduce the size of the form until the record fields are cut off by the form's edge. i.e. the fields will be PARTIALLY outside the scroll area of the form. 12. Go to first record, 13. Go to last record. The problem should show up. For me, no resizing is necessary. The problem seems to faithfully reproduce itself. However, I did manage to get it to come up without being garbled by creating a NEW form from the Table Data. But that only happened once. The second time, it came up garbled as expected. PLEASE READ THESE FINAL COMMENTS: --------------------------------- It is of great value to run BASE against an external database since that is where BASE really shows it's power. Since the reporting in Base is a little limited, it has been better for me to run an external database as a SERVER so that reporting tools like iReport and JasperStudio can produce reports that can incorporate subreports, and all kinds of formatting, easily. Another idea would be to incorporate Jasper reporting and iReport Report editing into BASE ... since they are open source. This would allow the use of sub reports, which I believe, the current reporting tool does not allow. I trust these few instructions and comments have been useful. Don't hesitate to contact me should you encounter any further problems. Yours sincerely, David. Foot note for Number 2: ----------------------- Use any pure text editor to edit the batch file. You can use Notepad or something similar. I prefer Notepad++. Change the line that says: path = "C:\Program Files\Java\jdk1.8.0_60\bin" Change the path to the one of your own java installation. The one mentioned here is a 64-bit installation. For more info on 32-bit or 64-bit installations, see foot note 5. Please note that LibreOffice requires a 32-bit java installation for step five. If you don't have a 32-bit java installation on your system, you will need to download one and install it to be able to complete step five. Foot note for Number 5: ----------------------- You will know that the Java installation selected is 32-bit because it will be installed in a program directory with (x86) somewhere in the middle of the directory name like this ... "C:\Program Files (x86)\Java\jre1.8.0_60". A directory like this ... "C:\Program Files\Java\jre1.8.0_60" will be a 64-bit installation ... so don't use that one. It also works well with Java 7 32-bit. Foot note for Number 6: ----------------------- It is the same jar that ran the server. Do not use the (HSQLDB.jar)s with numbers in the jar names. This is only for me to swap into a more recent version of HSQLDB for testing ... which hasn't been successful ... so I've stayed with 1.8 which works great. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
