xml transform to pdf

, ,
1

Hello, i am trying to get the xml data from the database and transform it to pdf format. I don’t have any runtime error, but i don’t see anything in the browser. Can somebody help me to solve this Problem?
My Sourcecode seems like this:

import java.io.*;

import javax.servlet.;
import javax.servlet.http.;

import javax.xml.transform.Transformer;
import javax.xml.transform.TransformerFactory;
import javax.xml.transform.stream.StreamSource;

import org.apache.avalon.framework.logger.ConsoleLogger;
import org.apache.avalon.framework.logger.Logger;
import org.apache.fop.apps.Driver;
import org.apache.fop.messaging.MessageHandler;

import org.jdom.Document;
import org.jdom.Element;
import org.jdom.transform.JDOMResult;
import org.jdom.transform.JDOMSource;

import com.softwareag.tamino.db.API.connection.* ;
import com.softwareag.tamino.db.API.accessor.* ;
import com.softwareag.tamino.db.API.objectModel.* ;
import com.softwareag.tamino.db.API.objectModel.jdom.* ;
import com.softwareag.tamino.db.API.response.* ;

/* Das ist ein Servlet mit pdf Output */

public class HelloTamino5 extends HttpServlet
{
private static final long serialVersionUID = -1961320101946993091L;
public static final String URL = “http://localhost/tamino/DBForschung”;
public static final String USER = “ming”;

public void doGet( HttpServletRequest requ, HttpServletResponse resp )
throws ServletException, IOException
{
resp.setContentType(“application/pdf”);
ByteArrayOutputStream out = new ByteArrayOutputStream();

TConnection tcon = null;
try
{
    tcon = TConnectionFactory.getInstance().newConnection (URL, USER , "");    
    TXMLObjectAccessor tacc = tcon.newXMLObjectAccessor (
    		TAccessLocation.newInstance("ForschDB"),
    		TJDOMObjectModel.getInstance() ) ;
    TQuery query = TQuery.newInstance ("/Abteilung") ;

    // Query for the resulting document(s)

    TResponse tresp = tacc.query (query) ;
    TXMLObjectIterator ti = tresp.getXMLObjectIterator() ;
    TXMLObject next = ti.next();
    Element element=(Element)next.getElement();
 
    element=element.detach();
    Document doc=new Document(element);
      
    Logger log = new ConsoleLogger(ConsoleLogger.LEVEL_WARN);
    MessageHandler.setScreenLogger(log);
    Driver driver = new Driver();
    driver.setLogger(log);
    driver.setRenderer(Driver.RENDER_PDF);
    driver.setOutputStream(out);

        
    Transformer transformer = TransformerFactory.newInstance().newTransformer(new StreamSource(new File("D:/fopdatein/xslt/abteilung2fo.xsl")));
	JDOMSource xmlsource = new JDOMSource(doc);
	JDOMResult result = new JDOMResult();  
	 
	transformer.transform(xmlsource, result);
	result.getDocument();
	resp.setContentLength(out.size());    
    resp.getOutputStream().write(out.toByteArray());
    resp.getOutputStream().flush();

   
}
catch (TConnectionException terr)
{
	System.out.println ("Sorry, database Forschdb is offline.") ;
}
catch (Exception e)
{
	System.out.println ("Application error") ;
    e.printStackTrace() ;
}
finally
{
    try
    {
        if (tcon != null && !tcon.isClosed())
            tcon.close ();
    }
    catch (Exception e)
    {
    	System.out.println ("Connection cannot be closed") ;
    }
}

}
}

Thanks in advance!
Ming

2

Hello,
I think the output of your transformation is not finding its way into the Driver for rendering. Try the following:

  1. Remove your statement “JDOMResult result = new JDOMResult();”
  2. Change your transform to:
    transformer.transform(xmlsource, new SAXResult(driver.getContentHandler()));
    You will need to adjust your import statements too.
    I hope this helps, but if not you can find some examples
    here
3

It works, thanks a lot!!!