File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Java in General and the fly likes MySQL Javax.mail Shared Drive Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Java in General
Bookmark "MySQL Javax.mail Shared Drive " Watch "MySQL Javax.mail Shared Drive " New topic
Author

MySQL Javax.mail Shared Drive

Claude Cundiff
Ranch Hand

Joined: Mar 20, 2008
Posts: 78
Hello everyone,

Here is a description of the problem:
_Multiple desktops with access to a shared drive
_Users need to be able to submit information to a MySQL database on the shared drive
_A Java program will then extract information from the database and send automatic emails via the JEE Mail API

My main concern is concurrency, I'll obvisouly have mutiple users inserting data into the tables.

Any thoughts?

I appreciate it!
Campbell Ritchie
Sheriff

Joined: Oct 13, 2005
Posts: 36501
    
  16
Sounds like a candidate for the JDBC forum.



. . . but I always thought the database management systems (DBMSs) eg MySQL handled their own concurrency.
Paul Clapham
Bartender

Joined: Oct 14, 2005
Posts: 18127
    
    8

You access a MySQL database by connecting to its server. It doesn't matter where MySQL stores its data or even where it runs from, all that matters is that the clients have a clear path across the network to the server. And databases are designed for concurrent access, so it's perfectly possible for many clients to insert data at the same time.
Claude Cundiff
Ranch Hand

Joined: Mar 20, 2008
Posts: 78
Thanks.

This article I found suggests the same.
http://www.mysql.com/news-and-events/newsletter/2003-04/a0000000154.html

Thanks for your help.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: MySQL Javax.mail Shared Drive
 
Similar Threads
Shared Database Access
mysql connector
Hibernate with MySql or MS Acess in Standalone Application ?
Servlets with JDBC and MYSQL
share same object between 2 different web application