SAS中文论坛

 找回密码
 立即注册

扫一扫,访问微社区

查看: 847|回复: 0
打印 上一主题 下一主题

How to use SAS/Connect in Java Client

[复制链接]

49

主题

76

帖子

1462

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1462
楼主
 楼主| 发表于 2005-11-7 09:40:18 | 只看该作者

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­:312)
at
com.sc.research.feclient.control.SASConnector.<init>(SASConnector.java:37)
at
com.sc.research.feclient.control.SASConnector.main(SASConnector.java:51
回复 支持 反对

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|小黑屋|手机版|Archiver|SAS中文论坛  

GMT+8, 2025-6-9 07:09 , Processed in 0.069404 second(s), 20 queries .

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

快速回复 返回顶部 返回列表