This is solved by simply using RMI. Run a JVM and your data access component
on your remote database and have the applet access this DAC. Done.
John D. McDonald
CipherStream Systems
Phone: 925.373.8700
Fax: 413.793.6603
email: [EMAIL PROTECTED]
web: www.cipherstream.com
-------------------------------------------------------
Secure E-Business Is Our Business
-------------------------------------------------------
----- Original Message -----
From: Kevin Sagon <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, January 04, 2000 7:18 AM
Subject: Re: JDBC ANYONE ????
> I ran into this problem when I first started writing apps that would
> update data in a remote database. The answer I found is that you cannot
> use the JDBC-ODBC Bridge to update a remote database from an applet. The
> reason lies in Java's security mechanism. Java's security rules state
> that JDBC can be used in applets but only if they are purely Java. The
> JDBC-ODBC bridge uses a combination of Java and native code (C I believe)
> so the rules are violated and the Connections fail.
>
> However, since this is a servlet forum then I would suggest that you
> implement your JDBC code in a servlet. Servelts run locally on the server
> and so are not subject to the same security restrictions as applets. So
> to sum up..
>
> JDBC-ODBC in applets = No
> JDBC-ODBC in servlets = Yes
>
> If anyone has any other suggestions or can shed more light on the subject
> please respond as I would be interested in finding out how JDBC-ODBC could
> be used in an applet.
>
> On Sat, 4 Jan 1997, MJS MJS wrote:
>
> > Hi,
> > I am relatively new in this field.
> > I have written out some code which is supposed to insert a row in
MSAcess but there seems to b some error in the composition of the stmt.I
have tried using static pre deifned hard coded values and it works ok.Can
anyone tell me what error I am making?
> > ---------------------------JAVA CODE----------------
> > For query 1
> > String qq="INSERT INTO abc "+"VALUES('"+te1+"','" +te2+"');";
> > s1.executeUpdate(qq);
> >
> >
> > Is there any simple way to use applets with the JDBC-ODBC Bridge
Driver?
> >
> > With best wishes for the new year,
> > MJS
> >
>
>
___________________________________________________________________________
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the
body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources: http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
>
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
