can I access a Base database with java

vhradice · November 27, 2015, 4:33am

I currently have a small database that I created using Base. It is using the default dbms - HSQL 1.18. I would like to be able to access the database using Java to pull some data from it. To do so through Base would be very time consuming. I do have java installed:
Operating environment:

OS - Fedora 21 - 64 bit
LibreOffice 5.0.0.5
Java java -version
openjdk version “1.8.0_65”
OpenJDK Runtime Environment (build 1.8.0_65-b17)
OpenJDK 64-Bit Server VM (build 25.65-b01, mixed mode)

Can I do it?
If so, is there some documentation that describes what I need in the java program to make the connection?
Thank you,

EasyTrieve · October 8, 2016, 3:02am

1+ for a good question. But please fix spelling mistake in first line: “hace” to “have”.

EasyTrieve · October 8, 2016, 3:05am

Similar to this question: How to read .odb file in java using JDBC?

PYS · November 28, 2015, 6:57am

Hi

May be you can find information here ( e.g. DataAwareness) and here (Dev. guide).

Regards

peterwt · November 28, 2015, 11:58am

As far as I know there is no way an external program can access the Tables in a Base database. This would require an ODBC or JDBC driver for .odb files and there aren’t any or any plans to create them. You can work the reverse way and connect base to other database formats where an ODBC driver exists for that database. Base is primarily a front end to connect to databases.

You could:-

Export the Base Tables to a spreadsheet and connect to the spreadsheets.
Export your Base Tables into another database format which you can access via Java.