Quick and easy question about SQL databases.

[mainy]

Hi,

I am building an application which gets alot of information from files. Since I have never used SQL in a java enviroment I decided to use hashMaps, however as I have got further into the projects this has got very messy.

Basically, all I want is a .sql which the program does queries on and stores the returned result into variables. I have been looking into how to implement SQL into java and it appears I need to install an SQL connecter and other stuff.

The question is, when I compile this program as a Jar file, will the user need to have SQL (or connecter) installed on their computer for it to work and does the sql file get packaged into the jar file.

[PhHein]

You can add the db driver to your jar file. Normally you connect to a database which is accessible over the IP of the server. Distributing a whole database is not practical. If you want to use a local DB, then that has to be installed on every client machine.

[mainy]

hmm... So let me get the right. I would need to host the database somewhere on the internet (or local box). Then inside the application, the db connection url would be that IP address?

If that is correct it may make things so much easier in terms of updating of database and creating some kind of validation method.

[PhHein]

Basically yes. Please read this tutorial to get an idea:
http://www.java-forums.org/java-tuto...nectivity.html