Same Java SQL database engine on both client and server make more sense?

From: Phil Latio (phil.latio_at_f-in-stupid.co.uk)
Date: 07/29/04

  • Next message: Roedy Green: "Re: Same Java SQL database engine on both client and server make more sense?" 
    Date: Thu, 29 Jul 2004 03:24:10 GMT

    I would like to hear opinions as I am venturing into the murky world of Java
    databases for a project I wish to undertake.

    Agents are wanting to use laptops to collect information. It's been decided
    that they will need to go online twice a day and connect to a MySQL
    database.
    1. in the morning to download information regarding job instructions for the
    day.
    2. in the evening to upload the collected data.

    My initial plan was to build a Java application for the agents laptops which
    includes an embedded Java SQL database engine (such as HSQL, Mckoi, etc)
    that communicates with MySQL. However I wonder if I have been looking at
    this the wrong way and it make more sense to run the same Java SQL database
    engine on both the agents laptops and the server (discarding MySQL on the
    server).

    Can anyone recommend a suitable database?

  • Next message: Roedy Green: "Re: Same Java SQL database engine on both client and server make more sense?"

    Relevant Pages

    • Re: Java and MySql program example ?
      ... > I am trying to learn Java and need an example program with MySql ... > MySql database. ... Database connection established ...
      (comp.lang.java.programmer)
    • Re: mysql vs sqlite vs hsql
      ... My question isabout benchmarks and multiple inserts & ... > I current have a mysql database of approx. ... lemme dispell the very common misconception that java is slow. ...
      (comp.lang.python)
    • Re: Java and MySql program example ?
      ... > I am trying to learn Java and need an example program with MySql ... > MySql database. ... wants a copy of the code email me at jdanyjavajunkie at yahoo.com ...
      (comp.lang.java.programmer)
    • Re: connecting to a database
      ... so I'm attempting to code it up in java. ... I have no idea how to set up a connection. ... connection to an Access Database that they would be willing to post. ... sql. ...
      (comp.lang.java.programmer)
    • Re: How to modify a MySQL database...
      ... and then update them with Java. ... To learn how to create a MySQL database, ... you will need to learn JDBC. ...
      (comp.lang.java.programmer)