Results 1 to 4 of 4
  1. #1
    DavidG24 is offline Member
    Join Date
    Apr 2009
    Posts
    49
    Rep Power
    0

    Default Starting with Databasing

    Hey Guys,

    I am completely new to databasing with Java so if some of the terms I use in the following are incorrect from a technical standpoint, please forgive my ignorance.
    I'm in the process of developing an application that requires a conection with a database with roughly 5000 Tables, I want the application to be deployed with the database built into the source directory (or otherwise appropriately based) and if possible without the need for the user to have the DBMS running on their systems. I've noticed that for the likes of SQL Server, MySQL, Oracle the database service must be in use for the connection to be established (again I'm not sure if this is the case) and was wondering if there was another alternative..i.e. to have the database completely self contained (sort of like an access database or maybe a text based database - not sure if thats even possible) ? and if so how would I go about this?

    Also, I was wondering what resources people would recommend to get the basics?

    Thanks in Advance,

    David

  2. #2
    masijade is offline Senior Member
    Join Date
    Jun 2008
    Posts
    2,571
    Rep Power
    8

    Default

    JavaDB/Derby, or SQLite (not heavily recommended), if the client is to have their own DB. If they simply need to make a connection to an existing DB, than, of course, they do not need the DB to be local on their system, and so, do not need a DB running on their system, they need only the JDBC Driver (a jarfile) which you should be distributing with your application (when allowed by the license). That is one of the main purposes behind the JDBC Driver specs.

  3. #3
    DavidG24 is offline Member
    Join Date
    Apr 2009
    Posts
    49
    Rep Power
    0

    Default

    hey masijade,

    thanks for your response, I am hoping to have the database deployed with the application (embedded...if thats the correct terminology) so that the user doesn't have to know about the database whatsoever.

    I created an Apache Derby database and have populated the tables, so from here I'm lost as to what I am suppose to do to 'join' the database to the application.

    I apologise if my questions are trivial, I'm a complete noob - do you know of any good sites / textbooks to learn about this sort of stuff?

    Thanks,

    David

  4. #4
    masijade is offline Senior Member
    Join Date
    Jun 2008
    Posts
    2,571
    Rep Power
    8

    Default

    If it is to be embedded (i.e. not a server/client DB), then all you need to distribute is derby.jar and the DB itself is simply a directory and it's contents that can also be distributed with your application, or can be created at run time if you wish to create code to do that.

    See the documentation for the location of the DB directory (it is configurable), and about runtime-cretion of the DB. IOW, it's all in the manual.

Similar Threads

  1. starting problem
    By anithananduri in forum New To Java
    Replies: 1
    Last Post: 03-17-2009, 01:27 PM
  2. Need help starting program
    By mk3823 in forum New To Java
    Replies: 8
    Last Post: 11-02-2008, 01:41 AM
  3. Indexing starting with 1
    By ravian in forum New To Java
    Replies: 4
    Last Post: 01-04-2008, 12:03 PM
  4. Help, starting with java
    By mathias in forum New To Java
    Replies: 2
    Last Post: 08-15-2007, 07:15 AM
  5. just starting
    By specbailey in forum New To Java
    Replies: 23
    Last Post: 08-13-2007, 11:25 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
  •