Ask Your Question
0

Do I Need Java To Create A Database? [closed]

asked 2014-05-11 17:12:20 +0100

JEJeffrey gravatar image

updated 2015-09-05 20:28:51 +0100

Alex Kemp gravatar image

I am happily running Libre Office 4.2.3.3 under Windows 8.1. I have a lot of data in a *.ods spreadsheet and want to write a 'front end' using Libre Office Base to produce reports, allow queries etc. When I launch 'Base' and point it to the spreadsheet, I get a message telling me I need Java Runtime Environment on my PC (and presumably on any PC that I copy the front end to).

I would prefer not to install (or rely on) any extra software unless it is essential. Is there another way of doing what I want to do without involving JRE?

The data spreadsheet is on a network-attached drive so I can access it from any PC on my home network, but I don't think the situation would be any different if it were on the PC local drive.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-24 11:40:59.947645

1 Answer

Sort by » oldest newest most voted
0

answered 2014-06-01 01:13:54 +0100

frofa gravatar image

updated 2014-06-01 01:15:51 +0100

It seems that 'file-based' data sources (like spreadsheets) require drivers that don't support advanced SQL functions - see this thread, so you might need to import your .ods file into Base to run SQL queries and reports based on such queries. You're in a bind, because currently the default Base 'engine' is HSQLDB v1.8 which requires JRE. You could use Base as a front-end to various other 'flavours' of SQL 'backends' such as MySQL, PostgreSQL, and (hopefully soon Firebird), and provided 'direct' drivers exist (and I think they do), you would not need JRE to connect to your database. Note: JRE is also required for many (?) of the wizards, and the REPORT BUILDER (RB) in Base, so you might have to do without those to - see this list of Java dependencies in Base. It's possible to do without RB and use Calc to do your reporting.

edit flag offensive delete link more

Question Tools

2 followers

Stats

Asked: 2014-05-11 17:12:20 +0100

Seen: 1,719 times

Last updated: Jun 01 '14