Applet- MS SQL Connection problem
1 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   Suresh_S
Posted On:   Thursday, April 8, 2004 03:57 AM

if web & database server r different how can i make my applet to fetch the data from the database server? I've changed policy file (client) signed the applet but still throwing the following Exception but the code is working fine with Appletviewer.... com.inet.tds.SQLException: access denied (java.net.SocketPermission 10.0.0.1:1433 connect,resolve) java.security.AccessControlException: access denied (java.net.SocketPermission 10.0.0.1:1433 connect,resolve) at java.security.AccessControlContext.checkPermission(Unknown Source) at java.security.AccessController.checkPermi   More>>
			

if web & database server r different
how can i make my applet to fetch the data from the database server?


I've changed policy file (client)


signed the applet but still throwing the following Exception
but the code is working fine with Appletviewer....






com.inet.tds.SQLException: access denied (java.net.SocketPermission 10.0.0.1:1433 connect,resolve)


java.security.AccessControlException: access denied (java.net.SocketPermission 10.0.0.1: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 java.net.Socket.connect(Unknown Source)

at java.net.Socket.connect(Unknown Source)

at java.net.Socket. (Unknown Source)

at java.net.Socket. (Unknown Source)

at com.inet.tds.k.a(Unknown Source)

at com.inet.tds.k.if(Unknown Source)

at com.inet.tds.k. (Unknown Source)

at com.inet.tds.k.a(Unknown Source)

at com.inet.tds.TdsDriver.connect(Unknown Source)

at java.sql.DriverManager.getConnection(Unknown Source)

at java.sql.DriverManager.getConnection(Unknown Source)


at SearchDataApplet$SearchData_ATest.getConnection(SearchDataApplet.java:1755)

at SearchDataApplet$SearchData_ATest.runQuery(SearchDataApplet.java:1983)

at SearchDataApplet$searchButtonListener.actionPerformed(SearchDataApplet.java:1443)

at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)

at javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(Unknown Source)

at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)


at javax.swing.DefaultButtonModel.setPressed(Unknown Source)

at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)

at java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)

at java.awt.Component.processMouseEvent(Unknown Source)

at java.awt.Component.processEvent(Unknown Source)

at java.awt.Container.processEvent(Unknown Source)

at java.awt.Component.dispatchEventImpl(Unknown Source)

at java.awt.Container.dispatchEventImpl(Unknown Source)

at java.awt.Component.dispatchEvent(Unknown Source)

at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)

at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)

at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)

at java.awt.Container.dispatchEventImpl(Unknown Source)

at java.awt.Component.dispatchEvent(Unknown Source)

at java.awt.EventQueue.dispatchEvent(Unknown Source)


at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source)

at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)

at java.awt.EventDispatchThread.pumpEvents(Unknown Source)


at java.awt.EventDispatchThread.pumpEvents(Unknown Source)

at java.awt.EventDispatchThread.run(Unknown Source)








can anybody help me?

please....

   <<Less

Re: Applet- MS SQL Connection problem

Posted By:   Brian_Glodde  
Posted On:   Thursday, April 8, 2004 07:08 AM

Assuming your policy file is correct, restricted permissions (security settings) between machines or firewall settings could cause this. You may have to circumvent by talking to a servlet (via HTTP tunnelling), which will then talk to the database.
About | Sitemap | Contact