Introduction
Prerequisites:
◈ SAP Cloud Platform account with HANA as a Service entitlements (Note: the trial is soon expected to have HANA as a Service)
◈ Eclipse 2018-09 IDE for Java EE Developers
Step 1: Verify Eclipse Cloud Foundry Support.
1. Verify that your Eclipse installation has the necessary Cloud Foundry support by selecting “Help->Eclipse Marketplace”.
Search for Cloud Foundry in the Eclipse Marketplace. If it is not already installed, install it now. You should see Eclipse Tools for Cloud Foundry 1.2.0.
2. After installing the tools, allow Eclipse to restart. If you are not already in the Java development perspective, click on the “Workbench” button on the top right.
Step 2: Create a New Maven Project with a Servlet
1. Create a new Maven project by selecting “File->New->Maven Project” as shown below.
2. Press the Next button.
3. Select the maven archetype “webapp” as shown below.
4. Specify “com.sap.cloud.sample” for Group Id and “hello-world” for Artifact Id. Press Finish.
5. Lets create a servlet within the project. Ensure the previously created Maven project is selected, select “File->New->Servlet”
6. Specify “com.sap.cloud.sample” for the Java package and “HelloWorldServlet” for the Class name and press the Finish button.
7. For some reason the project does not currently follow the conventional Maven file structure for Java, so create a new folder call “java” under the main folder under source. Right click on the main folder and select “New->Folder”. Specify the name “java” for the new folder.
8. Move the “com” folder and sub-folders created when you created the servlet to the new “java” folder as shown below by dragging the “com” folder and dropping on top of the “java” folder. This is the file structure that Maven is expecting.
9. The new servlet will have a Maven dependency on “javax.servlet-api”. Right click on your project select “Maven->Add Dependency”.
10. Enter the “javax.servlet” for the Group Id, “javax.servlet-api” for the Artifact Id and “3.1.0” for the version. (Note: your version may vary on your Maven repository).
11. Press the OK button.
Optional. You could try at this point to package the application into war by right clicking on the project and select “Run As->Run Configurations”.
Enter “package” as the “Goals” and verify you see a “Build Success” message in the console.
Step 3: Setup your SAP Cloud Platform Cloud Foundry Database
1. Assuming the packaging process worked you can move on to setup the database services on SAP Cloud Platform for the application. Open your browser and log into SAP Cloud Platform to a subaccount that has Cloud Foundry entitlements assigned for HANA and a simple Java application. If you have not already created a space, create one now for the subaccount. Below you will see that there is a space called “dev”.
2. Navigate to your space and select “Service Marketplace”. Select “SAP HANA Service”. This will be your main database and later you will create a schema on top of it.
3. Select Instances on the left
4. Click on the “New Instance” button
5. Select the “standard” plan as you will not need enterprise features for this tutorial.
6. Provide a password for your SYSTEM user. Press the Next button as we will not need any additional features for the database.
7. Click on the Next button as you will be binding the application using Eclipse later on in the tutorial.
8. Provide a name of the instance and press the Finish button. Below “hana-std32″ was used as a instance name. Good Work! You have create your first HANA as a Service instance!
If you wanted to accomplish the same thing via the Cloud Foundry command line, the command to do this would be as shown below:
cf create-service hana-db standard hana-std32 -c “{\"SystemPassword\":\"<password>\",\"memory\":\"2\"}”
9. Click on your space name again and select “Service Marketplace” again. Select “SAP HANA Schemas & HDI Containers”.
You have several different options for HANA as a Service. If you were doing development using SAP’s Core Data Services (CDS) and Multi-Target Applications (MTA), you likely would select the HDI Shared option, there is a great blog on doing this in the useful resource section. If you are doing more traditional SQL style development, you likely would be using the “schema” option. Each of options will be tied to the previous database service that you just created. This tutorial will use a “schema”.
10. Select Instances on the left.
11. Click on the New Instance button.
12. Select “schema” plan and press the Next button.
13. You can give your schema name using the JSON in the image below. By doing this, your application could reference table as MYSCHEMA.tablename. Otherwise you will get a system generate schema name. Press the Next button.
14. We could bind the application if we had it ready at this point. As mentioned earlier, you will bind the application with the database using Eclipse later on in the tutorial. Press the Next button.
15. Enter the instance name for the schema as shown below and press the Finish button. When setting up JNDI configuration (later on in this document) the definitions reference the name “myHANAdb”. If you use a different name, you will need to change the context.xml to reflect the name you used here.
The schema gets assigned to the database service you created in step 8 earlier. Each database has a GUID which you can get from the Cloud Foundry CLI. If you wanted to get the GUID for the database you created you would use the following Cloud Foundry command.
cf service hana-std32 –guid
Using the command below you can create the HANA schema and associated with the hana-std32 database through the GUID.
cf create-service hana schema myHANAdb -c "{ \"database_id\":\"putyourGUIDfromabovehere\", \"schema\":\"myHANAdb\" }"
Step 4: Add Database code to the Servlet
1. Let’s add the code necessary for the database access to your application. Switch back to the Eclipse environment. Open the web.xml file located under src -> main-> webapp.
In the location where you see <insert code here> above, paste the following XML snippet to web.xml. Note that you wont have <insert code here> tags in your web.xml. This definition establishes the name “jdbc/DefaultDB” as a JNDI JDBC resource for the application.
<resource-ref>
<description>DB Connection</description>
<res-ref-name>jdbc/DefaultDB</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
Save and close the web.xml file.
2. Create the file context.xml in META-INF folder. Right click on the webapp folder and select “New->Folder”. Name the folder “META-INF”.
Right click on the new folder “META-INF”, select “New->File”. Name this file context.xml (use this exact case for the name).
3. Paste following XML into the context.xml file. This definition establishes that “jdbc/DefaultDB” will connect to a service named myHANAdb (which you just created). Save and close the context.xml file. Again if you used a different instance name above in step 15, you will need this file to reference the name used in step 15. The factory object referenced in the XML below will be provided by the sap_java_buildpack when you deploy the application to Cloud Foundry.
<?xml version="1.0" encoding="UTF-8"?>
<Context> <Resource name="jdbc/DefaultDB"
auth="Container"
type="javax.sql.DataSource"
factory="com.sap.xs.jdbc.datasource.tomcat.TomcatDataSourceFactory"
service="myHANAdb"/>
</Context>
4. If the HelloWorldServlet.java file is not already opened, open it and position the cursor under the first import statement. Paste the following code to include key libraries for JDNI and JDBC.
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.naming.NamingException;
import javax.sql.DataSource;
import java.sql.*;
Expanded the import section should appears as shown below.
5. Scroll down to the “doGet” method. Comment out the line after “// TODO Auto-generated method stub”, Paste the following code into the editor after your new comment.
Context ctx = null;
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
try {
ctx = new InitialContext();
DataSource ds = (DataSource) ctx.lookup("java:comp/env/jdbc/DefaultDB");
con = ds.getConnection();
stmt = con.createStatement();
rs = stmt.executeQuery("select current_user as myuser from dummy");
rs.next();
response.getWriter().append("Served at:").append(rs.getString(1)).append(request.getContextPath());
}catch(NamingException e){
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
Step 5: Add the Cloud Foundry Server and Run the Application
1. Let’s add the Cloud Foundry Server. Under the Servers window, click on “Click on this link to create a new server”. If you already had a server in the window, right click on the “Servers” window and select “New->Server”.
2. Select Cloud Foundry and provide a name. Below the name “Cloud Foundry” is used. Press the Next button.
3. Enter your SAP Cloud Platform user and password. Click on the “Manage Cloud…” button.
4. Click the Add button.
5. You will need to get the Cloud Foundry API Endpoint URL for your cloud instance. Switch back to your browser and navigate to the overview section of your subaccount. The URL will be on the right with a heading of API Endpoint.
6. Copy the URL. Switch back to Eclipse and paste the URL into the URL field. Provide a name for the Cloud URL. Press the Finish button.
7. Press the OK button.
8. Press the Next button.
9. Select the space under which you had setup the database services. Press the Next button.
10. Select your “hello-world” application and press the Add button. Press the Finish button.
In the “Servers” window, you will see that your application is assigned to the new server but not deployed.
11. Lets clean the project to ensure we are getting the latest code. Right click on the project and select “Run As->Maven clean”. Ensure your directory structure has the java folder under the main and not resource folder under “src”.
12. Right click on the project and select “Run As->Run on Server”.
13. Select the Cloud Foundry server that you created earlier and click on the Next button.
14. Click on the Finish button.
15. You will be prompted for Application details, enter the “sap_java_buildpack” for the Buildpack URL and check the box to update the manifest file. Press the Next button.
There several buildpacks on SAP Cloud Platform. The following Cloud Foundry command will provide a list of buildpacks avalable:
cf buildpacks
16. Change the memory limit to 1024. Press the Next button.
17. Bind to the schema instance name “myHANAdb” that you created earlier by clicking the check box for “myHANAdb”.
18. Press the Finish button
In the console you will see the following output:
Checking application - hello-world
Generating application archive - hello-world
Pushing application - hello-world
Creating application - hello-world
Application successfully pushed
Starting application - hello-world
[Application Running Check] - Checking if application is running - hello-world. Please wait...
[Application Running Check] - Application appears to be running - hello-world.
Eclipse may not use https in the attempt to run the application and may fail. If it uses http, change the URL from “http” to “https” when launching the browser.Also, the process of verifying the application may not appear to be complete within Eclipse very quickly but if you switch to your browser and navigate to the space and you will see your application listed under application as hello-world, you will find an URL under Application Routes for the Application route. Click on this link for the application route and you will see Hello World! In the browser. Before you click on the URL, ensure you see the green “Started” message as shown below.
19. Append the text “/HelloWorldServlet” to the URL above and you should see “Served at: MYSCHEMA” which is illustrates that you are connected to the database with a user name MYSCHEMA.
ReplyDeleteThank you very much for shared this. I got lot of ideas after reading this. Share more as similar to this.
core java training in chennai
core java Training in Tnagar
c c++ course fees in chennai
c c++ courses in chennai
C Language Training
javascript training in chennai
Appium Training in Chennai
JMeter Training in Chennai