Knowledge Sharing
JDeveloper
Read Lotus Notes Data via URL
Part 3
Introduction:
Read App Data from Lotus Notes Database into Java Server Faces Page on JDeveloper, running on Weblogic Server
Going forward, we will be looking at the data through TXT data in URL from Lotus Notes Database, feed the rest of the JDeveloper application. We could as well simply throw the records right into columns on DB2, but here we wanted to demonstrate the interaction between Apps via URL using Java, Xpages, and JSF...
HTTPDDECSVDataJDevJavaAgent | JavaAgent.java
the goal is to put it out there as a CSV or TXT file...
/**
* Created from copy: 2015.07.04.12.39.PM
* HTTPDDECSVDataJDevJavaAgent
* CSV data for Xpages to be read by Oracle JDeveloper Apps
*/
load imports
import lotus.domino.*;
import lotus.domino.local.Database;
import java.io.PrintWriter;
/**
* @author Dököll Solutions, Inc.
* @version 2015.07.04.12.39.PM
*
*/
begin class
public class JavaAgent extends AgentBase {
open method, this actually runs the whole App
public void NotesMain() {
let's add a try catch here, to grab errors near the end
try {
open our session...
Session session = getSession();
load info to console for debugging purposes
System.out
.println("HTTPDDECSVDataJDevJavaAgent System User, We've got a session..."
+ session);
load agentContext
AgentContext agentContext = session.getAgentContext();
...
System.out.println("got HTTPDDECSVDataJDevJavaAgent agentContext..."
+ agentContext);
find database based on session found
Database database = (Database) agentContext.getCurrentDatabase();
Find view in question according to current database
View view = database.getView("IssuesListings");
System.out.println("View Obtained..." + view);
declare document variables
Document currDoc;
Document tempDoc;
grab first doc
currDoc = view.getFirstDocument();
PrintWriter...
PrintWriter pw = getAgentOutput();
System.out
.println("URL: http://localhost/docucontent.nsf/javaagentfeedcsvexternalsites.txt");
Content type set at Txt
TODO: Figure out a better version to load a CSV file to browser
currently, the csv downloads to local directory
pw.println("Content-type:text/txt");
while (currDoc != null) {
write records from view into a Text file and show it in the
browser
pw.println(currDoc.getItemValueString("UserID") + " "
+ currDoc.getItemValueString("PageID") + " "
+ currDoc.getItemValueString("priority") + " "
+ currDoc.getItemValueString("issues"));
Get next document
tempDoc = view.getNextDocument(currDoc);
recycle currDoc
currDoc.recycle();
set currDoc to tempDoc
currDoc = tempDoc;
}
} catch (Exception e) {
e.printStackTrace();
}
}
}
From JDeveloper Side of things
Courtesy: http://stackoverflow.com/questions/6259339/how-to-read-a-text-file-directly-from-internet-using-java
I can do this in JDeveloper to read the file over
import java.net.*;
import java.io.*;
public class UrlTextfile {
public static void main(String[] args) throws Exception {
URL oracle = new URL("http://yoursite.com/yourfile.txt");
BufferedReader in = new BufferedReader(
new InputStreamReader(oracle.openStream()));
String inputLine;
while ((inputLine = in.readLine()) != null)
System.out.println(inputLine);
in.close();
}
}
and there you have it, data is in JDeveloper
Notes Database URL, ran from Domino Designer (DDE)
created button on JSF page launched via JDeveloper
Java Server Pages button
here is the JSF code
button text="button 1" id="b1" binding="#{backingBeanScope.backing_jdlotusfeed.b1}"
action="#{backingBeanScope.backing_jdlotusfeed.b1_action}"/>
Backing Bean, for above code
package com.dokoll.view.backing;
import java.io.BufferedReader;
import java.io.IOException;
import java.io.InputStreamReader;
import java.net.MalformedURLException;
import java.net.URL;
import oracle.adf.view.rich.component.rich.RichDocument;
import oracle.adf.view.rich.component.rich.RichForm;
import oracle.adf.view.rich.component.rich.nav.RichButton;
public class Jdlotusfeed {
private RichForm f1;
private RichDocument d1;
private RichButton b1;
public void setF1(RichForm f1) {
this.f1 = f1;
}
public RichForm getF1() {
return f1;
}
public void setD1(RichDocument d1) {
this.d1 = d1;
}
public RichDocument getD1() {
return d1;
}
public void setB1(RichButton b1) {
this.b1 = b1;
}
public RichButton getB1() {
return b1;
}
@SuppressWarnings("oracle.jdeveloper.java.nested-assignment")
public String b1_action() throws MalformedURLException, IOException {
Add event code here...
URL lotuNotesURL = new URL("http:localhost/docucontent.nsf/javaagentfeedcsvexternalsites.txt");
BufferedReader in = new BufferedReader(
new InputStreamReader(lotuNotesURL.openStream()));
String inputLine=null;
while ((inputLine = in.readLine()) != null)
System.out.println(inputLine);
in.close();
return null;
}
}
version: 2015.07.05.12.08.AM