Database access for server and client  
Author Message
bartona@ohsu.edu





PostPosted: 2006-3-8 2:08:00 Top

java-programmer, Database access for server and client I am trying to create a small Internet application to access a mySQL
database on specific client machines around the country and query their
database and send the query result to our web server and then process
further data on the web server. Here is the layout: There are
several client machines around the country that have a mySQL database
installed and will give us certain query privileges for this database.
I need users on these client machines to be able to run an Internet
application from our web server which queries their local database and
then sends information to our server.

I see two options: a trusted, signed applet or a full java application
- also digitally signed - that is deployed through the Java Web Start
technology. (This is a very simple query on the client with a simple
drop-down list for the user to select from the query result - nothing
complicated.)

Does anybody have any suggestion as to which method is preferable? The
end users who will be running this application are not very computer
savvy and might not be able to figure out browser messages like "Your
browser understands the <APPLET> tag but isn't running the applet, for
some reason." For this reason I thought that the Java Web Start method
might be preferable, but I have no idea how reliable this method is and
what kind of kinks I will have to work through.

I also wonder if the Microsoft .net environment might offer an
alternative (our web server is Microsoft IIS and the clients are all
Windows XP or Windows 2000).

Any thoughts?

Thank you.
Anke

 
Mladen Adamovic





PostPosted: 2006-3-9 0:45:00 Top

java-programmer >> Database access for server and client email***@***.com wrote:
> Does anybody have any suggestion as to which method is preferable? The
> end users who will be running this application are not very computer
> savvy and might not be able to figure out browser messages like "Your
> browser understands the <APPLET> tag but isn't running the applet, for
> some reason." For this reason I thought that the Java Web Start method
> might be preferable, but I have no idea how reliable this method is and
> what kind of kinks I will have to work through.

I think you should avoid applets because of the problems you mentioned.
Compatibilty. You could use web start (it work OK on appropriate Java
version) OR https and server programming.

> I also wonder if the Microsoft .net environment might offer an
> alternative (our web server is Microsoft IIS and the clients are all
> Windows XP or Windows 2000).

There are C# alterantive for Java web start in VS 2005 but I cannot
remember the name. Google :
http://www.google.com/search?q=c%23+replacement+java+web+start&start=0&start=0&ie=utf-8&oe=utf-8&client=firefox-a&rls=org.mozilla:en-US:official



--
Mladen Adamovic
http://home.blic.net/adamm
http://www.shortopedia.com
http://www.froola.com
 
syed_danish22





PostPosted: 2006-3-11 3:40:00 Top

java-programmer >> Database access for server and client Aslam o alikum...
i thought you develop an software for client which connect to you
domain on internet and fullfill his requirment.. and i thought it is
more safe than applets

Thankyou