JavaFX Client Server Application

[yan paing]

Dear All,
I need to develop java client server application. I choose Javafx for client and oracle database for database server. My requirement is the application will access multiple users (20-30) will access same time. If my client application directly access to database server, is there any impact ? Should i use web service or some other tools between client and database server? If so what is the best approach for java multiple client application. Please advise. Thanks in advance.

[Dave Tolls]

Cross posted to Java forums.

[Tim Moores]

30 clients is a small number, assuming they don't kick off long-running queries. But I'm guessing they're not, since GUI apps are generally expected to be responsive.

It's not generally good practice to have clients access DBs directly, though, for security reasons. It might be OK if all access occurs within a tightly controlled company network, but if you envision access across the public Internet, then you should use HTTPS through a proxy instead.

[yan paing]

Tim Moores wrote:30 clients is a small number, assuming they don't kick off long-running queries. But I'm guessing they're not, since GUI apps are generally expected to be responsive.

It's not generally good practice to have clients access DBs directly, though, for security reasons. It might be OK if all access occurs within a tightly controlled company network, but if you envision access across the public Internet, then you should use HTTPS through a proxy instead.

Thank you for advise. Yes there won't be long running queries. And we will use within company network. It is for internal application only.