This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
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 Android Security Essentials Live Lessons this week in the Android 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: 38044
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: 18541

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:
subject: MySQL Javax.mail Shared Drive
Similar Threads
mysql connector
share same object between 2 different web application
Shared Database Access
Hibernate with MySql or MS Acess in Standalone Application ?
Servlets with JDBC and MYSQL