# Read from MS Access DB in JDK 1.1.2 applet

steven.j.blumfield (steven.j.blumfield@ac.com)
27 Jun 97 0:02:40

- Messages sorted by: [ date ][ thread ][ subject ][ author ]
- Next message: Mr Cheng Kwok Wai: "About JCE-1.1"
- Previous message: u4670031: "signed Applet can call netive method ??"
- Next in thread: Marianne Mueller: "Re: Read from MS Access DB in JDK 1.1.2 applet"

    Message-Id: <9706270503.AA1201@notes2.compuserve.com>

    To: java-security <java-security@web2.javasoft.com>

    From: "steven.j.blumfield" <steven.j.blumfield@ac.com>

    Date: 27 Jun 97  0:02:40

    Subject: Read from MS Access DB in JDK 1.1.2 applet

I have developed a java app that attempts to load a MS Access DB driver and
connect to an MS Access DB on my (local) PC. The app code is as follows:
// load the jdbc-odbc driver
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
println("Connecting to jdbc:odbc:" + DSN+","+UID+","+ PWD);
// make the DB connection
dbConnection = DriverManager.getConnection("jdbc:odbc:" + DSN, UID,
PWD);
// prepare the stocks statement for later use (SQLForm invocation)
stocksStmt = dbConnection.prepareStatement
("Select * from Quotes Where Symbol LIKE ?");

Although precisely the same code executed successully from within a
standalone application (frame); execution of the above (within applet
called "TestApp" from html of same name) by means of command "AppletViewer
TestApp.html" (from DOS prompt) generated the following:

BusinessObject:Failed:sun.applet.AppletSecurityException:
checkpackageaccess

I did check details re: applet security and added "acl.read=/home/me" to
".hotjava\properties" file where db is located in c:\home\me. This did not
seem to help. Please pass comment on what I am missing here.

Thanks and regards,
SB

- Next message: Mr Cheng Kwok Wai: "About JCE-1.1"
- Previous message: u4670031: "signed Applet can call netive method ??"
- Next in thread: Marianne Mueller: "Re: Read from MS Access DB in JDK 1.1.2 applet"