The connection to the data source "MyDB" could not be established

English
#1

LO Base crashed while I was trying to work with SQL statements in a List Box. Trying to re-open the file starts me off in Forms (where the crash happened), but there is nothing there. Clicking on Tables gives me the 3 errors. Clicking More shows the errors as The connection to the data source "MyDB" could not be established. Error code: 1000 The driver class '' could not be loaded. /build/libreoffice-fresh/src/libreoffice-7.3.1.3/connectivity/source/drivers/jdbc/JConnection.cxx:685 and SQL Status: HY000 The driver class '' could not be loaded. /build/libreoffice-fresh/src/libreoffice-7.3.1.3/connectivity/source/commontools/dbexception.cxx:413

I’ve read over other posts, googled, etc. Nothing anyone else posted describes my situation or how to really fix it. I haven’t upgraded anything. The Java Runtime is there. I rebooted my system (Arch Linux) in case some process was hung, but that changed nothing.

Working with Base over the last few days has been one of the most frustrating experiences of my entire life. How can I get this DB file to work again?

#2

Hello,
It appears you were using a connection to the DB via JDBC. Looks like the Class Path is missing or bad. Need to set or re-set path.
.
From menu Tools.Options. Then under LibreOffice>Advanced select Class Path button and insure path to MySQL JDBC .jar file is present or delete & add back in.

#3

I don’t have a clue what you’re talking about. I’ve been using HSQLDB Embedded for this project. Looking at the issue now, I can see that it does say “JDBC” at the bottom. Not sure how that got changed. Maybe that is what I need to fix? Can I change it back to HSQLDB Embedded?

#4

I am terribly sorry but saw the error for JDBC and mistakenly saw MyDB as MySQL.
Can you post a copy of the Base file if there is no personal or confidential info in it? Seems it has been corrupted.

#5

Trying to upload it now, but uploading the ODB file gives me an error (from this forum site): “Sorry, but the file you provided is empty.”…uh…what now?

#6

Are you certain this is an embedded HSQLDB file? Some thought leads me to believe this is a split HSQLDB file.

#7

HSQL Embedded is the only option I have when creating a new database. That is what I used to create the db having the error. I’m not sure what a split HSQLDB file is?

#8

Just created a new HSQL embedded File and am posting to test. It is totally empty but reported in my file manager as 2.4kb:

New Database.odb (2.4 KB)
Posted fine. Do not understand what you have. What size does your File manager report?

#9

Your test ODB works fine. FWIW, I did a similar test myself and got the same result. My problematic database.odb file is showing 0 bytes. Welp, that can’t be good.

I’m starting to think that Base just wrecked my database beyond recovery. I made sure I had “Always create backup copy” checked before I started the work. (I thought I learned my lesson a few days ago when I started this on a different computer, didn’t have that checked and lost everything after a crash) BUT now I’m looking in the designated backup directory and…surprise, nothing is there.

I’m assuming that everything I need should be in that ODB file and if nothing is there it’s “too little, too late.”

#10

Unfortunately if it is 0 bytes, then can’t see any hope. It is confusing since in the question you stated opening it after the crash & it displayed the Main Base screen. Do not understand how this is as the file is 0 bytes. Could you post a screen shot of that Base opening screen noted in the question?
.
FYI, I do not rely on the LO Base backup process. I, when needed, simply make a copy.

#11

Sorry if my description was confusing. What I meant is, after the crash nothing shows up anywhere (no tables, no forms, nada) and clicking around gives me the errors stated above. After the initial load (i.e. the LibreOffice loading bar) It starts off in Forms, where the crash originally occurred, which is strange because normally opening up Base starts me off under the Tables menu. But there is still nothing there.

I’m not sure I understand why the application’s backup function would not work for this situation. Sure, I could understand if the DB was remote, can’t expect LO to back THAT up. But a database embedded in a single file should be easy to backup. Sounds like this function is just plain broken. Along with all the other issues, like crashes that mysteriously wipe a db. :confounded:

#12

No I understood. What I was hoping to see was the status bar information along the bottom.

#13

Oh I see what you mean. Yeah, that now says “JDBC” when I try to open the problem file. It was definitely set to HSQLDB Embedded before. So something about the crash altered that. Maybe JDBC is the default that Base assumes when opening a database file with no information (since mine is now 0 bytes)? Whatever the case, it seems like the chance to recover is 0% at this point. Is there any kind of log I can pull for Base to see what error might have caused this is the first place?

#14

Not to my knowledge.
Have been working with Base for 5+ years and had not seen this issue before. Crashes & damaged files but not emptied. Did a quick test and created an empty file and opened with Base. You are correct that it defaults to JDBC:

Screenshot at 2022-03-13 18-36-10
Screenshot at 2022-03-13 18-36-10583×504 48.8 KB

Notice the top line - stated as plain text document. On a valid file this is ODB database.
.
Sorry I could not be of help. Also please excuse me for confusing the issue.

#15

That is really strange. Opening my problem DB didn’t show plain text, but the usual ODB heading.

#16

Not so strange. Yours was actually created by LO and mine artificially. What is strange to me is how you ended up with a 0 byte file!
.
Another thought, where did you get your LO from? Distro?

#17

Sorry for the late reply. I’m on Garuda Linux (an Arch derivative). The LO package is libreoffice-fresh version 7.3.1-1.

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.