confirm and LO should ask for restart… **!!! IMPORTANT !!!** open LO > options > advanced > class path > add archive > … go to the JayBird folder, and add both the xxxx.jar and the xxxx_FULL.jar
unzip Jaybird and place somewhere useful download the Firebird JDBC connector (JayBird) – make sure the version matches both the FB version and your Java version. check your own OS Java version (suggest use/install Java8, not later, as FB/JayBird seems to plan variable support only for later versions) Finally, close isql.exe but leave FB running …
Also useful to CREATE USER at this stage … … … (note the as confirmation at CON> - this is automatically logging in as default user=SYSDBA password=masterkey at this stage) *create database ‘q:\Libre_ArcBASE\SMB20\ARCBASE\SMB20_arcfire.fdb’ page_size 8192 default character set ISO8859_1 * start FB and use isql.exe to CREATE a blank database … download and install Firebird4 > follow install options (superclassic mode seems a good choice for me – also to use thrid party tools enable “copy to directory service” option).currently I find issues with LO7.2 and my existing projects…so suggest use LO7.0 or LO7.1 (or earlier) INSTALLATION NOTES: (mainly with reference to win7) …Finally the project aims to create a ‘template’ which can be easily modified or harvested for parts in future (and many examples of my amateurish SQL ) …Final products of the project include full text publishable reports, scientific and museum data, archive formats, GIS, photogrammetry data, ect ect – so integration with other LO software and the wider open-source community is very useful! …Also, the project requires ‘seamless’ integration with portable PCs/tablets used in variable fieldwork conditions. ….Additionally, the hardware used includes some very low spec devices using Linux, Win7 and Win10 – FB(c++) is highly functional in this environment. … Firebird is suitable for me because (amongst other things) the deployment is for single/few users, using local WLAN/LAN connections, with no actual need for high concurrence with connections or data-syncing between users in this use case (‘daily’ sync of DB ‘shards’ to a master DB is enough).However there are numerous admin/dev functions that are possible/much easier with (any) external DB ….NB: not at all necessary, even for complex projects used by a small team or individual – I fact I did most development (ie learning :o) using LO6 with embedded FB only….Since I found various useful info in different places I thought I would put some notes here for others to use (draft1):įirst, Why Use Firebird as EXTERNAL database anyway?
I have recently/currently ‘migrated’ a complex project from LO+FB(embedded) to LO+sdbc+FB4(external) …
0 kommentar(er)
