DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3
  1. #1
    Join Date
    May 2007

    java app with sql database

    I have a beginners question, I am learning Java, databases and trying to create a Java application that talks to a SQL server. My question is typically when I would like to install the application, Is there a way one can get away without installing the SQL server, in other words can one store the data in some manner (files..etc) and then use the same application which internally uses SQL queries to query the data. An example situation is I want to give this application to somebody and they do not have SQL server...

    Any help/suggestions will be greatly appreciated..

  2. #2
    Join Date
    May 2007
    As far as I know, you could put the database in an Access file (please don't shout at me ) and you could connect to that database. It would just be local then, but since your friend doesn't have an SQL Server, I'm assuming that's not a problem.

    You'd have to adjust your program to access that database though.

  3. #3
    Join Date
    Dec 2003
    No, you can't store data into a regular file and then use SQL to read it out from the file. You must use an SQL relational database in order to use SQL commands to access data. You can using Object Serialization (ObjectOutputStream) write objects into a file and then read them back into memory from the file using Object Deserialization (ObjectInputStream), but there are no SQL queries involved with this technique.


Similar Threads

  1. run java app on Linux at boot up
    By Alan Shiers in forum Java
    Replies: 3
    Last Post: 07-16-2002, 11:29 PM
  2. Replies: 3
    Last Post: 06-28-2002, 07:36 AM
  3. Cool 3 Tier Java database solution
    By russ in forum Java
    Replies: 1
    Last Post: 06-05-2002, 09:07 AM
  4. .NET vs. Enterprise Java: Who's Got Better Security?
    By Glen Kunene in forum Talk to the Editors
    Replies: 17
    Last Post: 03-23-2002, 12:43 AM
  5. VB script for SQL database
    By jim in forum VB Classic
    Replies: 1
    Last Post: 02-02-2001, 12:40 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
HTML5 Development Center
Latest Articles
Questions? Contact us.
Web Development
Latest Tips
Open Source

   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.