This week's giveaway is in the Programmer Certification (OCPJP) forum.
We're giving away four copies of Java Mock Exams (software) and have David Mayer on-line!
See this thread for details.
Win a copy of Java Mock Exams (software) this week in the Programmer Certification (OCPJP) forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

JDBC APPLETS

 
Bhaskar Selvaraju
Greenhorn
Posts: 29
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
I am making an online exam applet which will read questions from the database and will have a timer and all, something like the jcp exams. The problem is that browsers dont allow a JDBC ODBC connection because of the sandbox model. Please enlighten me as to how to overcome this problem. Any help will be much appreciated.
Thanx,
Bhaskar.
 
Tim Holloway
Bartender
Posts: 18469
61
Android Eclipse IDE Linux
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Solution 1. Set up security and sign the applet. Not recommended for general use because a lot of DBMS's use TCP/IP ports that get blocked by firewalls.
Solution 2. Use a 3-tier solution. Do all the JDBC stuff on the server and use a URLConnection to fetch/save data from the applet. Note that this has to be the same server that the applet was loaded from!
 
Happiness is not a goal ... it's a by-product of a life well lived - Eleanor Roosevelt. Tiny ad:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!