Ask Your Question
1

can I access a Base database with java

asked 2015-11-27 05:33:43 +0200

vhradice gravatar image

updated 2018-10-28 22:33:28 +0200

EasyTrieve gravatar image

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,

edit retag flag offensive close merge delete

Comments

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

EasyTrieve gravatar imageEasyTrieve ( 2016-10-08 05:02:07 +0200 )edit
EasyTrieve gravatar imageEasyTrieve ( 2016-10-08 05:05:01 +0200 )edit

2 Answers

Sort by » oldest newest most voted
1

answered 2015-11-28 07:57:58 +0200

pierre-yves samyn gravatar image

Hi

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

Regards

edit flag offensive delete link more
1

answered 2015-11-28 12:58:25 +0200

peterwt gravatar image

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:-

1) Export the Base Tables to a spreadsheet and connect to the spreadsheets.

2) Export your Base Tables into another database format which you can access via Java.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2015-11-27 05:33:43 +0200

Seen: 1,248 times

Last updated: Oct 28 '18