Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

MySQL Javax.mail Shared Drive

 
Claude Cundiff
Ranch Hand
Posts: 78
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Pie
Posts: 48968
60
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Sheriff
Posts: 21107
32
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 78
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks.

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

Thanks for your help.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic