PRB: Cannot Use JDBC in Applets Outside of Visual J++'s IDE

• Microsoft Visual J++, versions 1.0, 1.1
• Microsoft SDK for Java, versions 2.0, 2.01, 2.02, 3.0, 3.1, 3.2

SYMPTOMS

When programming an Applet that uses JDBC, everything works in the development environment. When the Applet is run outside of the development environment, the Applet throws a com.ms.security.SecurityExceptionEx.

CAUSE

JDBC requires access to resources that are available only when outside the set of security restrictions placed on non-trusted Java Applets, also known as the "sandbox." Regular Applets cannot access files on the client's hard drive, access other network sockets, or print. JDBC requires file input/output. When trying to access a file on the client, the SecurityExceptionEx is thrown.

RESOLUTION

In order for the Applet to work properly, you will need to create a cabinet file and digitally sign it (see references for more information). Then you need to add certain method calls in the Applet to "assert permissions" (please see article reference below) for file input/output.

STATUS

This behavior is by design.

REFERENCES

For additional information on making your Java Code trusted in Microsoft Internet Explorer and other information, please see the following articles in the Microsoft Knowledge Base:

Q193877 HOWTO: Make Your Java Code Trusted in Internet Explorer

Q175622 PRB: SecurityExceptionEx Exception Running a Java Applet

http://support.microsoft.com/support/visualj/

http://support.microsoft.com/support/java/

Additional query words:

Keywords : kbSDKJava300 kbSDKJava310 JDB kbSDKJava320
Version : WINDOWS:1.0,1.1,2.0,2.01,2.02,3.0,3.1,3.2
Platform : WINDOWS
Issue type : kbprb