Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2014
    Posts
    2

    Looking for suitable database

    Hi,
    Our team maintains several java applications that currently all use the same Microsoft Access (2007) database. The ".mdb" file resides on a network share and is accessed concurrently by not more than fifty users. At least once a month the ".mdb" file gets corrupted and as a result the users cannot use the applications. In such cases we restore the database from a backup.
    I am seeking an alternative database which will not "crash" and would like to hear suggestions since I have no experience with other databases in similar environments even though I have worked in the past with Oracle and Informix.
    I have heard of mySql and PostgreSQL but have not experimented with them.

    Thanks for reading and thanks (in advance) for your help.
    Avi.

  2. #2
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    495
    Are you using a SPLIT db?
    If its NOT split and many people use it , it will crash.
    You MUST split the db to prevent this.

  3. #3
    Join Date
    Oct 2014
    Posts
    2
    Quote Originally Posted by ranman256 View Post
    Are you using a SPLIT db?
    If its NOT split and many people use it , it will crash.
    You MUST split the db to prevent this.
    ranman256,
    I am unfamiliar with this concept of SPLIT database that you mention so I looked it up on the Internet and I understand that it means splitting the database tables from other Access entities such as queries and forms.
    Please note that our database contains only data - no forms and no queries.
    The data is accessed exclusively via java applications, using JDBC.
    The database contains approximately 20 tables where the largest table contains about 25,000 rows.
    All table columns have data type of either VARCHAR or INTEGER.

    Cheers,
    Avi.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •