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
