applet, tomcat & postgresql ( java.net.SocketPermission) error from public
Hi,
Can anybody tell me how to solve this problem, i have tried to figure out for quite long time, but until now i stil can't solve it. The scenario is
Applet which is stored in tomcat that can let users to download and access postgresql database,
Application server : tomcat 5.0
DB : postgresql 8.1
I have created this applet and store it in tomcat, so that it can access classes, jar, jdbc driver for processing. Ok now, it's fine to work in private LAN, which i use 192.168.1.3 as the server(suse linux). I can download this applet from tomcat and it can insert, retrieve, delete & update from DB.
Ok now, the problem is :
Once i use public IP (60.51.XX.XX) to download this applet from public, the applet can be loaded, but when i tried to insert data, it showed me PSQLException (Caused by java.net.SocketPermission) error.
From what i got from forum, i have granted permission (java.security.AllPermission, permission java.net.SocketPermission) in tomcat (catalina.policy) and in postgresql site (pg_hba.conf) i have added host all all 192.168.1.0/24 trust.
Can anybody tell me what i have done wrong or i have missed out??? Very appreciate for your advices.
Regards,
marcalena