aspose file tools*
The moose likes JDBC and the fly likes A general question but still need a suggestion on JDBC. Important to know for me!!! Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "A general question but still need a suggestion on JDBC. Important to know for me!!!" Watch "A general question but still need a suggestion on JDBC. Important to know for me!!!" New topic
Author

A general question but still need a suggestion on JDBC. Important to know for me!!!

Pranit Sonawane
Ranch Hand

Joined: Jul 29, 2011
Posts: 149

Hi am using windows 7 64 bit OS. I wanted to know to store a database, should i use MS-Access. Is it secured? Does that crash? or please help me with the database management system..!! Many Thanks!!
Wendy Gibbons
Bartender

Joined: Oct 21, 2008
Posts: 1106

I would never use access, but that was because 10 years ago, it was rubbish, it may have improved.
I would use mySQL, some people on here would recommend postgreSQL.
Rob Spoor
Sheriff

Joined: Oct 27, 2005
Posts: 19544
    
  16

It depends. Access is OK if it's not shared by multiple people and you already have a license for it. If you don't I wouldn't bother buying it, it's too expensive. Access is also notorious for its poor support for concurrent access.
If you need concurrent access or don't have a license, there are still many choices. If money is an issue (like when you need it at home) then go for one of the free choices; MySQL and PostgreSQL are recommended most often. If it's for a company and you have budget for it you can still go for one of the free choices, but you can also choose Oracle or MS SQL Server.


SCJP 1.4 - SCJP 6 - SCWCD 5 - OCEEJBD 6
How To Ask Questions How To Answer Questions
Wendy Gibbons
Bartender

Joined: Oct 21, 2008
Posts: 1106

Rob Spoor wrote:It depends. Access is OK if it's not shared by multiple people and you already have a license for it. If you don't I wouldn't bother buying it, it's too expensive. Access is also notorious for its poor support for concurrent access.
If you need concurrent access or don't have a license, there are still many choices. If money is an issue (like when you need it at home) then go for one of the free choices; MySQL and PostgreSQL are recommended most often. If it's for a company and you have budget for it you can still go for one of the free choices, but you can also choose Oracle or MS SQL Server.


so my main complaint still hasn't improved, couldn't handle 10 people at once
Matthew Brown
Bartender

Joined: Apr 06, 2010
Posts: 4240
    
    7

Wendy Gibbons wrote:so my main complaint still hasn't improved, couldn't handle 10 people at once

To be fair, it's never been designed for that. And if you want a proper database, Microsoft will be more than happy to sell one to you .
chris webster
Bartender

Joined: Mar 01, 2009
Posts: 1479
    
  11

If you're looking at a scalable open source choice, I would go for PostgreSQL, which IMHO is a more robust alternative than MySQL. Plus I like elephants.

If you want to try a commercial vendor, you can start with the free Oracle Express Edition (Oracle XE), which has a restricted licence but can be used commercially as well as for personal use:

Oracle Database XE can be installed on any size host machine with any number of CPUs (one database per machine), but XE will store up to 11GB of user data, use up to 1GB of memory, and use one CPU on the host machine.


Oracle XE is fully compatible with enterprise Oracle, so you can migrate your applications easily to scale up in future. Oracle XE includes most of the core RDBMS tools you will find on any Oracle edition, including PL/SQL and a load of other stuff. I often use Oracle XE to prototype applications that will eventually be implemented on an enterprise Oracle platform, for example.

Combine Oracle XE with the free SQLDeveloper tool, which includes data modelling options and can also be integrated with version control tools like Subversion, and you have a pretty good basis for database application development even before you start building your Java stack. Oracle XE also includes the free Oracle Application Express (APEX) tool for building data-driven web applications really easily without Java, but I'm guessing nobody around here would talk to you if you used that!

There is also a free edition of Microsoft's SQL Server, which is probably easy to integrate with Visual Studio and .NET etc, but I don't know anything about it. Maybe I'll try it out...

All of the above options are serious relational databases that will give you access to many of the core features available on any enterprise RDBMS, so any work you do on these will teach you useful skills for working with any database.

I wouldn't use Microsoft Access.


No more Blub for me, thank you, Vicar.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: A general question but still need a suggestion on JDBC. Important to know for me!!!
 
Similar Threads
database interactions in struts
SCJP2 SYLLABUS CHANGE
Connection to MySQL
How to create Database VIEW at runtime in JSP?
dbcp