I have written a applet that reads and writes data from a database. I
initially wrote the application to connect to a MYSQL database and
everything ran fine. I then changed the className and connect strings
for oracle and tested it with 'all permissions' on. works fine.

I then packaged the oracle class files in with the signed java applet
and tested.
With 'all permissions' set in the Policy file it works fine. With this
removed I can still connect to the mysql database but the oracle
database is returning the error.

Error loading Driver: java.security.AccessControlException: access
denied (java.net.SocketPermission database server resolve)

I would have thought by signing the jar file I would have got around
this sort of error. What am I missing?

Here is an extract of code.

================================================================
classPath = "jar:"+String.valueOf(getCodeBase()+"Contacts/Contacts.jar!/");
if (sDBtype.indexOf("mysql")==0) {
       className = "com.mysql.jdbc.Driver";
   } else if (sDBtype.indexOf("oracle")==0) {
       className = "oracle.jdbc.driver.OracleDriver";
   } else if (sDBtype.indexOf("odbc")==0) {
       className = "sun.jdbc.odbc.JdbcOdbcDriver";
   } else {
       System.out.println ("Unknown database type "+sDBtype+". Please
use either mysql, oracle or odbc");
   }
   URL classURL = new URL(classPath);
   URLClassLoader loader = new URLClassLoader(new URL[] {classURL});
   Class c = Class.forName(className, true, loader);
   Class.forName(className, true, loader).newInstance();
   Driver drv = (Driver)c.newInstance ();
   DriverManager.registerDriver(new DriverShim(drv));
   timer("3");
} catch (Exception e) {
   System.out.println("Error loading Driver: "+e);
}
if (sDBtype.indexOf("mysql")==0) {
   db=new Database("jdbc:mysql://"+sDBhost+":"+sDBport+"/"+sDBdatabase,sDBusername,sDBpassword);
} else if (sDBtype.indexOf("oracle")==0) {
   db=new Database("jdbc:oracle:thin:@"+sDBhost+":"+sDBport+":"+sDBdatabase,sDBusername,sDBpassword);
} else if (sDBtype.indexOf("odbc")==0) {
   db=new Database("jdbc:odbc:"+sDBdatabase,sDBusername,sDBpassword);
}
========================================================