aspose file tools*
The moose likes Applets and the fly likes Updating Database Remotely through Applet Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Java » Applets
Bookmark "Updating Database Remotely through Applet" Watch "Updating Database Remotely through Applet" New topic
Author

Updating Database Remotely through Applet

Deepak Lohar
Greenhorn

Joined: Nov 13, 2002
Posts: 14
Hi Everybody,
I developed a applet which talks to MySql database.
I start the database server and call this applet with the help of a browser, it runs fine and i am able to retreive and access data and also insert data
into to the Database server from this applet on my local machine.
But the same applet when i call with the help of a browser from a different machine, it loads just the Graphical User Interface , but when i wish to retreive or insert data into the MySql database through this applet, it doesnt allow me to do so.
I would be glad for your help and suggestion on this as to how to go about achieving this task.
NOTE:
1. I am loading the driver in my java code as:
private StringdriverClassLocation = "org.gjt.mm.mysql.Driver";
private StringdataSourceName = "jdbc:mysql:///test";
2. I am testing on Netscape 7.02 and Internet Explorer5.5+ browsers
Both are working fine when accessing locally but not when i am on remote machine.
Is ther any special settings to be done as regard browsers?
Is the policy file need to be changed?
Is the database driver to be loaded with IP address?
any help in this regard will be a great help for me.
cheers
Deepak


DL
Maulin Vasavada
Ranch Hand

Joined: Nov 04, 2001
Posts: 1871
hi deepak
along w/ the applet jar files u have to make sure that it would find the jdbc driver as the client machine needs to have the driver loaded in the browser JRE.
but apart from that please read
this
thread to see views about using database via an applet...
regards
maulin
 
jQuery in Action, 2nd edition
 
subject: Updating Database Remotely through Applet
 
Similar Threads
Possible to call PHP webpage from Applet?
Accessing a database without using signing or policy file
Problem Connecting to MySQL Database
JDBC in applets
How to put JDBC driver in applet jar?