pbm with applets and database

David HOAREAU (dhoareau@alta-informatique.fr)
Tue, 22 Dec 1998 21:15:16 +0100

This is a multi-part message in MIME format.

------=_NextPart_000_0004_01BE2DF0.2BAB2530
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hello to all,

I have great troubles with running an applet that uses Database files.

I used the java.sql.Connection and Statements to access my DB(an =
MSAccess one).When i ran the applet with the Sun's & Jbuilder's =
appletViewer,there was absolutely no problems but as soon as i tried to =
deploy my applet and browse it with IE4.0 , the java console warned me =
that:

com.ms.security.SecurityExceptionEx[sun/jdbc/odbc/JdbcOdbcDriver.trusted]=
: cannot access file JdbcOdbcSecurityCheck
at com/ms/security/permissions/FileIOPermission.check =
(FileIOPermission.java)
at com/ms/security/PolicyEngine.deepCheck (PolicyEngine.java)
at com/ms/security/PolicyEngine.checkPermission (PolicyEngine.java)
at com/ms/security/StandardSecurityManager.chk =
(StandardSecurityManager.java)
at com/ms/security/StandardSecurityManager.checkWrite =
(StandardSecurityManager.java)
at sun/jdbc/odbc/JdbcOdbcDriver.trusted (JdbcOdbcDriver.java:502)
at sun/jdbc/odbc/JdbcOdbcDriver.acceptsURL (JdbcOdbcDriver.java:201)
at sun/jdbc/odbc/JdbcOdbcDriver.connect (JdbcOdbcDriver.java:143)
at java/sql/DriverManager.getConnection (DriverManager.java)
at java/sql/DriverManager.getConnection (DriverManager.java)
at elisa/temporaire/MoteurTempo2.jbInit (MoteurTempo2.java:128)
at elisa/temporaire/MoteurTempo2.<init> (MoteurTempo2.java:95)
at elisa/temporaire/Tempo.<init> (Tempo.java:43)
at com/ms/applet/BrowserAppletFrame.newInstance =
(BrowserAppletFrame.java)
at com/ms/applet/AppletPanel.processSentEvent (AppletPanel.java)
at com/ms/applet/AppletPanel.processSentEvent (AppletPanel.java)
at com/ms/applet/AppletPanel.run (AppletPanel.java)
at java/lang/Thread.run (Thread.java)
com.ms.security.SecurityExceptionEx[sun/jdbc/odbc/JdbcOdbc.<init>]
at com/ms/security/PolicyEngine.shallowCheck (PolicyEngine.java)
at com/ms/security/PolicyEngine.checkCallersPermission =
(PolicyEngine.java)
at com/ms/security/StandardSecurityManager.chk =
(StandardSecurityManager.java)
at com/ms/security/StandardSecurityManager.checkLink =
(StandardSecurityManager.java)
at java/lang/Runtime.loadLibrary (Runtime.java)
at java/lang/System.loadLibrary (System.java)
at sun/jdbc/odbc/JdbcOdbc.<init> (JdbcOdbc.java:63)
at sun/jdbc/odbc/JdbcOdbcDriver.initialize (JdbcOdbcDriver.java:321)
at sun/jdbc/odbc/JdbcOdbcDriver.connect (JdbcOdbcDriver.java:159)
at java/sql/DriverManager.getConnection (DriverManager.java)
at java/sql/DriverManager.getConnection (DriverManager.java)
at elisa/temporaire/MoteurTempo2.jbInit (MoteurTempo2.java:128)
at elisa/temporaire/MoteurTempo2.<init> (MoteurTempo2.java:95)
at elisa/temporaire/Tempo.<init> (Tempo.java:43)
at com/ms/applet/BrowserAppletFrame.newInstance =
(BrowserAppletFrame.java)
at com/ms/applet/AppletPanel.processSentEvent (AppletPanel.java)
at com/ms/applet/AppletPanel.processSentEvent (AppletPanel.java)
at com/ms/applet/AppletPanel.run (AppletPanel.java)
at java/lang/Thread.run (Thread.java)
com.ms.security.SecurityExceptionEx[sun/jdbc/odbc/JdbcOdbcDriver.trusted]=
: cannot access file JdbcOdbcSecurityCheck
at com/ms/security/permissions/FileIOPermission.check =
(FileIOPermission.java)
at com/ms/security/PolicyEngine.deepCheck (PolicyEngine.java)
at com/ms/security/PolicyEngine.checkPermission (PolicyEngine.java)
at com/ms/security/StandardSecurityManager.chk =
(StandardSecurityManager.java)
at com/ms/security/StandardSecurityManager.checkWrite =
(StandardSecurityManager.java)
at sun/jdbc/odbc/JdbcOdbcDriver.trusted (JdbcOdbcDriver.java:502)
at sun/jdbc/odbc/JdbcOdbcDriver.acceptsURL (JdbcOdbcDriver.java:201)
at sun/jdbc/odbc/JdbcOdbcDriver.connect (JdbcOdbcDriver.java:143)
at java/sql/DriverManager.getConnection (DriverManager.java)
at java/sql/DriverManager.getConnection (DriverManager.java)
at elisa/temporaire/MoteurTempo2.jbInit (MoteurTempo2.java:128)
at elisa/temporaire/MoteurTempo2.<init> (MoteurTempo2.java:95)
at elisa/temporaire/Tempo.<init> (Tempo.java:43)
at com/ms/applet/BrowserAppletFrame.newInstance =
(BrowserAppletFrame.java)
at com/ms/applet/AppletPanel.processSentEvent (AppletPanel.java)
at com/ms/applet/AppletPanel.processSentEvent (AppletPanel.java)
at com/ms/applet/AppletPanel.run (AppletPanel.java)
at java/lang/Thread.run (Thread.java)
com.ms.security.SecurityExceptionEx[sun/jdbc/odbc/JdbcOdbc.<init>]
at com/ms/security/PolicyEngine.shallowCheck (PolicyEngine.java)
at com/ms/security/PolicyEngine.checkCallersPermission =
(PolicyEngine.java)
at com/ms/security/StandardSecurityManager.chk =
(StandardSecurityManager.java)
at com/ms/security/StandardSecurityManager.checkLink =
(StandardSecurityManager.java)
at java/lang/Runtime.loadLibrary (Runtime.java)
at java/lang/System.loadLibrary (System.java)
at sun/jdbc/odbc/JdbcOdbc.<init> (JdbcOdbc.java:63)
at sun/jdbc/odbc/JdbcOdbcDriver.initialize (JdbcOdbcDriver.java:321)
at sun/jdbc/odbc/JdbcOdbcDriver.connect (JdbcOdbcDriver.java:159)
at java/sql/DriverManager.getConnection (DriverManager.java)
at java/sql/DriverManager.getConnection (DriverManager.java)
at elisa/temporaire/MoteurTempo2.jbInit (MoteurTempo2.java:128)
at elisa/temporaire/MoteurTempo2.<init> (MoteurTempo2.java:95)
at elisa/temporaire/Tempo.<init> (Tempo.java:43)
at com/ms/applet/BrowserAppletFrame.newInstance =
(BrowserAppletFrame.java)
at com/ms/applet/AppletPanel.processSentEvent (AppletPanel.java)
at com/ms/applet/AppletPanel.processSentEvent (AppletPanel.java)
at com/ms/applet/AppletPanel.run (AppletPanel.java)
at java/lang/Thread.run (Thread.java)
java.sql.SQLException: No suitable driver
at java/sql/DriverManager.getConnection (DriverManager.java)
at java/sql/DriverManager.getConnection (DriverManager.java)
at elisa/temporaire/MoteurTempo2.jbInit (MoteurTempo2.java:128)
at elisa/temporaire/MoteurTempo2.<init> (MoteurTempo2.java:95)
at elisa/temporaire/Tempo.<init> (Tempo.java:43)
at com/ms/applet/BrowserAppletFrame.newInstance =
(BrowserAppletFrame.java)
at com/ms/applet/AppletPanel.processSentEvent (AppletPanel.java)
at com/ms/applet/AppletPanel.processSentEvent (AppletPanel.java)
at com/ms/applet/AppletPanel.run (AppletPanel.java)
at java/lang/Thread.run (Thread.java)

I don't know what kind of #M@!#Soft classes is playing with my nerves =
but i tried all=20
the ideas i had :

to deploy the DB in a Jar file with the applet.
to change the IE4's parameters
to import the com.ms.security classes to grant a FileIO authorisation =
and CLIENTSTORE one too.But i even didn't manage to change the error =
message.

Please help.I said all my friends and people i work with that nothing =
was imposssible even not difficult using java , i know i was right.Just =
let me show 'em that in the worst cases someone can help you quickly.

Thanks in advance.
(Don't say me to change my tools,i'm compulsory to use'em.....)

------=_NextPart_000_0004_01BE2DF0.2BAB2530
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">

Hello to all,
 
I have great troubles with running = an =20 applet that uses Database files.
 
I used the java.sql.Connection and = Statements to=20 access my DB(an MSAccess one).When i ran the applet with the Sun's & = Jbuilder's appletViewer,there was absolutely no problems but as soon as = i tried=20 to deploy my applet and browse it with IE4.0 , the java console warned = me=20 that:
 
com.ms.security.SecurityExceptionEx[sun/jdbc/odbc/JdbcOdbcDriver= .trusted]:=20 cannot access file JdbcOdbcSecurityCheck
 at=20 com/ms/security/permissions/FileIOPermission.check=20 (FileIOPermission.java)
 at = com/ms/security/PolicyEngine.deepCheck=20 (PolicyEngine.java)
 at = com/ms/security/PolicyEngine.checkPermission=20 (PolicyEngine.java)
 at = com/ms/security/StandardSecurityManager.chk=20 (StandardSecurityManager.java)
 at=20 com/ms/security/StandardSecurityManager.checkWrite=20 (StandardSecurityManager.java)
 at = sun/jdbc/odbc/JdbcOdbcDriver.trusted=20 (JdbcOdbcDriver.java:502)
 at = sun/jdbc/odbc/JdbcOdbcDriver.acceptsURL=20 (JdbcOdbcDriver.java:201)
 at = sun/jdbc/odbc/JdbcOdbcDriver.connect=20 (JdbcOdbcDriver.java:143)
 at = java/sql/DriverManager.getConnection=20 (DriverManager.java)
 at java/sql/DriverManager.getConnection=20 (DriverManager.java)
 at elisa/temporaire/MoteurTempo2.jbInit=20 (MoteurTempo2.java:128)
 at = elisa/temporaire/MoteurTempo2.<init>=20 (MoteurTempo2.java:95)
 at elisa/temporaire/Tempo.<init>=20 (Tempo.java:43)
 at com/ms/applet/BrowserAppletFrame.newInstance = (BrowserAppletFrame.java)
 at = com/ms/applet/AppletPanel.processSentEvent=20 (AppletPanel.java)
 at = com/ms/applet/AppletPanel.processSentEvent=20 (AppletPanel.java)
 at com/ms/applet/AppletPanel.run=20 (AppletPanel.java)
 at java/lang/Thread.run=20 (Thread.java)
com.ms.security.SecurityExceptionEx[sun/jdbc/odbc/JdbcOd= bc.<init>]
 at=20 com/ms/security/PolicyEngine.shallowCheck = (PolicyEngine.java)
 at=20 com/ms/security/PolicyEngine.checkCallersPermission=20 (PolicyEngine.java)
 at = com/ms/security/StandardSecurityManager.chk=20 (StandardSecurityManager.java)
 at=20 com/ms/security/StandardSecurityManager.checkLink=20 (StandardSecurityManager.java)
 at java/lang/Runtime.loadLibrary = (Runtime.java)
 at java/lang/System.loadLibrary=20 (System.java)
 at sun/jdbc/odbc/JdbcOdbc.<init>=20 (JdbcOdbc.java:63)
 at sun/jdbc/odbc/JdbcOdbcDriver.initialize=20 (JdbcOdbcDriver.java:321)
 at = sun/jdbc/odbc/JdbcOdbcDriver.connect=20 (JdbcOdbcDriver.java:159)
 at = java/sql/DriverManager.getConnection=20 (DriverManager.java)
 at java/sql/DriverManager.getConnection=20 (DriverManager.java)
 at elisa/temporaire/MoteurTempo2.jbInit=20 (MoteurTempo2.java:128)
 at = elisa/temporaire/MoteurTempo2.<init>=20 (MoteurTempo2.java:95)
 at elisa/temporaire/Tempo.<init>=20 (Tempo.java:43)
 at com/ms/applet/BrowserAppletFrame.newInstance = (BrowserAppletFrame.java)
 at = com/ms/applet/AppletPanel.processSentEvent=20 (AppletPanel.java)
 at = com/ms/applet/AppletPanel.processSentEvent=20 (AppletPanel.java)
 at com/ms/applet/AppletPanel.run=20 (AppletPanel.java)
 at java/lang/Thread.run=20 (Thread.java)
com.ms.security.SecurityExceptionEx[sun/jdbc/odbc/JdbcOd= bcDriver.trusted]:=20 cannot access file JdbcOdbcSecurityCheck
 at=20 com/ms/security/permissions/FileIOPermission.check=20 (FileIOPermission.java)
 at = com/ms/security/PolicyEngine.deepCheck=20 (PolicyEngine.java)
 at = com/ms/security/PolicyEngine.checkPermission=20 (PolicyEngine.java)
 at = com/ms/security/StandardSecurityManager.chk=20 (StandardSecurityManager.java)
 at=20 com/ms/security/StandardSecurityManager.checkWrite=20 (StandardSecurityManager.java)
 at = sun/jdbc/odbc/JdbcOdbcDriver.trusted=20 (JdbcOdbcDriver.java:502)
 at = sun/jdbc/odbc/JdbcOdbcDriver.acceptsURL=20 (JdbcOdbcDriver.java:201)
 at = sun/jdbc/odbc/JdbcOdbcDriver.connect=20 (JdbcOdbcDriver.java:143)
 at = java/sql/DriverManager.getConnection=20 (DriverManager.java)
 at java/sql/DriverManager.getConnection=20 (DriverManager.java)
 at elisa/temporaire/MoteurTempo2.jbInit=20 (MoteurTempo2.java:128)
 at = elisa/temporaire/MoteurTempo2.<init>=20 (MoteurTempo2.java:95)
 at elisa/temporaire/Tempo.<init>=20 (Tempo.java:43)
 at com/ms/applet/BrowserAppletFrame.newInstance = (BrowserAppletFrame.java)
 at = com/ms/applet/AppletPanel.processSentEvent=20 (AppletPanel.java)
 at = com/ms/applet/AppletPanel.processSentEvent=20 (AppletPanel.java)
 at com/ms/applet/AppletPanel.run=20 (AppletPanel.java)
 at java/lang/Thread.run=20 (Thread.java)
com.ms.security.SecurityExceptionEx[sun/jdbc/odbc/JdbcOd= bc.<init>]
 at=20 com/ms/security/PolicyEngine.shallowCheck = (PolicyEngine.java)
 at=20 com/ms/security/PolicyEngine.checkCallersPermission=20 (PolicyEngine.java)
 at = com/ms/security/StandardSecurityManager.chk=20 (StandardSecurityManager.java)
 at=20 com/ms/security/StandardSecurityManager.checkLink=20 (StandardSecurityManager.java)
 at java/lang/Runtime.loadLibrary = (Runtime.java)
 at java/lang/System.loadLibrary=20 (System.java)
 at sun/jdbc/odbc/JdbcOdbc.<init>=20 (JdbcOdbc.java:63)
 at sun/jdbc/odbc/JdbcOdbcDriver.initialize=20 (JdbcOdbcDriver.java:321)
 at = sun/jdbc/odbc/JdbcOdbcDriver.connect=20 (JdbcOdbcDriver.java:159)
 at = java/sql/DriverManager.getConnection=20 (DriverManager.java)
 at java/sql/DriverManager.getConnection=20 (DriverManager.java)
 at elisa/temporaire/MoteurTempo2.jbInit=20 (MoteurTempo2.java:128)
 at = elisa/temporaire/MoteurTempo2.<init>=20 (MoteurTempo2.java:95)
 at elisa/temporaire/Tempo.<init>=20 (Tempo.java:43)
 at com/ms/applet/BrowserAppletFrame.newInstance = (BrowserAppletFrame.java)
 at = com/ms/applet/AppletPanel.processSentEvent=20 (AppletPanel.java)
 at = com/ms/applet/AppletPanel.processSentEvent=20 (AppletPanel.java)
 at com/ms/applet/AppletPanel.run=20 (AppletPanel.java)
 at java/lang/Thread.run=20 (Thread.java)
java.sql.SQLException: No suitable driver
 at=20 java/sql/DriverManager.getConnection (DriverManager.java)
 at=20 java/sql/DriverManager.getConnection (DriverManager.java)
 at=20 elisa/temporaire/MoteurTempo2.jbInit (MoteurTempo2.java:128)
 at = elisa/temporaire/MoteurTempo2.<init> = (MoteurTempo2.java:95)
 at=20 elisa/temporaire/Tempo.<init> (Tempo.java:43)
 at=20 com/ms/applet/BrowserAppletFrame.newInstance=20 (BrowserAppletFrame.java)
 at = com/ms/applet/AppletPanel.processSentEvent=20 (AppletPanel.java)
 at = com/ms/applet/AppletPanel.processSentEvent=20 (AppletPanel.java)
 at com/ms/applet/AppletPanel.run=20 (AppletPanel.java)
 at java/lang/Thread.run=20 (Thread.java)
I don't know what kind of #M@!#Soft = classes is=20 playing with my nerves but i tried all
the ideas i had :
 
to deploy the DB in a Jar file with = the=20 applet.
to change the IE4's = parameters
to import the com.ms.security = classes to grant a=20 FileIO authorisation and CLIENTSTORE one too.But i even didn't manage to = change=20 the error message.
 
Please help.I said all my friends and people i work = with that=20 nothing was imposssible even not difficult using java , i know i was = right.Just=20 let me show 'em that in the worst cases someone can help you=20 quickly.
 
Thanks in advance.
(Don't say me to change my tools,i'm compulsory to=20 use'em.....)
 
------=_NextPart_000_0004_01BE2DF0.2BAB2530--