Base - No SDBC driver found!!

Ian_Whitfield · January 26, 2012, 11:20am

Hi All

As always I seem to be battling again with my Database!!

I've just updated to Linux Mint 12 KDE which includes LO. BUT it would not even run on my new set-up. So I removed it and installed OO in it's place. The new OO did not seem to like my 'Input Form' so I re-created it. BUT - it takes for ever to "save" and most of the time DOES NOT save the information!! (This is a problem I've had with both OO and LO)

So I removed OO and re-installed LO 3.4.3 and jdk 1.6.0_21. Now when I try to Open my DB I get the error "No SDBC driver found"!! I've Googled about this and it looks as if this is a known current "Bug" that has not been fixed.

I even tried to create a new Database (which it did OK) and then renaming my old file to this name but I still get the same error!!

Is there an answer to this - I HAVE to get my DB up again URGENTLY!!!!

Thanks a lot
/
Ian Whitfield
Pretoria
///

Fernand_Vanrie · January 26, 2012, 11:31am

Ian,

no panic, what is the external database you are connected to ? or are you using the embeded database
the error "No SDBC driver found" looks like you odb document lost the connection with a external database

Greetz

Fernand

Ian_Whitfield · January 26, 2012, 11:49am

/
/Thanks Fernand

I'm using the embeded database - HSQL.

I would LIKE to get away from this but the couple of times I tried in the past were a complete failure!!

Greetings back to you

Ian Whitfield
Pretoria./
/

Fernand_Vanrie · January 26, 2012, 12:00pm

Ian,

in these case you can panic

can you still open your odb doc and check your tables ?

if not open the doc with tool to unzip the content and check if the "data" file is still present

drew · January 26, 2012, 12:06pm

Hello Ian,

Well, it sounds as if somewhere along the line you started picking up
the HSQLdb jar distributed by the upstream project, rather then the jar
file distributed with the application.

This has been a recurring problem, fixed and then un-fixed a couple of
times.

Not to worry though, no real harm done.

So - did you by any chance update the java settings in LibO to include
the HSQLdb distributed jar so that you could connect to an external
HSQLdb server? If so, simply back that out and the problem will correct
itself.

//drew

Villeroy · January 26, 2012, 12:26pm

Am 26.01.2012 12:49, Ian Whitfield wrote:

I'm using the embeded database - HSQL.

I would LIKE to get away from this but the couple of times I tried in
the past were a complete failure!!

http://user.services.openoffice.org/en/forum/viewtopic.php?f=61&t=46324&p=214069&hilit=hsqldb#p214049

Ian_Whitfield · January 26, 2012, 1:38pm

I'm using the embeded database - HSQL.

I would LIKE to get away from this but the couple of times I tried in the past were a complete failure!!

Greetings back to you

Thanks All!!

*To Fernand* - Both copies of my .odb file are the same size (640Mb) and if I move a copy to the Windows machine I can 'see' all my tables, DB, forms etc. (not sure how to do this in Mint)

One thing that is funny though is that if I check the permissions on the file it is owned by me and my group but all the permissions are greyed out and I can not seem to change this!!??

*To Drew* - I got the java file from the Java site and I have "activated" it under Tools>Options>Java. But again whenever I go back to look at it - its not there. Base seems NOT to be keeping this setting!!

*To Andreas* - The link you sent me seems to cover how to instal HSQL - but isn't this the embeded DB?? Its there by default. Sorry don't follow this.

Thanks again

Ian Whitfield
Pretoria

Fernand_Vanrie · January 26, 2012, 2:17pm

I'm using the embeded database - HSQL.

I would LIKE to get away from this but the couple of times I tried in the past were a complete failure!!

Greetings back to you

Thanks All!!

*To Fernand* - Both copies of my .odb file are the same size (640Mb) and if I move a copy to the Windows machine I can 'see' all my tables, DB, forms etc. (not sure how to do this in Mint)

One thing that is funny though is that if I check the permissions on the file it is owned by me and my group but all the permissions are greyed out and I can not seem to change this!!??

odb. is *not* multi user, when the document is open on a other machine of by a other user everyting is "grayed out"

Ian_Whitfield · January 26, 2012, 3:33pm

OK - fine. But how do I reset/reverse this??

Fernand_Vanrie · January 26, 2012, 4:17pm

odb. is *not* multi user, when the document is open on a other machine of by a other user everyting is "grayed out"

OK - fine. But how do I reset/reverse this??

make sure nobody is connected or has opened the odb

or make a copy with a new name and open this copy then everiting must been editable

Villeroy · January 26, 2012, 4:19pm

Am 26.01.2012 15:15, Fernand Vanrie wrote:

*To Andreas* - The link you sent me seems to cover how to instal HSQL
- but isn't this the embeded DB?? Its there by default. Sorry don't
follow this.

http://hsqldb.org is a database engine in Java. My receipt is about moving an embedded HSQLDB v1.8 out of the Base jail so it can be used as a fully functional multi-user db in server mode or in cached mode (single user on local machine but fully functional and independent of the frontend). Current HSQLDB version is 2.5.

Tom_Davies · January 26, 2012, 4:47pm

Hi
The HSqlDb version that is embedded in Base is a bit poor compared to using the proper version of HSqlDb and then use that as a back end with Base as the front-end. I think the result is that it looks like 2 files but works a LOT better. It's just the implementation inside Base is less than great.

There are other back-ends that might be better if you are going for a larger database but HSqlDb is quite good and very fast if the database is going to be fairly small. For example Postgresql or MariaDb/MySql might be great for a large database but not so great for a simple address book or something.

Regards from
Tom

Don_C_Myers · January 26, 2012, 5:10pm

Hi,

I have several .odb files. I have one computer where I do all of the updating to the databases generally. I copy the odb file to three other computers which are not networked so I have the databases current on those machines. However, I can edit the databases on any machine without any issues. I'm running Ubuntu 11.10 and currently LibreOffice 3.4.5.

Don

Ian_Whitfield · January 27, 2012, 11:50am

Not working Fernand!!!!

I've made a new copy of the file but permissions are still grayed out!! I tried changing them with Dolphin, Dolphin as root and using chmod but they still remain greyed out.

Any other ideas??

Tom_Davies · January 27, 2012, 12:01pm

Hi
Would something like

ps aux | grep name-of-backend

show if somehow the database thinks it is doing a process? Is it possible to see what the permissions of a file are set as? I assume the back-end is created by the user that is using the back-end rather than created by RootUser/SuperUser/Admin? If so can other users access and update the database or how are the permissions set to allow that?

Sorry i'm just throwing in some stupid thoughts as i really don't know how all that is supposed to work. I guess the Base guide's first couple of chapters have not been able to help?
http://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Base_Guide

Regards from
Tom

Ian_Whitfield · January 27, 2012, 12:16pm

OK!!! I've cracked the permissions problem!!!

By using Dolphin>Root Actions>Change Permissions I've been able to make the file "open" again. (I wonder why this works but nothing else???)

*BUT* - That leaves me back with my original problem. When I try to open my Database I get the error "No SDBC driver found".

This is now urgent and I must get an answer to this.

Thanks guys

Ian Whitfield
Pretoria

//

Ian_Whitfield · January 27, 2012, 1:37pm

OK - I've been doing some Googling on this problem.

It seems to be known about and is listed as 'Bug 32948'.

Does anyone know what the current status of this bug is? Or seen as Alex Thurgood's name comes up a lot in the Bug Report does anyone have his eMail address so that we can get an update on this??

If it has NOT been fixed it makes Libre Office a NO-GO for anyone using Base on a regular basis (like me)!!!

Thanks guys.

hstoellinger · January 27, 2012, 1:52pm

Hi,
I can only agree with you. The only connector that works really well is the
native one. Using ODBC is "buggy" and the Java-Connector is (for the Java state
of affairs!) sooooo slow!
It would be good to step up the priority of the connector (and Base as a whole,
ofcourse!)
Regards
Heinrich

Tom_Davies · January 27, 2012, 2:06pm

Hi
+1
Attracting more devs to Base would be fantastic.
Regards from
Tom

hstoellinger · January 27, 2012, 2:24pm

Hi Tom,
I would if I could (ie. had the time...)
Regards H