Description: After migrating the LO base database connection type from sdbc to jdbc (jaybird6) for accessing an external firebird v3 database, base does not show the content of the database tables. I am able to connect to the database and performing the login. if I open a table in base (by 2-clicking on the table), the windows open and it is blank except where I click with the mouse where data beneath is revealed. Executing a query in SQL design mode works and results are properly returned. This issue is not present via an sdbc connection. Steps to Reproduce: 1.Establish a connection to a remote firebird database through JDBC (jaybird) 2.Perform login to database for establishing connection 3.Double click on a table Actual Results: The table opens and the window is blank except where you click. Expected Results: Table content shall be displayed Reproducible: Always User Profile Reset: Yes Additional Info: I had the same issue with LO 25 and decided to downgrade. Issue did not disappear however.
Created attachment 199858 [details] Screenshot of table view Trying to resize the window leads to an LO crash
I was informed that the JDBC / Firebird connection with Libreoffice is not supported. This bug can therefore be discarded and closed.
Following comment 2 I will close this one as NOTOURBUG.
No problem connecting with Jaybird 6 in windows. See next attachment Version: 25.2.1.2 (X86_64) / LibreOffice Community Build ID: d3abf4aee5fd705e4a92bba33a32f40bc4e56f49 CPU threads: 16; OS: Windows 11 X86_64 (10.0 build 22631); UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: es-ES Calc: CL threaded
Created attachment 199928 [details] No problems with Jaybird 6
(In reply to jcsanz from comment #5) > Created attachment 199928 [details] > No problems with Jaybird 6 Please have a look here: https://www.firebirdsql.org/docs/drivers/java/faq.html#connecting-to-firebird As I understand it could connect, but Database Meta Data weren't exported well: https://github.com/FirebirdSQL/jaybird/blob/master/devdoc/jdp/jdp-2022-04-deprecate-ooremote.md There will be other problems for the bug submitter with Firebird on his system that it doesn't show content of the table. But this is what I could read in Frequently asked Questions of Firebird with Jaybird: "This URL format is deprecated with jaybird 5 and was removed in Jaybird 6. As a replacement, use the “Firebird External” option in LibreOffice Base." → and this format is unusable for server because you couldn't connect to the same table with two different systems at the same time.