Please advise.

[xenophobia]

All the time I was using PHPMysql, so I wasn't facing any problem with the connectivity between the client application and the DBMS.

 

But now, I was asked to develop a Java application that are networked, and using the Mysql database.

 

Example:

2 PC are networked in a LAN. 1 is server (DB held here) and the other 1 is client.

The server must be online (not only connect to the lan, but also needed to open my Java application) then only the client can connect and use the application.

 

I have no point on how the client should connect to the database. Shall i open a privileges to all user and make the client connect to Mysql directly using some sort of connector

(this seems unsecure)

 

or

 

Built a server-side application (Java application), to handle the client's requested action toward the database?

(this seems difficult to handle the request!)

 

Help! If you had any articles or tutorial, please forward to this post.

 

Thanks in advanced.

[gluck]

So what is the problem?

 

All you need is the DB server name which was localhost before and would be yr DB-servername now.

Create a DB user and set the access level based on your requirements.

For the Java app. develop an app that is located on the Application server connecting to your DB server.

 

[activeserver]

Built a server-side application (Java application), to handle the client's requested action toward the database?

(this seems difficult to handle the request!)

Standard Servlets, JSP, Struts or what else have you...

a little googling should get you to a quick solution. see tutorialized.com or javaranch.com for JSP/Servlets/Struts.

Use some popular framework like Struts or Spring or JSP.

Don't wase time or effort on servlets if you can things done in an easier way...

hth