1、操作步骤
1.1Add an SAPHANA System.没有SAP HANA环境想要学习的同学,可以考虑申请SAP HANA Trials,试用30天,体验一下。附链接
http://global.sap.com/software-free-trials/index.epx?url_id=text-us-header-freetrials
1.2Add a Repository Workspace
1.3新建XS Project,OPENSAP1如下图所示
1.4新建.xsapp和.xsaccess。其中.xsapp文件内容为空,作为应用程序描述符(Application descriptor)标记web内容的root;.xsaccess文件作为Application access文件,一是Exposes Web content,二是Setsuser/clientauthentication mechanism。根据OPEN SAP公开课程,在.xsaccess中写代码如下:
{ "exposed":true, "authentication":[ { "method":"LogonTicket" }, { "method":"Basic" } ] }
1.5新建XS JavaScript Source File,RetrieveData.xsjs,添加代码如下
$.response.contentType= "text/html"; var output ="Hello World! <br><br>"; var conn =$.db.getConnection(); var pstmt =conn.prepareStatement("select * from DUMMY"); var rs =pstmt.executeQuery(); if (!rs.next()) { $.response.setBody("Failed to retrieve data"); $.response.status =$.net.http.INTERNAL_SERVER_ERROR; } else { output = output +"This is the response from my SQL: " + rs.getString(1); } rs.close(); pstmt.close(); conn.close(); $.response.setBody(output);
1.6将 Project OPENSAP1 Team→share Project、commit、activate,在浏览器中输入http://<Myserver>:8000/WorkShop/sessiona/RetrieveData.xsjs
2、发现错误及解决办法
2.1在浏览器中输入http://<Myserver>:8000/WorkShop/sessiona/RetrieveData.xsjs,回车后发现如下错误:
500 -Internal server error
An error occurredduring the processing of your request.
Data might be lost.
2.2在SCN中链接如下内容http://scn.sap.com/thread/3398193#
下载SPS6的SAP_HANA_Developer_Guide_en.pdf,将.xsaccess内容修改为
{"exposed" : true, "authentication" : [ { "method": "Basic" } ] }
修改完,Team Commit→Activate,然后浏览器中输入
http://<Myserver>:8000/WorkShop/sessiona/RetrieveData.xsjs,显示如下:
程序运行成功。