Ask Your Question
0

I am unable to see Maria Database tables created outside of LibreOffice Base. [closed]

asked 2013-05-01 13:08:59 +0200

vreid47362 gravatar image

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.

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-10-31 02:05:48.383950

Comments

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.

JAM gravatar imageJAM ( 2013-11-05 22:26:12 +0200 )edit

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

JAM gravatar imageJAM ( 2013-11-06 21:13:55 +0200 )edit

2 Answers

Sort by » oldest newest most voted
0

answered 2013-05-01 14:10:33 +0200

vreid47362 gravatar image

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.

edit flag offensive delete link more

Comments

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.

m.a.riosv gravatar imagem.a.riosv ( 2013-05-01 20:18:03 +0200 )edit
0

answered 2013-05-01 13:28:28 +0200

m.a.riosv gravatar image

Hi vreid47362,

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

image description

edit flag offensive delete link more

Question Tools

Stats

Asked: 2013-05-01 13:08:59 +0200

Seen: 1,476 times

Last updated: May 01 '13