I am unable to see Maria Database tables created outside of LibreOffice Base

[vreid47362]

I have a maria db that I connect to from LibreOffice base. I appear to be unable to see tables I create in Maria’s db manager, Heidi SQL. I also appear to be unable to see tables created from inside of base using Tools → SQL. If, however, I create a table using Create Table in Design view, the table shows up in base.

I have confirmed that I am actually creating the tables in Maria when I use the Heidi SQL tool and when I use Base → Tools → SQL, but they just won’t show up in base.

Maybe this is related, but it also appears that I’m unable to get numeric and integer tables to accept the auto increment/auto number option when I create the maria tables using Base’s Creat Table in Design view gui.

I’m connecting to Maria using JDBC and the JDBC .jar file I downloaded from Maria’s web site.

[JAM1]

I have a similar problem but using Direct Connect. I cannot create Auto-Increment field with Base’s Create Table in Design View. More specifically, it looks like I’ve set the Integer field for auto-incrementing until I save the table and reopen it for data entry or design editing. Also, after I have created a Table using Base’s Design View I cannot edit the table design even if there is no data in the table. Note:I do not get a ‘Connection Test’ window (because I’m using Direct Connect?). I’m using Ubuntu Saucy Salamander (13.10) and MariaDB NOT Firebird. The database is on the same hard drive (in /var/lib/mysql); this is a single-user system.

[JAM1]

I fixed the above by switching to the JDBC connect instead of direct connect.

[mariosv]

Hi vreid47362,

do you get the connection test Ok, while you set it up?

[vreid47362]

Yes, I tested both the connection and the class and both connected successfully.

I think, I may have found the problem. I only had java 7 installed on the PC I was working with. I found the latest java 6 installers and installed them on the system and restarted LibreOffice. Then, for good measure, I went to the mysql site and grabbed their jdbc driver and added it to the class path (I had previously added maria’s jdbc driver).

Then after re-starting LibreOffice again, I was able to connect via both generic jdbc and MySQL JDBC with both the maria jdbc and mysql jdbc .jar files.

So, I think the problem I was having was Java 7.

Now, that brings up an entirely new set of questions and observations: 1. The java web site states that Java 6 will only be available for a limited additional time and makes it hard to find the Java 6 downloads. So what happens when Java 6 goes away? 2. Since LibreOffice is still somewhat dependent on Java, I’d like to see the appropriate jre bundled into the LibreOffice installer and embedded/installed into the actual libreOffice install files path and not registered system-wide. My experience with troubleshooting java based applications in “the real world” of small business IT has shown that applications that bundle their own embedded java jre into the program files and that don’t rely on a system installed java jre seem to be more stable and seem to not break when java starts nagging users to update, etc.

[mariosv]

Only a 32 bits Java 1.7 or 1.6 works with LibreOffice, and also verify is select the Java to use in Menu/Tools/Options/LibreOffice/Java.