aspose file tools*
The moose likes JDBC and the fly likes Which database i use Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Which database i use" Watch "Which database i use" New topic
Author

Which database i use

sharjeel afzal
Greenhorn

Joined: Sep 30, 2009
Posts: 22
hi
i want to install my java desktop application on client side
i want that if DBMS is not installed on client side then DBMS also installed
on client side along with my application

Please suggest me what DBMS i use or suggest me if DBMS is not required
on client side is there any database exist

i heard about MS Access DB is used in program that not required DBMS on client side.....


Lester Burnham
Rancher

Joined: Oct 14, 2008
Posts: 1337
You can't assume that Access is installed on random Windows machines.

The easiest would probably be HSQLDB or Derby, both of which are written in Java and can be used in embedded mode from within the app itself.
sharjeel afzal
Greenhorn

Joined: Sep 30, 2009
Posts: 22
Thank you very much

please tell me if you know any gui manager for Derby
Lester Burnham
Rancher

Joined: Oct 14, 2008
Posts: 1337
If you're looking for something free, try Squirrel SQL Client. It works with any JDBC-enabled DB.
Nikhilkumar Deshmukh
Greenhorn

Joined: Nov 06, 2010
Posts: 2
I am new in development and I am making a project in java but I can't decided that which database use for it. I know it is very small problem but I am start
Vijitha Kumara
Bartender

Joined: Mar 24, 2008
Posts: 3775

Nikhilkumar Deshmukh wrote:I am new in development and I am making a project in java but I can't decided that which database use for it.

It depends on the type of the project, expected load etc... But if you just want to try things then get Derby (which is Java based in-memory database).


SCJP 5 | SCWCD 5
[How to ask questions] [Twitter]
Prabhakar Reddy Bokka
Ranch Hand

Joined: Jul 26, 2005
Posts: 189

Dude!!

If it is a real time project then it depends on many things...

If it is just for your practice.. you can use any database.

As you said you are new to java development, I suggest you MySql database.

SCJP 5, SCWCD 5
Jan Cumps
Bartender

Joined: Dec 20, 2006
Posts: 2476
    
    7

Prabhakar Reddy Bokka wrote:Dude!!...
No such person on the JavaRanch. Please be polite.


OCUP UML fundamental and ITIL foundation
youtube channel
Wendy Gibbons
Bartender

Joined: Oct 21, 2008
Posts: 1106

i would also recommend mysql for a starter, as i found derby impossible to debug, when i had a problem, as the program had the only allowed connection so i couldn't check my results as i stepped through.
But once you are past that stage derby (or the other embedded database recommended) for customer installations.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Which database i use
 
Similar Threads
Swing Database application which runs from Desktop (Win/Lin)
which installer i use and what DBMS
which installer i use
How to create a notification webservice
how to make installer