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;
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;
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks all, I shall review them shortly.
Regards;
Regards;
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
> 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..
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..
>> 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
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
> 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.
You can avoid that by specifying the location of the database file in the connect string.
connect string would look like:
"jdbc:odbc:Driver={Microso
"jdbc:odbc:Driver={Microso
ASKER
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.
Thanks very much for all input.
Rob.
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