JAVA netbeans/desktop application/database question

Question

0.00/5 (No votes)

See more:

Hi,
I was hoping someone could help me. In the past, I wrote desktop applications using Visual Basic. The applications were standalone that read MDB database files not connected to a server or DB management system. The database files could be browsed and modified outside of my application using MS Access and other DB management software that processing MDB files.

Is there something similar for JAVA. I am using NetBeans, Derby (but could use some other DB). This is what I want to do. Where can I find more info. maybe a website, Youtube vid, etc.

- Develop desktop applications using JAVA. I prefer Netbeans for my IDE. (Eclipse is also an option).
- Create a database and tables using a DB management system.
- The database is a standalone file that could be used with the desktop application.
- The desktop application written in Java can process the database contained within the standalone file. for example, something like *.MDB.
- The database could be manipulated, maybe add a new column after the program is using it, using a DB management system.

BTW, I have used embedded databases with my JAVA programs. That is good except how could I read the database into a DB Management system to add a column for example?

Any info is appreciated.
Thanks,
Steve

What I have tried:

I have used embedded databases with my JAVA programs. That is good except how could I read the database into a DB Management system to add a column for example?

Posted 19-Oct-17 10:39am

Member 13387568

Add a Solution

Comments

Mohibur Rashid 19-Oct-17 17:27pm

Msaccess is still an option, you can look up sqlite

Member 13387568 19-Oct-17 20:55pm

Hi Rashid,
I got it to work with a JAVA program accessing a MDB file using the ucanaccess jdbc jar files. Have you heard of that. Has anyone heard of that approach? I am only using this for my own personal use. Thank you, Steven

Mohibur Rashid 19-Oct-17 21:35pm

I never used UCanAccess; if it feeds your needs then why not?
And of course google is your friend, look for JDBC for MDB, you will get many answers. And if you want portability, I don't know whether you can use MDB in other os or not, then SQLite3 will not be bad. FYI, many applications, such as google chrome, use SQLite3;

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)