If I select the "JDBC" type of connection and enter a URL for my MySQL database, subforms stop working. This happens both for forms generated with the wizard and forms built from scratch in design view.
If the "MySQL (JDBC)" connection type is used instead, the same form with subforms works perfectly (however, this connection type does not support storing a password for the database, so it is unsuitable for my use case).
The error messages displayed when clicking on "More detail" are:
The data content could not be loaded.
SQL Status: S1009
Parameter index out of range (1 > number of parameters, which is 0).
The SQL command leading to this error is:
SELECT * FROM `prm_test`.`addresses` WHERE ( `personID` = :link_from_ID )
please: have a look at this bugreport. Can you confirm the behavior?
Have tested it with MySQL and JDBC (not the JDBC integrated, as described) Seems to be the same problem as reported with PostgreSQL and JDBC. Must be the JDBC-driver of LO.
I will mark
as a duplicate of this bug and change the titel to all connections of databases with JDBC.
*** Bug 56358 has been marked as a duplicate of this bug. ***
Changed the version to LO 3.3.4. It the same behavior in all LO-versions I have tested - the eldest version is LO 3.3.4.
In menu Edit / Database / Advanced Settings, tab "Special Settings", check the box next to "Replace named parameters with '?'"
I am running LO 188.8.131.52.
In menu Edit / Database / Advanced Settings, tab "Special Settings",
I don't have a box "Replace named parameters with '?'"
What can I do?
(In reply to jnplg from comment #6)
> I am running LO 184.108.40.206.
> In menu Edit / Database / Advanced Settings, tab "Special Settings",
> I don't have a box "Replace named parameters with '?'"
> What can I do?
Open the *.odb-file with a packing-program. Edit the file content.xml.
db: parameter-name-substitution = "false"
must be set to "true" or could completely been removed.
Is there any reason why there isn't set
parameter-name-substitution = "true"
as default in
Edit → Database → Advanced Settings → Special Setting → Replace named parameters with '?'
… or should I close this bug as WORKSFORME and set up a new description with a feature request?