Java and SAP Portal blog

пятница, 1 марта 2019 г.

How to make SAP JPA Entity on SAP Enterprise portal for SQL Server Database

I need to create SAP JPA Entity for SAP Enterprise Portal for work with SQL Server:

1. I Create ejb module project (EJB) and Enterprise Project (EAR).
2. Right clikck on mouse on ejb project and select JPA Tools -> Generate Entities from Tables
3. On wizard click on Add connections.
4. Select SQL Server
5. Next click on New Driver Definition, select 2008 JDBC Driver, on tab JAR List delete default driver and add your driver for DB (For java 8 you need jdbc4 driver). Click OK.
6. Input connection properties and next
7. Next you have connected to DB, choose schema and select your table to generate entity.
8. Next generate Entity as usual. JPA need uniqe id field in table. If you created table with identity id, you can specify GenerationType.IDENTITY.
9. On SAP EP go to nwa -> Application Resources.
10. Create new Custom Data Source.

Driver name: SYSTEM_DRIVER
SQL Engine: Vendor SQL
Isolation Level: Default
Driver Class Name: com.microsoft.sqlserver.jdbc.SQLServerDriver
Database URL: jdbc:sqlserver://<host>:1433;databaseName=DB
User and pass.

11. In your EAR component specify your datasource from previous step:
<data-source-name>YOUR_DATASOURCE</data-source-name>.
12. Deploy

среда, 27 декабря 2017 г.

Stemming Apache Lucene example Russian language

Example of Stemming Apache Lucene - Russian language:

String querystr = "Проводнику большие";

  
Analyzer analyzer = new RussianAnalyzer(Version.LUCENE_40);


Directory index = new RAMDirectory();


IndexWriterConfig config = new IndexWriterConfig(Version.LUCENE_40, analyzer);


IndexWriter w = new IndexWriter(index, config);
addDoc(w, "Проводник большой", "193398817");
addDoc(w, "Проводнику большому", "55320055Z");
addDoc(w, "Проводные большие", "55063554A");
addDoc(w, "Большие проводники", "9900333X");  
w.close();


Query q = new QueryParser(Version.LUCENE_40, "title", analyzer).parse(querystr);


int hitsPerPage = 10;
IndexReader reader = DirectoryReader.open(index);
IndexSearcher searcher = new IndexSearcher(reader);
TopScoreDocCollector collector = TopScoreDocCollector.create(hitsPerPage, true);
searcher.search(q, collector);
ScoreDoc[] hits = collector.topDocs().scoreDocs;


System.out.println("Found " + hits.length + " hits.");
for (int i = 0; i < hits.length; ++i) {
 int docId = hits[i].doc;
 Document d = searcher.doc(docId);
 System.out.println((i + 1) + ". " + d.get("isbn") + "\t" + d.get("title"));
}

reader.close();

вторник, 12 декабря 2017 г.

How to call SAP BPM OData service api from jQuery ajax

How to call SAP BPM OData service api from jQuery ajax.

Call with "GET" method:
If you want to call BPM OData service via http "GET" method, then you just call it via jQuery $.ajax.

Call with "POST" method:
If you want to call BPM OData service via http "POST" method, then first you have to call some BPM OData service with "GET" method with http header 'x-csrf-token' with value 'Fetch' to get token. Then you have to call BPM OData service with "POST" method and you have to set 'x-csrf-token' header which you recieved in previous step.

Example:

<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>

<div class="MyTest">Hello</div>
<div class="result1">result1</div>
<div class="result2">result2</div>

<script type="text/javascript">

$.ajax({
url: "http://<server>:<port>/bpmodata/processes.svc/ProcessCollection('<bpm process id>')?$format=json",
headers: {
'x-csrf-token':'Fetch',
},
method: 'GET',
success: function(data, textStatus, request){
var myToken = request.getResponseHeader('x-csrf-token');
$(".result1").html(myToken);

$.ajax({
url: "http://<server>:<port>/bpmodata/processes.svc/Cancel?InstanceId='<bpm process id>'&$format=json",
headers: {
'x-csrf-token': myToken,
},
method: 'POST',
success: function(data, textStatus, request){
$(".result2").html('completed');
},
error: function (request, textStatus, errorThrown) {
alert('Error');
}
});

},
error: function (request, textStatus, errorThrown) {
alert('Error' + request.getResponseHeader('x-csrf-token'));
}

});

</script>

</body>
</html>

понедельник, 20 ноября 2017 г.

JDBC get Connection MySql MS SQL

public static Connection getConnection() {

//MySql
Class.forName("com.mysql.jdbc.Driver");

//MS SQL
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");

String url = PortalHelper.getAppProperties("DATABASE_URL");
String name = "JDBC_USER_NAME";
String password = "JDBC_USER_PASSWORD";

return DriverManager.getConnection(url, name, password);
}

четверг, 9 ноября 2017 г.

File Content Types

application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

четверг, 3 ноября 2016 г.

Change prefix while creatin table in Dictionary development component

Change prefix while creatin table in Dictionary development component.

Go to -> preference -> Dictionary. Change prefix.

четверг, 25 августа 2016 г.

Make JPA Entity with @OneToMany and @ManyToOne mapping tags

Problem:
Your need to make JPA Entity with @OneToMany and @ManyToOne mapping tags.

Solution:
You have tables like this:

Table "Requests":

Field	Type
ID	Integer
STEP_ID	Integer

Table "Steps":

Field	Type
ID	Integer
REQUEST_ID	Integer

Table "Requests" should have in field "Step_Id" many rows from table "Steps", and table "Steps" should have in field "Requst_Id" one row from "Requests" table.

Make JPA Entities like this:

@Entity
@Table(name="REQUESTS")
public class Requests implements Serializable {

@Id
@GeneratedValue(strategy=GenerationType.AUTO)
private long id;

@OneToMany(mappedBy="request", fetch=FetchType.EAGER)
private Set<Steps> steps = new HashSet<Steps>();

public Requests() {
}

public long getId() {
return this.id;
}

public void setId(long id) {
this.id = id;
}

public void setSteps(Set<Steps> history) {
this.steps = steps ;
}

public Set<Steps> getSteps() {
return steps;
}
}

@Entity
@Table(name="STEPS")
public class Steps implements Serializable {

@Id
@GeneratedValue(strategy=GenerationType.AUTO)
private int id;

@ManyToOne(cascade = {CascadeType.MERGE, CascadeType.PERSIST}, fetch=FetchType.EAGER)
@JoinColumn(name = "REQUEST_ID")
private EoRequestsEntity request;

public Steps() {
}

public int getId() {
return this.id;
}

public void setRequest(Requests request) {
this.request = request;
}

public EoRequestsEntity getRequest() {
return request;
}

}

Tags "cascade" and "fetch" is required!

That's all!

среда, 24 августа 2016 г.

How to create iView for sap portal web module application

Problem:
How to create iView for sap portal web module application

Solution:

Create URL iView and set link to your web module application. If you do not know thar, you can run it in your Netweaver Developer Studio: right hand mouse click on development component, choose Run on Server - choose your server and run it. You will see url in browser.
In iView properties set property Fetch Mode - Server Side.

пятница, 12 августа 2016 г.

Check if your TLD is valid against its scheme

Problem:

You have an error:

Caused by: com.sap.engine.services.servlets_jsp.jspparser_api.exception.JspParseException: Error in parsing the taglib tag in the JSP page. Cannot resolve URI: [http://java.s.com/jsf/html]. Possible reason - validation failed. Check if your TLD is valid against its scheme.

Solution:

Put in your ear (Enterprise Application) development component in file ""META-INF/application-j2ee-engine.xml"" that code:

<application-j2ee-engine xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xsi:noNamespaceSchemaLocation="application-j2ee-engine.xsd">

<reference-target target-type="library" provider-name="sap.com">

tc~ui~faces

</reference-target>

</reference>

</application-j2ee-engine>

End everything works!

вторник, 5 июля 2016 г.

NWDS prompt for create activity in NWDI when editing some file

To prompt for create activity in NWDI when editing some file in NWDS you should go to Window -> Preference -> Development Infrastructure -> Design Time Repository -> Dialog Settings. In that window choose prompt.

пятница, 1 марта 2019 г.

среда, 27 декабря 2017 г.

вторник, 12 декабря 2017 г.

понедельник, 20 ноября 2017 г.

четверг, 9 ноября 2017 г.

четверг, 3 ноября 2016 г.

четверг, 25 августа 2016 г.

среда, 24 августа 2016 г.

пятница, 12 августа 2016 г.

вторник, 5 июля 2016 г.