aspose file tools*
The moose likes Applets and the fly likes It is not true, Database does not shows through Applet Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Applets
Bookmark "It is not true, Database does not shows through Applet" Watch "It is not true, Database does not shows through Applet" New topic
Author

It is not true, Database does not shows through Applet

Maki Jav
Ranch Hand

Joined: May 09, 2002
Posts: 437
Hi,
People have been telling me that getting data from a database using applet was possible but only if both of them reside on the same computer but it is not true, Database does not shows through Applet. While a standalone with a similar code does work ...comment plz.


Help gets you when you need it!
Tim Holloway
Saloon Keeper

Joined: Jun 25, 2001
Posts: 16250
    
  21

If you're accessing the database using JDBC, the applet sandbox won't allow access even when the database is on the same server you loaded the applet from.
You can create a signed applet to enable the JDBC, but firewalls often block JDBC, so the preferred method is to do the JDBC on the server side and use HTTP tunneling to get the data out to the client.
Try doing a search in this forum. It's a common question.


Customer surveys are for companies who didn't pay proper attention to begin with.
Maki Jav
Ranch Hand

Joined: May 09, 2002
Posts: 437
Mr. Tim
Thanx for these valuable words. I am obliged.

Bye
Gregg Bolinger
GenRocket Founder
Ranch Hand

Joined: Jul 11, 2001
Posts: 15299
    
    6

I am running an unsigned jar file on an apache webserver with MySQL as the backend DB which is on the same server as Apache and I have no problems accessing the database through the applet on any PC.


GenRocket - Experts at Building Test Data
jack welsh
Greenhorn

Joined: Oct 26, 2002
Posts: 2
Hi Gregg,

Looks like you are using AppletViewer to run your applet. Try to run the same from the browser, I don't think you would be able to connect to the database. Coming to the idea of signing an applet to connect to the database, how easy is that task? Do you need to sign up with a certification authority?? what is required on the database end(residing on some other machine), are any policy files required on the server end???
I have a situation where, I want to embed my applet in my webpage which is on the intranet, and I would like to give the applet previleges to access the db. Can we give access previleges to the applet from the browser to access the db?? I don't want to use a signed applet since my applet is run inside the intranet... ! Any suggestions or help appreciated.
Thanks
Jack.
Maki Jav
Ranch Hand

Joined: May 09, 2002
Posts: 437
Why not use Http tunneling?
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: It is not true, Database does not shows through Applet