| BIRT reports from an applet [message #368565] |
Wed, 10 June 2009 14:35 |
 Clemente Carlucci
Messages: 7
Registered: July 2009 |
Junior Member |
|
|
Hi,
I'm developing an applet that displays a table from a HSQLDB database and
I would like to integrate a report printing feature.
I integrated in the start method of the applet the following code:
.........
String birthome =
System.getProperty("user.dir")+System.getProperty("file.separator ")+"birt-runtime-2_3_2/ReportEngine/";
config = new EngineConfig( );
// config.setProperty("BIRT_HOME",
home+"birt-runtime-2_3_2/ReportEngine/");
config.setProperty("BIRT_HOME", birthome);
config.setLogConfig(home, Level.SEVERE);
config.setLogFile("errori.txt");
PlatformConfig pc = new PlatformConfig();
pc.setBIRTHome(birthome);
PlatformFileContext context = new PlatformFileContext(pc);
config.setPlatformContext(context);
Platform.startup(config);
IReportEngineFactory factory = (IReportEngineFactory) Platform
.createFactoryObject(
IReportEngineFactory.EXTENSION_REPORT_ENGINE_FACTORY );
engine = factory.createReportEngine( config );
.....
with the exception catching. Then I added a method to print the report
with the data obtained by a query on my database:
public void Stampa() throws BirtException, IOException, SQLException {
// String filereport = "/home/sviluppo/albo.rptdesign";
String filereport = System.getProperty("user.home");
filereport += System.getProperty("file.separator");
filereport += "albo.rptdesign";
IReportRunnable runnable = null;
try {
String output = filereport.replaceFirst(".rptdesign", ".pdf");
// String output = home+"albo.pdf";
runnable = engine.openReportDesign(filereport);
/* Oggetti ReportDesignHandle e OdaDataSetHandle per passare al data
set la query aggiornata
* C. Carlucci 05/06/2009
*/
ReportDesignHandle handle = (ReportDesignHandle)
runnable.getDesignHandle();
OdaDataSetHandle ds = (OdaDataSetHandle) handle.findDataSet("Data Set");
// String queryrs = "SELECT * FROM TABISCRITTI WHERE LOCNASCITA =
'BARI'";
if (! query.isEmpty()) {
ds.setQueryText("SELECT * FROM TABISCRITTI WHERE "+query);
} else {
ds.setQueryText("SELECT * FROM TABISCRITTI");
}
IRunAndRenderTask task = engine.createRunAndRenderTask(runnable);
/*
HTMLRenderOption option = new HTMLRenderOption( );
option.setOutputFileName(output);
option.setOutputFormat("html");
*/
PDFRenderOption option = new PDFRenderOption();
option.setOutputFileName(output);
option.setOutputFormat("pdf");
task.setRenderOption(option);
task.run();
task.close();
} catch (EngineException e) {
System.out.println("Errore di engine!");
}/* finally {
engine.destroy();
Platform.shutdown();
}*/
}
My problem is that the report generation operates well from the applet
viewer in Eclipse environment, but when I try to call the applet from an
html file, the applet displays well, but the report engine doesn't
operate. So I cannot generate my report. In the java console of the
browser (Firefox) I get the following error:
org.eclipse.birt.core.exception.BirtException: Cant startup the OSGI
framework
at org.eclipse.birt.core.framework.Platform.startup(Platform.ja va:91)
at albo.start(albo.java:398)
at sun.applet.AppletPanel.run(AppletPanel.java:465)
at java.lang.Thread.run(Thread.java:619)
Caused by: org.eclipse.birt.core.exception.CoreException
at
org.eclipse.birt.core.framework.osgi.OSGILauncher.startup(OS GILauncher.java:90)
at org.eclipse.birt.core.framework.Platform.startup(Platform.ja va:79)
... 3 more
Why the platform startup fail? It depends on the signing of the various
jar of my applications? Here's the code of the index.html that calls my
applet:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Albo Ingegneri Provincia di Bari</title>
<meta name="author" content="sviluppo">
<meta name="generator" content="Bluefish 1.0.7">
<meta name="description" content="" >
<meta name="keywords" content="" >
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1" >
<meta http-equiv="Content-Script-Type" content="text/javascript" >
<meta http-equiv="Content-Style-Type" content="text/css" >
</head>
<body>
<CENTER><H1>Ordine degli Ingegneri della Provincia di Bari</H1></CENTER>
<CENTER><H3>Albo Elettronico 2009</H3></CENTER>
<CENTER>
<APPLET code="albo.class" archive="signedalbo.jar,
lib/signedcommons-cli-1.0.jar, lib/signedhsqldb.jar,
lib/signedcom.ibm.icu_3.8.1.v20080530.jar, lib/signedcoreapi.jar,
lib/signeddataadapterapi.jar, lib/signeddteapi.jar,
lib/signedengineapi.jar, lib/signedjs.jar, lib/signedmodelapi.jar,
lib/signedodadesignapi.jar, lib/signedscritpapi.jar" width="1024"
height="768" align="center"></APPLET>
</center>
</body>
</html>
The applet read my signedalbo.jar and make the database jdbc connection
reading the lib/signedhsqldb.jar file. But can't start the OSGI. I missed
something?
Please help me! Thank you!
|
|
|
Powered by
FUDForum. Page generated in 0.03347 seconds
] 
Search
Help
Register
Login
Home
