Ask Your Question
0

Libre Office Base Error at new DB creation

asked 2016-08-23 22:42:38 +0200

Kott gravatar image

Greetings everyone!

I have Libre Office 4.3, recently installed 5.1 (thought it would help). On top of that I have java oracle 7 and 1.8.0 java openjdk. Whenever I try to create a new db via the db wizard, in all cases i get the same errors:

The connection to the data source "New Database" could not be established.

and

SQL Status: S1000
Error code: -27

file input/output error java.lang.NullPointerException.properties /home/haris/Documents/data_base/New Database.odb

Can anyone point me to the right direction for solving this, because it's of the outmost importance for me to refresh my db skills

edit retag flag offensive close merge delete

Comments

Apparently I forgot to mention that I use ubuntu 12.04

Kott gravatar imageKott ( 2016-08-24 07:58:48 +0200 )edit

In Tools>Options>Advanced "Use a java time enviroment" is ticked, JRE already installed: Sun Microsystem Inc. 1.6.0_39 Oracle Corporation 1.8.0_91 Oracle Corporation 1.7.0_80

Now i386 stands for 32-bit right? which is what i have for all of the above

In class path i pressed "add folder" and added 1.8 openjdk, but still get the same 2 errors

Kott gravatar imageKott ( 2016-08-24 08:16:56 +0200 )edit

Sorry, I now see your comment about OS. My apologies.

Ratslinger gravatar imageRatslinger ( 2016-08-24 17:49:21 +0200 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2016-08-23 23:01:49 +0200

Ratslinger gravatar image

updated 2016-08-24 17:22:57 +0200

Please read both answers on this post (click here) for a couple of possible answers. It also helps to know what operating system you are using.

Sorry, another thought - have you put anything into Advanced Options->Class Path? If not you can also try resetting your user profile - click here. Please follow the directions to re-name the profile vs deleting.

image description

edit flag offensive delete link more

Comments

In Tools>Options>Advanced "Use a java time enviroment" is ticked, JRE already installed: Sun Microsystem Inc. 1.6.0_39 Oracle Corporation 1.8.0_91 Oracle Corporation 1.7.0_80

Now i386 stands for 32-bit right? which is what i have for all of the above

In class path i pressed "add folder" and added 1.8 openjdk, but still get the same 2 errors

Kott gravatar imageKott ( 2016-08-24 11:06:31 +0200 )edit

Added screen to original. Sorry if I wasn't clear on original answer - I wasn't asking you to add anything to "Class Path" but only "IF" you previously added something there. By your original error it really appears to be a Java situation. Really need to know you operating system. Also, since you downloaded LO v5.1 was it 64-bit (probably). And when you say creating a new database was it an "Embedded" database?

Ratslinger gravatar imageRatslinger ( 2016-08-24 17:22:25 +0200 )edit

OK, here is the situation. Ubuntu v12.04 is old and could be 32 OR 64 bit. LO v4.3 is 32-bit. LO v5.1 could be 32 OR 64 bit. Things must somewhat match. That is, if 32-bit OS then all must be 32-bit. If 64-bit OS, then Java and LO must match (both either 32 or 64 bit). Normal DB work or macros in general only need JRE installed. JDK includes JRE but more for development and it's a much larger download. You must also select which JRE to use (screenshot).

Ratslinger gravatar imageRatslinger ( 2016-08-24 18:30:02 +0200 )edit

(Comment area too short!) Shouldn't need to add anything to "class path" if just a basic set up. With all that's been noted, can you provide what bit types you have installed for all mentioned? That is OS, LO & Java(which I believe you say it's 32). If Java is 32-bit then LO v4.3 should work with Oracle Corporation 1.8.0_91 or Oracle Corporation 1.7.0_80 selected.

Ratslinger gravatar imageRatslinger ( 2016-08-24 18:38:44 +0200 )edit

Ratslinger thank you for your reply, but will need a bit of more help.... In Base 4.3 I tried all 3 options (Sun Microsystem Inc. 1.6.0_39, Oracle Corporation 1.8.0_91, Oracle Corporation 1.7.0_80) and still got the same errors that were mentioned above.... My OS is 32 bit, you said base 4.3 is 32 bit, and java is i386 which stands for 32 bit as well...

What are your thought on that matter? How come and java does not connect somehow to libreoffice???

Kott gravatar imageKott ( 2016-08-25 11:23:22 +0200 )edit

Here is where I'm at. You have 32-bit OS ( check by running getconf LONG_BIT in terminal). Just to clarify LO is available in 32 or 64 bit for all versions I looked at (x86 = 32; x86-64 = 64). Java can be 32 or 64 (i386 = 32; x64 = 64). Since you state your OS is 32 then LO is 32 since 64 won't run in 32. Your Java is 32(i386). Can't duplicate your problem, so setting up Ubuntu 12.04 32-bit and will get back with results.

Ratslinger gravatar imageRatslinger ( 2016-08-25 18:35:51 +0200 )edit

I set up Ubuntu v12.04.5 32-bit. Uninstalled LO v3.x (didn't work anyway). Installed LO v4.3.7.2. No Java was installed. I had jre1.8.0_101 previously downloaded & extract to it's own folder. Using Tools->Options->LibreOffice->Advanced selected Add.. button & pointed to extracted jre1.8.0_101 folder. Message - couldn't find. Downloaded jre-7u80-linux-i586.tar.gz from Oracle & tried same as jre1.8.0_101 and everything worked fine. Created .odb, table, form - all worked.

Ratslinger gravatar imageRatslinger ( 2016-08-25 21:13:57 +0200 )edit

If it were me I would remove all the Java versions currently installed and install the mentioned one from: Oracle.. If that doesn't work, reset LO user profile, and finally uninstall then reinstall LO.

Ratslinger gravatar imageRatslinger ( 2016-08-25 21:21:21 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2016-08-23 22:42:38 +0200

Seen: 362 times

Last updated: Aug 24 '16