在Oracle中创建java类，该类中创建Socket连接失败

[zrf5188]

create or replace and compile java source named clientsocket as
import java.io.*;
import java.net.*;
public class ClientSocket {
static int result=0;
public static void main(String args[]){
ClientSocket sc=new ClientSocket();
sc.sendmessage();

}
public static int sendmessage(){
try{
Socket s = new Socket("192.68.69.96", 8111);

result=1;
}
catch(SecurityException e){
result=2;
System.out.println("securityexception when connecting server!");
}
catch(IOException e){
result=3;
System.out.println("ioexception when connecting server!");
}
return result;
}

}
运行后result=2

[kokobox]

lz 把异常贴出来

用e.printStackTrace();打出来

[zrf5188]

Oracle出错提示：
the Permission (java.net.SocketPermission 192.68.69.96:8111 connect,resolve) has not been granted to FOODSAFETYIS. The PL/SQL to grant this is dbms_java.grant_permission( 'FOODSAFETYIS', 'SYS:java.net.SocketPermission', '192.68.69.96:8111', 'connect,resolve' )

问题已解决，谢谢kokobox

[kokobox]

不用客气o(∩_∩)o... 解决了就好o(∩_∩)o...