For an applet, you might also want to try having the database on your host
machine, and that the database URL is the same as the host machine.
An applet can only access to where it is hosted.
Of course, this puts a huge load on your host machine having to run the
webserver as well as the database.
Good Luck,
Mick
-----Original Message-----
From: Kevin Sagon [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, January 04, 2000 9:19 AM
To: [EMAIL PROTECTED]
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
