JApplet to access Database on server from client maschine

[Rituraj Jain]

I have made a code in JApplet and trying to run that from Tomcat server by embedding that applet code in JSP. Coderuns fine untill unless i dont use any database access in it

but now i am trying to access Data base which is on server machine the applet code is not working

i know that i need to sign the applet to give it permissions of accessing database but how to sign it (give permission) thats what i don't know.

if i have to run the code through appletviewer then i can sign it with policy tool of java, but i case of server what to do i dont know???

please help!!!

following is error trace on the applet console.

  
java.security.PrivilegedActionException: java.net.ConnectException: Connection refused: connect
	at java.security.AccessController.doPrivileged(Native Method)
	at com.sun.deploy.net.CrossDomainXML.check(Unknown Source)
	at com.sun.deploy.net.CrossDomainXML.check(Unknown Source)
	at sun.plugin2.applet.Applet2SecurityManager.checkConnect(Unknown Source)
	at com.microsoft.sqlserver.jdbc.SQLServerConnectionSecurityManager.checkConnect(SQLServerConnection.java:3147)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:646)
	at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:842)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at ButtonMoveApplet.init(ButtonMoveApplet.java:17)
	at sun.plugin2.applet.Plugin2Manager$AppletExecutionRunnable.run(Unknown Source)
	at java.lang.Thread.run(Unknown Source)
Caused by: java.net.ConnectException: Connection refused: connect
	at java.net.PlainSocketImpl.socketConnect(Native Method)
	at java.net.PlainSocketImpl.doConnect(Unknown Source)
	at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
	at java.net.PlainSocketImpl.connect(Unknown Source)
	at java.net.SocksSocketImpl.connect(Unknown Source)
	at java.net.Socket.connect(Unknown Source)
	at sun.net.NetworkClient.doConnect(Unknown Source)
	at sun.net.www.http.HttpClient.openServer(Unknown Source)
	at sun.net.www.http.HttpClient.openServer(Unknown Source)
	at sun.net.www.http.HttpClient.<init>(Unknown Source)
	at sun.net.www.http.HttpClient.New(Unknown Source)
	at sun.net.www.http.HttpClient.New(Unknown Source)
	at sun.net.www.protocol.http.HttpURLConnection.getNewHttpClient(Unknown Source)
	at sun.net.www.protocol.http.HttpURLConnection.plainConnect(Unknown Source)
	at sun.net.www.protocol.http.HttpURLConnection.connect(Unknown Source)
	at com.sun.deploy.net.CrossDomainXML$2.run(Unknown Source)
	... 12 more
java.security.AccessControlException: access denied (java.net.SocketPermission 172.16.101.18:1433 connect,resolve)
	at java.security.AccessControlContext.checkPermission(Unknown Source)
	at java.security.AccessController.checkPermission(Unknown Source)
	at java.lang.SecurityManager.checkPermission(Unknown Source)
	at java.lang.SecurityManager.checkConnect(Unknown Source)
	at sun.plugin2.applet.Applet2SecurityManager.checkConnect(Unknown Source)
	at com.microsoft.sqlserver.jdbc.SQLServerConnectionSecurityManager.checkConnect(SQLServerConnection.java:3147)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:646)
	at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:842)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at ButtonMoveApplet.init(ButtonMoveApplet.java:17)
	at sun.plugin2.applet.Plugin2Manager$AppletExecutionRunnable.run(Unknown Source)
	at java.lang.Thread.run(Unknown Source)
basic: Applet initialized
  

[Ulf Dittmer]

The policy tool has nothing to do with signing an applet. HowCanAnAppletReadFilesOnTheLocalFileSystem has all the information you need to get you started with signing an applet.

[Rituraj Jain]

Thanks for your reply i am surely going to read every link on that tutorial but if you don't mind i would like to say that i don't want access any file on client system but i want to query database that is on server and dynamically generate applet.

    
import java.awt.*;
import java.sql.*;
import javax.swing.*;
public class AppletingS extends JApplet {
    
    public void init() {
  
	//JTree jt=new JTree();
	Container contentPane=getContentPane ();
	//contentPane.add (jt);
	//JMenuBar jmb=new JMenuBar();
    //jmb.add(new JMenu("file"));

    try
    {
        Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
        Connection con = DriverManager.getConnection("jdbc:sqlserver://172.16.101.18:1433;databaseName=PMDB;user=privuser;password=privuser");
        PreparedStatement psm=con.prepareStatement("select proj_id from projshar");
        ResultSet rs=psm.executeQuery ();
        while(rs.next ()){
            //jmb.add(new JMenu(rs.getString(1)));
		contentPane.add(new JLabel(rs.getString(1)));

        }
    }catch(Exception e){
        e.printStackTrace();}
	//contentPane.add(jmb);
	setVisible (true);
	
    }
    public void paint(Graphics g){
  }
}

[Ulf Dittmer]

I know. Read that page first, then you'll understand :-)

[Rituraj Jain]

thanks buddy, i read all the links on that page plus all the links on other linked pages and i got what i wanted

should i post the solution/steps for creating and running signed applet here or i am not supposed to post the solution here??

again thanks for the link

[Rob Spoor]

If your solution was signing the JAR only then that's pretty straightforward. The biggest problem with it is that a lot of people just don't know they have to do it

[Rituraj Jain]

ya you are right. i also had a funniest problem that i wanted to sign the Applet and was not even thought of signing the jar file..

its pretty straight just sign the jar, load applet, it will ask user whether to trust the supplier or not...if he says yer then every thing is fine...