This week's book giveaway is in the Agile and Other Processes forum.
We're giving away four copies of The Little Book of Impediments (e-book only) and have Tom Perry on-line!
See this thread for details.
Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

distributing database for several systems

 
Abhay Arora
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi.. I wanted to build an application that could run separately on several networked system, using a common database(MySQL preferably)..
Could anybody help me with this..



Abhay Arora
OCPJP6
 
William P O'Sullivan
Ranch Hand
Posts: 859
Chrome IBM DB2 Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello Abhay,

Your question is very very vague.

What is this application going to do?

WP
 
Abhay Arora
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
sorry for that, I've tried to make the scenario clear in this post

it is actually a registration system for a college, (the kind where you could register new clients with their details into your system)..
The application needs to run on locally connected computers.
It can be run by more than one system at a time..
However, i need only one consistent copy of the database (no separate databases for separate systems)


Abhay Arora
OCPJP6

 
chris webster
Bartender
Posts: 2407
33
Linux Oracle Postgres Database Python Scala
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Still not clear what you mean by "could run separately", "by more than one system at a time", but "no separate databases".

Do you mean you want one central database (MySQL) that can be accessed from multiple thin clients over a local network? And do you specifically want/have to use Java?

If so, then this sounds like a pretty routine application - I'd suggest going for a browser-based web application as it makes your clients really simple, and it's easier to add different clients (e.g. mobile) later on.

Get a book/tutorial on building database web applications with Java and follow the same approach for your system. Lots of tutorials use the "student registration" example, but be careful not to plagiarise other people's work if you are doing this for a college assignment.

If you have some flexibility in your choice of tools, you could look at Grails, which is great for building this kind of thing quickly. You write your code in Groovy (but you don't need to write much of it to get a fully functional application!), including defining your domain model classes which Grails then implements in the database for you, and the resulting web application is compiled down to JVM bytecode and can be deployed on any JEE server or servlet engine.

However, if you are talking about some kind of distributed, eventually-consistent application (clustered/replicated DBs? master-slave? NoSQL?), you'll need to identify your requirements a little more clearly and investigate appropriate solutions.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic