Hi, I have a very fundamental question. Can I connect to a database on the client through (trusted) applets? How do I go about it? Also, is there any other method of doing that other than using applets? Please give me an overview of such a method. -Deb
Yes you can, but it's a royal pain. Most jdbc drivers use a tcp/ip channel to the database server such as SQL Server's 1433 or PostgreSQL's port 5432. Thus, in addition to having to sign the applet (painful enough), you also have to be sure that there will be no firewalls choking off the stream. Usually it's just easier to do an n-tier solution and use http tunnelling between the applet and a servlet or JSP which does the actual database work.
Customer surveys are for companies who didn't pay proper attention to begin with.
Debbie Argulkar
Ranch Hand
Joined: Jul 26, 2002
Posts: 43
posted
0
Hi Tim, Can you please explain that in a little more detail to me? Do you perchance have any sample code or any relevant links to help me understand better? Thanks for your prompt response. -Deb