Re: Advice requested regarding Access database in Java

From: Bjorn Abelli (DoNotSpam.bjorn_abelli_at_hotmail.com)
Date: 02/24/04

  • Next message: Lin DeNoyer: "Re: Advice requested regarding Access database in Java" 
    Date: Tue, 24 Feb 2004 21:51:37 +0100

    "Lin DeNoyer" wrote...

    > Also, I wonder if each student would need a copy of
    > Access if we stick with Access as our DB. Or can
    > each student access the Access DB through Java?

    AFAIK, the JET-database in Access would still be accessible through the
    ODBC-driver/JDBC-ODBC-bridge, even if MS Access in itself isn't installed,
    but...

    > In fact, thinking about it, I could quite easily
    > provide all the database info separately, for
    > inserting into a new database if a different DB
    > structure is more universal. We intend that the
    > database + Java interface be available for
    > Linux as well as PCs.

    I wouldn't say that the structure of DB is much less universal than any
    other. As most DBs today it conforms to most of standard SQL-92, which I
    would say is a minimum of "universality"...

    But, if you *still* want each student/researcher to have his/her own copy of
    the database, even on different platforms, then Access maybe shouldn't be
    your primary choice in the long run...

    In that case you should be looking for a DB that can run on both platforms,
    such as the Java-based ones.

    Another choice I come to think of is whether they are connected to a
    network, where you can have a DB-server running. Each student/researcher
    could still have his/her own space on that.

    Now I'm up to 4c... :-)

    // Bjorn A

  • Next message: Lin DeNoyer: "Re: Advice requested regarding Access database in Java"

    Relevant Pages

    • 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)
    • Stuff the purple heart programmers cook up
      ... C To act like a framework for the JDBC driver developers. ... D To hide the specifics of accessing particular kinds of database ... Topic: Java 2: Survey Author: Chris Mc Devitt ... The JDBC ResultSet is actually an interface java.sql.ResultSet. ...
      (comp.lang.java.programmer)
    • Re: selecting a language
      ... > languages to write our application in, as Progress is becoming ... Progress is a 4GL language so it is very rapid development. ... database access from GUI code. ... Java has a lot of built in support for it. ...
      (comp.lang.java.programmer)
    • Re: connecting to a database
      ... I have no idea how to set up a connection. ... connection to an Access Database that they would be willing to post. ... throws java. ... sql. ...
      (comp.lang.java.programmer)
    • Re: acceptable way to program
      ... Objective research by Oracle and IBM have both shown ... Backup isn't a query with any commercial relational database. ... written in Crsytal Reports or Cognos and not have Java front-end. ... weigh heavily against even the knowlegeable DBA insisting that the ...
      (comp.lang.java.programmer)