Re: Advice requested regarding Access database in Java

From: Mladen Adamovic (adamm_at_blic.net)
Date: 02/25/04

  • Next message: Flip: "Re: searching for a nice database"
    Date: Wed, 25 Feb 2004 15:27:03 +0100
    
    

    "Lin DeNoyer" <lkd1@cornell.edu> wrote:
    > We will be moving this processing into Java. We are doing so because
    > the 3rd party software is costly, and because it is no longer
    > adequately maintained. The company was sold and we see the
    > handwriting on the wall. Furthermore, we want to be able to allow
    > students and other researchers easier access to the type of
    > processing we do on this database.

    I recommend no, but if it is easy to you to use, use it in standard way -
    create ODBC Access connection then use it in Java via JDBC-ODBC bridge.

    I suggest one of following servers :
    1. Hibernate SQL
    my opinion: pure Java SQL, but a bit buggy, but easy to install, not so slow
    as man ussualy think of Java programs
    2. MySQL
    some versions are free for nocommercial use, but has a lack of full SQL
    compliant, but really fast
    3. PostrgreSQL
    it should be full SQL compliant, but slow, I didn't use it recently, but I
    indend to try (I think this one should be good-old one, as Unix operating
    systems are)

    Good Luck.


  • Next message: Flip: "Re: searching for a nice database"

    Relevant Pages

    • Re: use of DBI; I am getting multiple error messages mixed in with the correct output.
      ... Perl was to relate it to uninitialized values in Java or C++. ... The fact that nulls in SQL have special ... Both Java and C++ have containers that support set theoretic ...
      (comp.lang.perl.misc)
    • Re: SQL
      ... Persistence access is the abstraction, ... However, UML is just one of many OOA/D notations proposed, so it is an implementation of an OOA/D notation. ... Note that I was careful to say that SQL is a solution to persistence /access/ when the data is represented in RDB form. ... Sounds a little bit like Java and the JVM.... ...
      (comp.object)
    • Re: object databases
      ... Calling SQL from say java code is one of the easiest tasks in mordern ... The major problem is that SQL statements are written as strings in ... the strings are not compiled until runtime. ...
      (comp.object)
    • Re: Is perl better? :(((
      ... draw from variable "table" and execute a slightly modified SQL just once. ... > public void openCon(String url, ... > String user, String password) { ... > Total Java expenses 4.5 minutes. ...
      (comp.lang.java.programmer)
    • Re: Quote from student, after teaching Pick
      ... Standford) was "that is NOT a database." ... I had some success leading UniData customers to SQL, ... PHP and Java IIRC. ...
      (comp.databases.pick)