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
