[Solved] MySQL BLOBs and Base don't seem to work

Help with installation and general system troubleshooting questions concerning the office suite LibreOffice.
Post Reply
j4nd3r53n
Posts: 14
Joined: Mon Nov 25, 2013 10:50 pm

[Solved] MySQL BLOBs and Base don't seem to work

Post by j4nd3r53n »

I'm on Debian 10, using LO 7.1 and MariaDB 10.5.8-MariaDB-1:10.5.8+maria~buster. I connect Base directly via a socket.

I have created a table and a form based on the table:

Code: Select all

MariaDB [greenhouse]> desc plant;
+---------+--------------+------+-----+---------+-------+
| Field   | Type         | Null | Key | Default | Extra |
+---------+--------------+------+-----+---------+-------+
| id      | int(11)      | NO   | PRI | NULL    |       |
| genus   | varchar(128) | YES  | MUL | NULL    |       |
| species | varchar(128) | YES  |     | NULL    |       |
| picture | blob         | YES  |     | NULL    |       |
+---------+--------------+------+-----+---------+-------+
4 rows in set (0.210 sec)
When I upload an image, it disappears as soon as I save it. I have found several questions about this, but the answers never seem to address the problem or suggest ways to troubleshoot it.

I know from working with Java EE, that it is perfectly possible to store and retrieve images in MySQL/MariaDB, so the problem isn't the database. Is there anything one needs to do, other than naively following the wizard?

Edit:

This works perfectly when I use JDBC, but not with ODBC or connecting through a socket.
Last edited by j4nd3r53n on Fri Feb 26, 2021 3:13 pm, edited 1 time in total.
OpenOffice 3.1.0 on Debian 7
User avatar
robleyd
Moderator
Posts: 5056
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: MySQL BLOBs and Base don't seem to work

Post by robleyd »

Cross posted to AskLibreOffice

If you cross post, please let us know that you have done so, otherwise it leads to several discussions and a waste of time because several identical answers may be posted by different users.
Cheers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.1.2; SlackBuild for 24.2.1 by Eric Hameleers
j4nd3r53n
Posts: 14
Joined: Mon Nov 25, 2013 10:50 pm

Re: MySQL BLOBs and Base don't seem to work

Post by j4nd3r53n »

I apologise. I seem to remember, some years ago, one of these fora tended to be rather sluggish, and I thought I had posted in the wrong place. I'm glad to see Libreoffice and OpenOffice now get much more of the attention they deserve.
OpenOffice 3.1.0 on Debian 7
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: MySQL BLOBs and Base don't seem to work

Post by Villeroy »

Create a most simple test form from that table and add a picture control linked to the blob.
From toolbar "Form Controls" --> button "More Controls" --> "Picture Control".
Using LibreOffice, create a report with a picture control.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
j4nd3r53n
Posts: 14
Joined: Mon Nov 25, 2013 10:50 pm

Re: MySQL BLOBs and Base don't seem to work

Post by j4nd3r53n »

It turned out that this only works, if you connect with JDBC, for some reason.
OpenOffice 3.1.0 on Debian 7
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: MySQL BLOBs and Base don't seem to work

Post by Villeroy »

j4nd3r53n wrote:It turned out that this only works, if you connect with JDBC, for some reason.
Ooops.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Post Reply