I responded to MJS directly, since in the past, I have
been scolded by the content police for replying
publicly to posts unrelated DIRECTLY to the forum
subject.....
In a nutshell:
1. I believe that you can make applets run the
JDBC-ODBC bridge by altyering the security profile of
the applet. I cannot ellaborate (since I don't really
know much more) but either signing the applet and/or
modifying the security policy file of the browser
should allow this. I should add that you will also
have to configure the clients ODBC DSN. Furthermore,
when using a database like Access, you will also need
a directory mapping to the database file, since
client/server style connections are not supported. In
conclusion, the applet architecture itself is not
always the only or most severe limiting factor.
<End of JDBC-ODBC usage>
2. As you said, use a n-tier architecture (where n>2)
and remove all JDBC calls from the applet.
Alternatively, use a type 3 JDBC driver ( which, when
you think about it, could be the same thing ).
3. Use a type 4 100% Java JDBC driver ( again, Access
is disqualified, as far as I know )
//Nicholas
--- Kevin Sagon <[EMAIL PROTECTED]> wrote:
> 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
>
=====
"And what causes me to run?
'Cause you're a...
Big Black Furry Creature From Mars"
--
Nicholas Whitehead
__________________________________________________
Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger.
http://messenger.yahoo.com
___________________________________________________________________________
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
