Applet Connection ->SQL SERVER 2000 Problem
Dear All,
i developed an applet that should be used in a intranet envronment.
The applet is loaded from a Windows Server 2003 on which also runs an SQL Server DBMS.
The applet consists in 2 parts: the first one performs inserts,updates
and the second is used to view inserted data ( select statements).
Everything is done via Stored procedures (but this is irrelevant for my question).
As you can imagine i get a
"access denied java.net.SocketPermission " .
Question:
1) I imagine that by using a policy file i can override this problem.
Should this policy file exist in every single user's local home dir?
Is there a way to include the policy file in a more transparent way?
2)What about digital signatures?Could help me?
Thanks in advance,
Chris
[840 byte] By [
Electrica] at [2007-11-27 2:17:32]
# 1
>1) I imagine that by using a policy file i can override this problem.
>Should this policy file exist in every single user's local home dir?
Unfortunately, the answer is yes.
>Is there a way to include the policy file in a more transparent way?
>2)What about digital signatures?Could help me?
http://java.sun.com/docs/books/tutorial/deployment/applet/problemsindex.html
http://java.sun.com/docs/books/tutorial/deployment/applet/security_practical.html
http://java.sun.com/sfaq/
Why you don't use a web application (JSP/Servlet) using tomcat for example ?
If you have only one database server, I recommend to develop a simple web application instead.
# 2
> >1) I imagine that by using a policy file i can
> override this problem.
> >Should this policy file exist in every single user's
> local home dir?
>
> Unfortunately, the answer is yes.
>
> >Is there a way to include the policy file in a more
> transparent way?
> >2)What about digital signatures?Could help me?
>
> http://java.sun.com/docs/books/tutorial/deployment/app
> let/problemsindex.html
> http://java.sun.com/docs/books/tutorial/deployment/app
> let/security_practical.html
> http://java.sun.com/sfaq/
>
> Why you don't use a web application (JSP/Servlet)
> using tomcat for example ?
> If you have only one database server, I recommend to
> develop a simple web application instead.
It's strange though,because my applet lies on
10.30.1.38/fpm
and the connection attempted via microsoft's sql driver refers to the same ip address (the SQL server lies on 10.30.1.38 and listens on port 1433).
I thought that applets can communicate with the originating host.
Are you sure that i cant do anything?
