javing
javing

Reputation: 12423

Database for dummies

I need a free database for my web app made in Java EE 6. I use glassfish server V3.0. Could someone recommend me one that is easy to setup and use(for dummies :) )? And also some good instructions.

I just had a horrible experience trying to install MySQL 5.5. It was impossible for me to connect to the database, i was getting all the time a 10061 error, i tried everything and i just gave up. Just please dont tell me MySQL :)

Also i want to mention that i use winXP SP3 and my programming IDE is eclipse Helios

Upvotes: 0

Views: 294

Answers (4)

Matt Handy
Matt Handy

Reputation: 30025

Note that Glassfish comes with JavaDB (aka DerbyDB) bundled. So you do not need to install any other database (if JavaDB fits your needs)

You can start the database server with the followind command:

glassfish-install/bin/asadmin start-database --dbhome directory-path

See this page for more information.

Upvotes: 0

squawknull
squawknull

Reputation: 5192

Mysql. :) Seriously, it is THE most popular open source database. Postgres is good too, but Mysql is undoubtedly more popular and you're going to find more hosts that provide you a Mysql database, for instance (if that matters).

Try a Windows LAMP (Linux, Apache, Mysql) package. For instance, try WAMP (http://www.wampserver.com/en/). This will come with phpmyadmin, a pretty good web based admin console for Mysql.

Otherwise, you could try SQL Server Express, a free version of Microsoft SQL Server: http://www.microsoft.com/express/Database/.

Upvotes: 1

duffymo
duffymo

Reputation: 308898

There's little that's easy about Oracle.

I'd recommend PostgreSQL if MySQL won't work for you. It has a very nice admin console, too. You might like that better than the command shell.

Or maybe Derby, the database that's built into JDK 6 and higher.

Or perhaps Hypersonic SQL.

Upvotes: 3

Charlie
Charlie

Reputation: 7349

Depending on what you're developing for, I'm partial to Oracle Express Edition. It's free, relatively easy to get going, and everything you write against it, will work on an full blown Oracle database. (Since it is basically a full blown Oracle 10g database, just limited).

Upvotes: 0

Related Questions