jQuery in Action, 3rd edition
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

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Java » Java in General
Bookmark "MySQL Javax.mail Shared Drive " Watch "MySQL Javax.mail Shared Drive " New topic

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

Joined: Oct 13, 2005
Posts: 46435
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

Joined: Oct 14, 2005
Posts: 19973

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

This article I found suggests the same.

Thanks for your help.
I agree. Here's the link: http://aspose.com/file-tools
subject: MySQL Javax.mail Shared Drive
It's not a secret anymore!