Results 1 to 4 of 4
  1. #1
    mainy is offline Member
    Join Date
    Feb 2009
    Posts
    38
    Rep Power
    0

    Default Quick and easy question about SQL databases.

    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.

  2. #2
    PhHein's Avatar
    PhHein is offline Senior Member
    Join Date
    Apr 2009
    Location
    Germany
    Posts
    1,429
    Rep Power
    7

    Default

    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.

  3. #3
    mainy is offline Member
    Join Date
    Feb 2009
    Posts
    38
    Rep Power
    0

    Default

    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.

  4. #4
    PhHein's Avatar
    PhHein is offline Senior Member
    Join Date
    Apr 2009
    Location
    Germany
    Posts
    1,429
    Rep Power
    7

Similar Threads

  1. Quick and Easy Job.
    By Scottyb in forum Jobs Offered
    Replies: 3
    Last Post: 08-11-2009, 04:48 PM
  2. New to Java and have an easy question
    By JBOY08 in forum New To Java
    Replies: 1
    Last Post: 11-19-2008, 08:40 PM
  3. quick easy question
    By jmHoekst in forum New To Java
    Replies: 1
    Last Post: 06-19-2008, 04:28 PM
  4. Noob question- easy
    By mattonitto in forum New To Java
    Replies: 7
    Last Post: 06-13-2008, 01:26 AM
  5. Easy question
    By JavaNoob in forum New To Java
    Replies: 10
    Last Post: 08-03-2007, 11:28 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •