Results 1 to 5 of 5
  1. #1
    drdespair is offline Member
    Join Date
    Dec 2011
    Posts
    3
    Rep Power
    0

    Default Network File based Databases with Java for multi application access

    Hello all.

    I am trying to figure our what would be the appropriate database to use if I am limited to storing the database on a local network drive and it must allow multiple users using instances of the same desktop application to go in and update individual records without locking up the whole database per connection. From what I understand JavaDB can only have 1 active connection in that type of setup, or am I mistaken?

    Thank you!

    DrD

  2. #2
    Tolls is offline Moderator
    Join Date
    Apr 2009
    Posts
    11,949
    Rep Power
    19

    Default Re: Network File based Databases with Java for multi application access

    In those situations you need a single database server that controls what goes on in the database.
    You can't maintain integrity in the database file if you have multiple different database servers accessing it.

  3. #3
    drdespair is offline Member
    Join Date
    Dec 2011
    Posts
    3
    Rep Power
    0

    Default Re: Network File based Databases with Java for multi application access

    I am coming from a VBA background. I have a tool made from excel forms that users use to update records in an Access Database. ADODB commands like:
    Java Code:
    rsData.Open "SomeTable", sConnect, adOpenForwardOnly, adLockOptimistic
    allow to control the type of Locking that happens on the record.
    Database servers are out of the question in my environment :( it has to be files on a network drive.

  4. #4
    JosAH's Avatar
    JosAH is online now Moderator
    Join Date
    Sep 2008
    Location
    Voorschoten, the Netherlands
    Posts
    13,454
    Blog Entries
    7
    Rep Power
    20

    Default Re: Network File based Databases with Java for multi application access

    JavaDB has two drivers: an embedded one for a single user and a network one for multiple users; if you use the network driver you should start a JavaDB server first. (it's all in the (excellent) documentation).

    kind regards,

    Jos
    cenosillicaphobia: the fear for an empty beer glass

  5. #5
    drdespair is offline Member
    Join Date
    Dec 2011
    Posts
    3
    Rep Power
    0

    Default Re: Network File based Databases with Java for multi application access

    So far all proposals here call for a server approach, this is not possible in my environment, I am not allowed to run my own server in the environment I am using, and they wont let me use existing servers ether. The data needs to be store in a file on a network drive and allow to multiple users to access for reading and updates individual records.

Similar Threads

  1. Java Based Application to Map Network Drive
    By Wraithier in forum New To Java
    Replies: 15
    Last Post: 05-24-2012, 11:09 AM
  2. Replies: 4
    Last Post: 07-06-2010, 09:40 AM
  3. Entity - Field-Based Access Vs Property Based Access
    By CatchSandeepVaid in forum Enterprise JavaBeans (EJB)
    Replies: 3
    Last Post: 11-02-2009, 07:18 PM
  4. Replies: 2
    Last Post: 04-06-2009, 05:52 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
  •