Java DB Client-server technology - centralized DB - How?

Your question suggests that you will need one database on one computer. Let's call it a DB computer. I'd suggest this be a server, that no one from regular staff, such as secretary, manager, etc... can access.

How to make the database accesible by all, since the application will be installed on computers that I mentioned above, do I have to install it (the database) on these computers and this modification, the constraints of consistency and integrity of the database will be violated. Your question suggests that you will need one database on one computer. Let's call it a DB computer.

I'd suggest this be a server, that no one from regular staff, such as secretary, manager, etc... can access. Having one central database will eliminate your worries about integrity violation. Now, you have two options.

You can make a web application that your users will use to interact with your system. This is a more modern approach, since you'll have a 3 tier system: users will access your application via a browser the web application itself is stored on an application server, and it is accessing the database the database is the backend part The second option is making a desktop application and deploying it to everybody's computer that will use it; and afterwards making it connect to the database for interacting with it. The first option is easier when you want to expose your application to a large number of users (and to the web), but know what you're doing when doing stuff like this, since you have to take security very seriously.

If you go the first route, you will need a few things: First, a database. Use what you can, but if you need free and high quality databases, use PostgreSQL or MySQL. Second, an application server.

I suggest using Tomcat or GlassFish. Now, you need to develop your application using JavaEE. There is a wealth of information about this, so I hope this will help you in the beginning and point you in the right direction.

Note that Tomcat doesn't support Java EE fully, but a subset of it. And this subset is surely more than enough for what you need to accomplish.

Thanks man! I'm realy very grateful! – alibm Feb 6 at 20:23.

If I understand you correctly, you are looking for ways to implement a client-server system, where several clients on distinct computers each connect to a central server (or cluster of servers) hosting a DB. In Java, usually (but not necessarily) the DB is inside a web application, and the clients are lightweight web clients - in this case it is usually called an enterprise application. Java has a whole dedicated SDK for this, called Java Enterprise Edition.

You may find many questions dealing with this on SO, here are a few which I think may be especially helpful: Is the offical Sun Java EE tutorial the best way to learn how to make Java web apps? What to learn for making Java web applications in Java EE 6?

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.

Related Questions