https://bugs.documentfoundation.org/show_bug.cgi?id=94777
Bug ID: 94777 Summary: Base Reports to Multi-User (MariaDB) not locking to user Product: LibreOffice Version: 4.2 all versions Hardware: Other OS: All Status: UNCONFIRMED Severity: normal Priority: medium Component: Base Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: an...@macspares.co.za I am serving MYSQL on my Local but Remote Server to a number of terminals set up to connect a Libre Base front-end via JDBC The server is a Ubuntu 14.04 asterisk box serving serving MYSQL to the asterisk that works well and I have only recently added the Database to serve the Libre Base. mysql which it does using the java JDBC Each user can build their form document without any issues, however, It seems as if all sessions are merged when delivering reports, as in whoever has the lock , that's the report MYSQL serves, in other words user "A" gets user "B" reports if user "B" was the last to do something. "SHOW PROCESSLIST;" indicates different thread-Id's for each user The MYSQL started off as MyISAM then I converted to InnoDB All users have their own copy of the Base on their terminal with their own user name I have tried on a number of Macro's with the same results I created another test server,serving MariaDB with the same results here are the macros I have used : First Macro Sub EVA_Report(event) oButton = event.source.Model sReportname = oButton.tag oReport = ThisDatabaseDocument.ReportDocuments.GetByName(sReportName) oReport.Open end sub Second Macro Sub CreateReportCalledfromButton(oEvent as object) dim oCreateButton,oForm dim oConnection,oReportsDocuments oCreateButton=oEvent.source.model oForm=oCreateButton.parent oConnection=oForm.Activeconnection oReportsDocuments=oConnection.parent.DatabaseDocument.ReportDocuments openReport(oConnection, oReportsDocuments, oCreateButton.tag , oForm.Filter) End Sub Function openReport(oConnection, oReportsDocuments,aReportName,sFilter) as object Dim mPrintopts1() dim aProp(3) as new com.sun.star.beans.PropertyValue dim aProp2 dim oReportDesign aProp(1).Name = "ActiveConnection" aProp(1).Value = oConnection aProp(0).Name = "Hidden" aProp(0).Value = true aProp(2).Name = "OpenMode" aProp(2).Value = "openDesign" let aProp2=aProp oReportDesign=oReportsDocuments.loadComponentFromURL(aReportName ,"",0,aProp()) aProp2(0).Value = TRUE aProp2(2).Value = "open" oReportsDocuments.loadComponentFromURL(aReportName ,_blank,0,aProp2()).Print(mPrintopts1()) End Function -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs