CODEWITHSUNDEEP
javasqldatabase
Martin Berger
Martin Berger

Reputation: 1708

Java desktop app plus database plus internet

i have to write small java database application with several tables. With that i have some experience and can do it. That would be on one machine.

From somewhere on net, from other machine it should have to be possible to connect and inspect some database queries in SWING GUI. That network part is with what i do not have experience. What would be best way to accomplish that task? I need some general directions here and maybe some good links with examples to study. Problem is i am kinda short with time here.

From my browsing i saw the most easiest solution is to connect direcly from distant machine directly with JDBC with ip:port way. Like 111.111.111.111:55 But that leaves DB really unsecure.

I've read about sockets, but i dont see how that helps.

Now, i've seen people mention Hibernate and VPN but i thinks that is lot of work. And others mention web servers, but i have absoulutely no idea how that works.

So, what is optimal solution in your oppinion? Ideas, suggestions, guidelines?

Thanks in advance, Martin.

Upvotes: 2

Views: 843

Answers (4)

Enrique
Enrique

Reputation: 10117

You have several options.

  • RMI this allows an object running in one Java virtual machine to invoke methods on an object running in another Java virtual machine.
  • CORBA Common Object Request Broker Architecture, is a standard architecture for distributed object systems. It allows a distributed, heterogeneous collection of objects to interoperate.
  • Sockets
  • HTTP server. You can use Servlets or some framework like Struts, Spring etc. for the server side and just call the servlet from your client using Apache HttpClient

Since you don't have much time I'd discard RMI and CORBA and focus on Sockets or the http server solution.

Since you wrote that you dont have experience with web applications I'd go with sockets.

With java you can create a server and client very easy using sockets here is a basic example and Here is a very good tutorial that uses Swing.

Upvotes: 1

John Gardner
John Gardner

Reputation: 25116

You probably want to write a Web service to expose your data instead of letting a user connect directly to the DB over the internet. Ideally that web service is on a physically seperate machine from the database, so that the database is not exposed to internet directly.

Person <--> internet <--> Web Service <--> database

It really depends on what you consider optimal.

Do you have zero concern for security?

if you're exposing a database directly onto the internet, you're going to have to open up ports on firewall/etc and secure your database, and pray you have no other insecure services exposed to the internet.

Upvotes: 1

jzd
jzd

Reputation: 23629

Some level of security will be provided by using a database login and password. If you are short on time then web services, or sockets aren't going to be quick to pick up. Unless you really need the security just use JDBC for now.

Upvotes: 2

Powerlord
Powerlord

Reputation: 88796

JDBC drivers may have different arguments for their data source depending on if you use encryption for the connection.

For instance, MySQL allows you to use an SSL connection, and even has a section in its manual for it. Other databases may vary.

Presumably, your application will also have its own username and password to be sent to the remote DB server.

Upvotes: 2

Related Questions