oooBase Multi User Base Reports not Locking / Staying with user "ThisDatabaseDocument"
I have upgraded an OpenOffice Base to serve to Multi Users from MYSQL on my Local but Remote Server to a number of terminals set up to connect a Open Office 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 OpenOffice Base Database to serve the ooo Base mysql which it does using the java JDBC
The server has MySQL version 14.14 distribution 5.6.19
On the Client side (Ubuntu)I have installed the lastest Oracle 1.8.0_60 java and I have pointed the class path to :/usr/share/java/mysql-connector-java-5.1.32.jar
Each client user can build their form document without any issues.
The MySQL is a standard installation in that I have NOT installed any Locks
However,
It seems as if all sessions are merged when delivering reports, as in whoever has latest Current-User / 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 .odb on their terminal with their own user name. it is Not a Share Base .odb installed on the server
I have tried on a number of Macro's with the same results
I created another test server, with the same results
here are the macro 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