tomcat and omar

[everytime]

hi there , anyone here heard of tomcat , omar and postgres ?

i am not sure how the data in the jsp page is transferred to the database ..

am i right to say that jsp = presentation , servlet = web service and beans = data layer ???

i was given some sample codes to the db already created, and to my surprise there were no sql statements in the add function , but the view there was 1 ... its in the servlet which is something new to me as i am normaly doing .net and using ms access ...

1 of the servlet file looks like this , other may vary but not sure how to do it..


package org.poc.uwb.readFile;


import java.io.FileOutputStream;
import java.io.BufferedReader;
import java.io.FileReader;
import java.io.IOException;
import java.io.OutputStreamWriter;

import java.io.Writer;
import java.util.ArrayList;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;


import org.freebxml.omar.server.util.SOAPSender;
import org.rosettanet.poc.uwb.createFile.CreateBean;

public class QueryRequestPDFServlet extends HttpServlet {

public void doGet(HttpServletRequest request, HttpServletResponse response)
throws IOException, ServletException {
ArrayList myValue = new ArrayList();
ArrayList myUUID = new ArrayList();
String a;
String b;
String c;
String d;
String e;
String f;
String g;
String h;
String sql = null;

String user_home= System.getProperty("user.home");

a = ("<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n" +
"<!-- $Header$ -->\n" +
"<AdhocQueryRequest xmlns=\"urn:oasis:names:tc:ebxml-regrep:xsd:query:3.0\" " +
"xmlns:lcm=\"urn:oasis:names:tc:ebxml-regrep:xsd:lcm:3.0\" " +
"xmlns:query=\"urn:oasis:names:tc:ebxml-regrep:xsd:query:3.0\" " +
"xmlns:rim=\"urn:oasis:names:tc:ebxml-regrep:xsd:rim:3.0\" " +
"xmlns:rs=\"urn:oasis:names:tc:ebxml-regrep:xsd:rs:3.0\" " +
"xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" " +
"xsi:schemaLocation=\"urn:oasis:names:tc:ebxml-regrep:xsd:query:3.0 ../../../ebxmlrr-spec/misc/3.0/schema/query.xsd\">\n\n\t" +
"");

b = ("<query:ResponseOption returnComposedObjects=\"true\" returnType=\"LeafClass\"/>\n\t\t");

c = ("<rim:AdhocQuery id=\"tempId\">\n\t");

d = (" <rim:QueryExpression queryLanguage=\"urn:oasis:names:tc:ebxml-regrep:QueryLanguage:SQL-92\">\n\t");



sql = ("SELECT * FROM ExtrinsicObject eo, Name n WHERE eo.id = n.parent AND objecttype = 'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ExtrinsicObject:POC:PDF-Document'\n");


e = ("</rim:QueryExpression>\n\t");

f = ("</rim:AdhocQuery>\n");

g = ("</AdhocQueryRequest>");




try {

FileOutputStream fos = new FileOutputStream(user_home+"/regseg/test/UWB/Request/QueryRequestAllPDF.xml");
Writer out = new OutputStreamWriter(fos, "UTF8");


out.write(a + b + c + d + sql + e + f + g);
out.close();


}


catch (IOException ex) {
ex.printStackTrace();
}
System.out.println("create");
CreateBean CB = new CreateBean();
CB.setUser(request.getParameter("user"));

String [] args ;
args = new String [9];
args [0]= ("req="+user_home+"\\regseg\\test\\UWB\\Request\\QueryRequestAllPDF.xml");
args [1]= ("keyStoreType=jks");
args [2]= ("keyStorePassword=ebxmlrr");
args [3]= ("keyPassword="+CB.getUser());
args [4]= ("alias="+CB.getUser());
args [5]= ("url=http://localhost:8080/omar/registry/soap");
args [6]= ("localCall=false");
args [7]= ("res="+user_home+"\\regseg\\test\\UWB\\Response\\QueryResponseAllPDF.xml");
args [8]= ("keyStore="+user_home+"\\omar\\3.0-post-alpha2-dev\\jaxr-ebxml\\security\\keystore.jks");
System.out.println("sender");

SOAPSender.mySOAPSender(args);

FileReader fr = new FileReader(user_home+"/regseg/test/UWB/Response/QueryResponseAllPDF.xml");
BufferedReader in = new BufferedReader(fr);

String str;

while ((str = in.readLine())!= null) {

if (str.startsWith(" <ns1:LocalizedString")){

String[] line = str.split(" <ns1:LocalizedString charset=\"UTF-8\" value=\"");
for (int i=0; i<line.length; i++){

String[] value = line[i].split("\" ");

for (int j=0; j<value.length; j++){

String test = value[j];
myValue.add(test);
}
}
}
else if (str.startsWith(" <ns1:ExtrinsicObject isOpaque")){
String[] line = str.split("id=\"");
for (int i=0; i<line.length; i++){

String[] value = line[i].split("\" ");


for (int j=0; j<value.length; j++){
System.out.println("value["+j+"]" + value[j]);
String test = value[j];
myUUID.add(test);
}

}

}
}
FileBean file = new FileBean();

file.setMyValue(myValue);
file.setMyUUID(myUUID);

HttpSession session = request.getSession(true);
session.setAttribute("file",file);





response.setContentType("text/html");
request.getRequestDispatcher("uwb_Display_pdf.jsp").forward(request, response);


}


}