RE: XML/XSL without using Cocoon

[Iouri Michtchenko]

Title: XML/XSL without using Cocoon

Hi,

I am using POI with Oracle XSQL Servlet:

 

import org.w3c.dom.Document;
import oracle.xml.parser.v2.XMLDocument;
import java.io.PrintWriter;
import oracle.xml.xsql.*;
import net.sourceforge.poi.serialization.HSSFSerializer;

 

public class XSQLExcelSerializer implements XSQLDocumentSerializer
{
  public void serialize(Document doc, XSQLPageRequest env) throws Throwable
  {
    try
    {
      HSSFSerializer hssf = new HSSFSerializer();
      String mimeType = hssf.getMimeType();
      env.setContentType("application/" + mimeType);
      hssf.setOutputStream(env.getOutputStream());
      ((XMLDocument) doc).reportSAXEvents(hssf);
    }
    catch(Exception e)
    {
      e.printStackTrace();
      throw e;
    }
  }
}