JCo3 建立连接到SAP（1）- 直接连接

最新推荐文章于 2023-05-25 10:20:02 发布

weixin_34226182

最新推荐文章于 2023-05-25 10:20:02 发布

阅读量797

点赞数

文章标签： java python

原文链接：https://my.oschina.net/100china/blog/220175

版权

2019独角兽企业重金招聘Python工程师标准>>>

本文阐述如何使用SAP JCo 3.4 建立到SAP服务器。

1. 创建一SAP用户：Test01, 使用SU01创建用户，本文不在详述。

为了方便起见，我将Profile "SAP_ALL“ 分配给用户TEST01, 如下图所示：

这样用户就可以通过SAP服务器的验证了，如果没有加这个Profile，以下日志信息会被抛出：

Exception in thread "main" com.sap.conn.jco.JCoException: (103) RFC_ERROR_LOGON_
FAILURE: User TEST01 has no RFC authorization for function group SYST . on 192.1
68.19.28 sysnr 00
        at com.sap.conn.jco.rt.MiddlewareJavaRfc.generateJCoException(Middleware
JavaRfc.java:637)
        at com.sap.conn.jco.rt.MiddlewareJavaRfc$JavaRfcClient.connect(Middlewar
eJavaRfc.java:1305)
        at com.sap.conn.jco.rt.ClientConnection.connect(ClientConnection.java:66
5)
        at com.sap.conn.jco.rt.PoolingFactory.init(PoolingFactory.java:103)
        at com.sap.conn.jco.rt.ConnectionManager.createFactory(ConnectionManager
.java:173)
        at com.sap.conn.jco.rt.DefaultConnectionManager.createFactory(DefaultCon
nectionManager.java:45)
        at com.sap.conn.jco.rt.ConnectionManager.getFactory(ConnectionManager.ja
va:162)
        at com.sap.conn.jco.rt.RfcDestination.initialize(RfcDestination.java:805
)
        at com.sap.conn.jco.rt.RfcDestination.getAttributes(RfcDestination.java:
633)
        at com.sap.conn.jco.rt.RfcDestination.getAttributes(RfcDestination.java:
28)
        at ConnectNoPool.connectWithoutPool(ConnectNoPool.java:50)
        at ConnectNoPool.main(ConnectNoPool.java:56)
Caused by: RfcException: [null]
    message: User TEST01 has no RFC authorization for function group SYST . on 1
92.168.19.28 sysnr 00
    Return code: RFC_SYS_EXCEPTION(3)
    error group: 103
    key: RFC_ERROR_LOGON_FAILURE

2. 编写连接SAP服务器代码

import java.io.File;
import java.io.FileOutputStream;
import java.util.Properties;

import com.sap.conn.jco.JCoException;
import com.sap.conn.jco.ext.DestinationDataProvider;
import com.sap.conn.jco.JCoDestination;
import com.sap.conn.jco.JCoDestinationManager;

public class ConnectNoPool {
   static String ABAP_AS = "ABAP_AS_WITHOUT_POOL";

   static
    {
        Properties connectProperties = new Properties();
        connectProperties.setProperty(DestinationDataProvider.JCO_ASHOST, "192.168.19.28");
        connectProperties.setProperty(DestinationDataProvider.JCO_SYSNR, "00");
        connectProperties.setProperty(DestinationDataProvider.JCO_CLIENT, "000");
        connectProperties.setProperty(DestinationDataProvider.JCO_USER,   "TEST01");
       //Must use Upper case for password, otherwise, SAP server will report password is incorrect.
        connectProperties.setProperty(DestinationDataProvider.JCO_PASSWD, "ADMIN123");
        connectProperties.setProperty(DestinationDataProvider.JCO_LANG,   "en");
        createDataFile(ABAP_AS, "jcoDestination", connectProperties);
    }

   //Creates a connection configuration file based on parameters given above
   static void createDataFile(String name, String suffix, Properties properties)
    {
        File cfg = new File(name+"."+suffix);
        if(!cfg.exists())
        {
            try
            {
                FileOutputStream fos = new FileOutputStream(cfg, false);
                properties.store(fos, "for tests only !");
                fos.close();
            }
            catch (Exception e)
            {
                throw new RuntimeException("Unable to create the destination file " + cfg.getName(), e);
            }
        }
    }

   public static void connectWithoutPool() throws JCoException
    {
        JCoDestination destination = JCoDestinationManager.getDestination(ABAP_AS);
        System.out.println("Attributes:");
        System.out.println(destination.getAttributes());
        System.out.println();
    }

   public static void main(String[] args) throws JCoException
    {
        connectWithoutPool();
    }
}