标题: How to use SAS/Connect in Java Client [打印本页] 作者: shiyiming 时间: 2005-11-7 09:40 标题: How to use SAS/Connect in Java Client Dear:
I've run command "spawner -c tcp -nosecurity -service 2323" to
start the SAS/Connect Server. The cmd windows'log is
SAS Job Spawner for Windows version 9.0.
Waiting for TCP connection.
And in sas i've run the test statement block,it's work well.
[code:9628a]
%let ipaddr = 127.0.0.1;
OPTIONS COMAMID=TCP;
options remote=ipaddr;
signon ipaddr.__2323;
rsubmit;
proc print data=test;
run;
endrsubmit;
signoff ipaddr.__2323;
[/code:9628a]
Now, I'd migrated the code to Jave Client:
[code:9628a]
Properties info = new Properties();
info.setProperty("prompt1", "Hello>");
info.setProperty("response1", "sas");
info.setProperty("sasPortTag", "PORT=");
try {
TelnetConnectClient client=new TelnetConnectClient(info);
client.connect("scorwill",2323);
int ver1=client.getMajorSasVersion();
int ver2=client.getMinorSasVersion();
String driver=client.getDriverName();
client.rsubmit("data test;\n set fund.jj_gk;\n run\n");
String lines=client.getEditLines();
String logs=client.getLogLines();
System.out.println(client.isConnected()+driver+lines+ver1+ver2);
client.disconnect();
} catch (ConnectException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
[/code:9628a]
But it can connect to the server but didn't execute the proc!
Why?
The debug information is following:
true
SAS/CONNECT Driver for Java, Version 2.5 Production
data test;
set fund.jj_gk;
run
9
0
com.sas.net.connect.ConnectException: Connect.C22.ex.txt:
Sharenet.S284.ex.txt: Server would not accept message..
at
com.sas.net.util.WrapperException.fillInStackTrace(WrapperException.java:23­
at java.lang.Throwable.<init>(Unknown Source)
at java.lang.Exception.<init>(Unknown Source)
at com.sas.net.util.WrapperException.<init>(WrapperException.java:72)
at
com.sas.net.connect.ConnectException.<init>(ConnectException.java:49)
at com.sas.net.connect.ConnectClient.send(ConnectClient.java:1405)
at com.sas.net.connect.ConnectClient.flush(ConnectClient.java:1372)
at com.sas.net.connect.ConnectClient.drain(ConnectClient.java:1320)
at
com.sas.net.connect.ConnectClient.disconnect(ConnectClient.java:721)
at
com.sas.net.connect.TelnetConnectClient.disconnect(TelnetConnectClient.java&shy;:312)
at
com.sc.research.feclient.control.SASConnector.<init>(SASConnector.java:37)
at
com.sc.research.feclient.control.SASConnector.main(SASConnector.java:51