WebRowSet and Applets

[Mark Muggins]

I am not sure if this should be posted here or in the jdbc group. I am battling to get the sun.jdbc.rowset.WebRowSet object working in an applet and reading an xml file form the web server to populate the webrowset. I keep getting permission errors even if I sign the applet! In theory I should not be getting these errors even without signing.
Error:
java.security.AccessControlException: access denied (java.lang.RuntimePermission accessClassInPackage.sun.jdbc.rowset) at java.security.AccessControlContext.checkPermission(AccessControlContext.java:270)
I know what I am trying to do is precisely what webrowset are intended for see
SUN presentation:
Sun Presentation
Although there is a lot of talk about how this is supposed to work there is a distinct lack of good examples. What is strange is that the ea to rowset has been around since 2001 but very little seems to be written about it. Maybe its just bad technology although it sound very appealing to me!

[Tim Holloway]

Here's how to tell if you are having an applet problem or a JDBC problem. Try running the applet with Sun's AppletViewer. If everything works in the AppletViewer, you're violating Applet sandbox rules and you have an applet problem. If it doesn't work and you're still getting a security exception, then it's a JDBC-related problem.
Don't forget that in addition to permitting JDBC access, you'll also have to give explicit permission to the applet if you are going to be reading the XML from a server other than the one that you downloaded the applet from.