• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 165
  • Last Modified:

No external-config Database?

Hi.

I wish to use a database to store some data, however, configuring the database (outside of the source code) really isn't at all convenient. So, at the moment, I've created a little something for myself, which uses HashMap's and Vectors, to basically simulate a Database, then uses Serialization to store it all in a file.
Now, for small amounts of data, it's fantastic, soo easy to use - however, when it comes to storing mass data, I don't trust that it's efficient enough.

I've only ever actually used an M$ Access file, however, I don't like this way, not just because M$ Access isn't the best solution, but because it requires external configuration (with the ODBC..).

As for MySQL, you need to download and install MySQL on the system being used right? And doesn't that take a load of configuration also, before use?? :o\

I'm basically looking for the simplest Database solution, please!  :-)

Regards;
0
InteractiveMind
Asked:
InteractiveMind
  • 3
  • 3
  • 3
  • +2
4 Solutions
 
Jim CakalicSenior Developer/ArchitectCommented:
Hi,

Maybe something like db4o would work for you?
http://www.db4o.com/community/
http://www.db4o.com/community/

There's also objectDB, but now you're getting into JDO ...
http://www.objectdb.com/

If it's a small database you're talking about -- something that fits in memory -- than you might think about prevayler:
http://www.prevayler.org/wiki.jsp

Best regards,
Jim Cakalic
0
 
aozarovCommented:
You can use Hibernate, http://www.hibernate.org/,  one of the most popular object/relational mapping tools that can also create the schema for you (if that is part of the configuration you want to avoid).
0
 
aozarovCommented:
>> As for MySQL, you need to download and install MySQL on the system being used right?
You need to download and install mySQL server somewhere but your jdbc clients don't have to be on the same machine.
They only need the jdbc driver http://www.mysql.com/products/connector/j/

>> And doesn't that take a load of configuration also, before use??
it is not that bad.
see http://www.devside.net/web/server/windows/mysql
or the official guide for installing on windows (using the wizard) http://dev.mysql.com/doc/mysql/en/windows-install-wizard.html
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
InteractiveMindAuthor Commented:
Thanks all, I shall review them shortly.

Regards;
0
 
Dejan PažinCommented:

If you are looking for the simplest database to use with java, I'd suggest HSQLDB: http://hsqldb.sourceforge.net/web/hsqlDocsFrame.html

A few important features:

1. Its written in Java
2. You can start it from within your application
3. Very easy to use
4. Its free

Based on your description of the problem I dont think you need a very sufisticated solution (like using Hibernate or any other OR mapping tool which will only add to configuration work)
0
 
objectsCommented:
>  but because it requires external configuration (with the ODBC..).

You can use Access db directly without any external setup.
0
 
InteractiveMindAuthor Commented:
> You can use Access db directly without any external setup.
Really? :o\ Oh.. it's just that my book shows you that you need to register the DB with ODBC before use... I figured that I *had* to do this..
0
 
aozarovCommented:
>> Really? :o\ Oh.. it's just that my book shows you that you need to register the DB with ODBC before use... I figured that I *had* to do this..
There are plenty of JDBC drivers that can MS Access and not via a type 1 driver (odbc).
For a list see:  http://developers.sun.com/product/jdbc/drivers/search_results.jsp?jdbc_version=0&vendor_name=&cert_mode=and&jdbc_driver_type_mode=and&dbms=6&dbms_mode=and&features_mode=and&results_per_page=20&submit=Search
0
 
objectsCommented:
>  it's just that my book shows you that you need to register the DB with ODBC before use

You can avoid that by specifying the location of the database file in the connect string.
0
 
objectsCommented:
connect string would look like:

"jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)}; DBQ=C:\\db\\mydb.mdb "
0
 
InteractiveMindAuthor Commented:
I'm going to have to come back to databasing a bit more, another time.. So, I'll split the points between you guys.

Thanks very much for all input.
Rob.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
  • 3
  • 3
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now