https://bugs.freedesktop.org/show_bug.cgi?id=50747

             Bug #: 50747
           Summary: When using MySQL JDBC connector with a URL subforms do
                    not work
    Classification: Unclassified
           Product: LibreOffice
           Version: LibO 3.5.3 release
          Platform: x86-64 (AMD64)
        OS/Version: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Database
        AssignedTo: [email protected]
        ReportedBy: [email protected]


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:


Error:
The data content could not be loaded.


Error:
SQL Status: S1009

Parameter index out of range (1 > number of parameters, which is 0).


Information:
The SQL command leading to this error is:

SELECT * FROM `prm_test`.`addresses` WHERE ( `personID` = :link_from_ID )

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to