i am very new @Birt and Eclipse and i have some big problems.
I tried to implement this code: http://wiki.eclipse...._%28BIRT%29_2.1
like that:
[Main]
public static void main(String[] args)
{
Converter con = new Converter();
try
{
con.executeReport();
}
catch (EngineException e)
{
e.printStackTrace();
}
}
[Converter]
package birt;
import java.util.logging.Level;
import org.eclipse.birt.core.framework.Platform;
import org.eclipse.birt.report.engine.api.EngineConfig;
import org.eclipse.birt.report.engine.api.EngineException;
import org.eclipse.birt.report.engine.api.IReportEngine;
import org.eclipse.birt.report.engine.api.IReportEngineFactory;
import org.eclipse.birt.report.engine.api.IReportRunnable;
import org.eclipse.birt.report.engine.api.IRunAndRenderTask;
import org.eclipse.birt.report.engine.api.PDFRenderOption;
public class Converter
{
public void executeReport() throws EngineException
{
IReportEngine engine = null;
EngineConfig config = null;
try
{
config = new EngineConfig();
// config.setBIRTHome("C://Anlagendaten//Birt//birt-runtime-3_7_1//ReportEngine");
config.setLogConfig("c:/temp/test/LOG", Level.FINEST);
Platform.startup(config);
IReportEngineFactory factory = (IReportEngineFactory) Platform
.createFactoryObject(IReportEngineFactory.EXTENSION_REPORT_ENGINE_FACTORY);
engine = factory.createReportEngine(config);
IReportRunnable design = null;
// Open the report design
design = engine
.openReportDesign("C:/Anlagendaten/Birt/workspace/Birt_report/test.rptdesign");
IRunAndRenderTask task = engine.createRunAndRenderTask(design);
// task.setParameterValue("Top Count", (new Integer(5)));
// task.validateParameters();
// HTMLRenderOption options = new HTMLRenderOption();
// options.setOutputFileName("output/resample/Parmdisp.html");
// options.setOutputFormat("html");
// options.setHtmlRtLFlag(false);
// options.setEmbeddable(false);
// options.setImageDirectory("C:\\test\\images");
PDFRenderOption options = new PDFRenderOption();
options.setOutputFileName("c:/temp/test/test.pdf");
options.setOutputFormat("pdf");
task.setRenderOption(options);
task.run();
task.close();
engine.destroy();
}
catch (Exception ex)
{
ex.printStackTrace();
}
finally
{
Platform.shutdown();
}
}
}
I am using MS SQL Server 2005 with windows authentication.
If i run BIRT in eclipse i can see the result preview without any problems, but if i run my program i get strange error Messages:
Feb 13, 2012 2:30:37 PM org.eclipse.datatools.connectivity.oda.profile.provider.ProfilePropertyProviderImpl getConnectionProfile Warnung: No connection profile is found by its specified name: null Feb 13, 2012 2:30:37 PM org.eclipse.datatools.connectivity.internal.ConnectivityPlugin log Schwerwiegend: Unable to determine the default workspace location. Check your OSGi-less platform configuration of the plugin or datatools workspace path. java.lang.IllegalStateException: Unable to determine the default workspace location. Check your OSGi-less platform configuration of the plugin or datatools workspace path. at org.eclipse.datatools.connectivity.internal.ConnectivityPlugin.getDefaultStateLocation(ConnectivityPlugin.java:154) at org.eclipse.datatools.connectivity.internal.ConnectivityPlugin.getStorageLocation(ConnectivityPlugin.java:175) at org.eclipse.datatools.connectivity.drivers.XMLFileManager.getStorageLocation(XMLFileManager.java:264) at org.eclipse.datatools.connectivity.drivers.XMLFileManager.loadPropertySets(XMLFileManager.java:204) at org.eclipse.datatools.connectivity.drivers.DriverManager.loadAllInstances(DriverManager.java:75) at org.eclipse.datatools.connectivity.drivers.DriverManager.resetDefaultInstances(DriverManager.java:589) at org.eclipse.datatools.connectivity.drivers.DriverManager.<init>(DriverManager.java:117) at org.eclipse.datatools.connectivity.drivers.DriverManager.getInstance(DriverManager.java:62) at org.eclipse.datatools.connectivity.DriverConnectionBase.getDriverDefinition(DriverConnectionBase.java:136) at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.open(JDBCConnection.java:71) at org.eclipse.datatools.enablement.msft.internal.sqlserver.connection.JDBCSQLServerConnectionFactory.createConnection(JDBCSQLServerConnectionFactory.java:27) at org.eclipse.datatools.connectivity.internal.ConnectionFactoryProvider.createConnection(ConnectionFactoryProvider.java:83) at org.eclipse.datatools.connectivity.internal.ConnectionProfile.createConnection(ConnectionProfile.java:359) at org.eclipse.datatools.connectivity.internal.ManagedConnection.createConnection(ManagedConnection.java:166) at org.eclipse.datatools.connectivity.internal.CreateConnectionJob.run(CreateConnectionJob.java:56) at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54) Feb 13, 2012 2:30:37 PM org.eclipse.datatools.connectivity.internal.ConnectivityPlugin log Schwerwiegend: Unable to determine the default workspace location. Check your OSGi-less platform configuration of the plugin or datatools workspace path. Feb 13, 2012 2:30:37 PM org.eclipse.datatools.connectivity.internal.ConnectivityPlugin log Schwerwiegend: Unable to determine the default workspace location. Check your OSGi-less platform configuration of the plugin or datatools workspace path. java.lang.IllegalStateException: Unable to determine the default workspace location. Check your OSGi-less platform configuration of the plugin or datatools workspace path. at org.eclipse.datatools.connectivity.internal.ConnectivityPlugin.getDefaultStateLocation(ConnectivityPlugin.java:154) at org.eclipse.datatools.connectivity.drivers.DriverManager.wereDefaultDriversCreated(DriverManager.java:518) at org.eclipse.datatools.connectivity.drivers.DriverManager.resetDefaultInstances(DriverManager.java:594) at org.eclipse.datatools.connectivity.drivers.DriverManager.<init>(DriverManager.java:117) at org.eclipse.datatools.connectivity.drivers.DriverManager.getInstance(DriverManager.java:62) at org.eclipse.datatools.connectivity.DriverConnectionBase.getDriverDefinition(DriverConnectionBase.java:136) at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.open(JDBCConnection.java:71) at org.eclipse.datatools.enablement.msft.internal.sqlserver.connection.JDBCSQLServerConnectionFactory.createConnection(JDBCSQLServerConnectionFactory.java:27) at org.eclipse.datatools.connectivity.internal.ConnectionFactoryProvider.createConnection(ConnectionFactoryProvider.java:83) at org.eclipse.datatools.connectivity.internal.ConnectionProfile.createConnection(ConnectionProfile.java:359) at org.eclipse.datatools.connectivity.sqm.internal.core.connection.ConnectionInfoImpl.initializeJDBCConnection(ConnectionInfoImpl.java:705) at org.eclipse.datatools.connectivity.sqm.internal.core.connection.ConnectionInfoImpl.<init>(ConnectionInfoImpl.java:690) at org.eclipse.datatools.connectivity.sqm.internal.core.connection.ConnectionFactory.createConnection(ConnectionFactory.java:38) at org.eclipse.datatools.connectivity.sqm.core.SQMConnectionFactory.createConnection(SQMConnectionFactory.java:45) at org.eclipse.datatools.connectivity.sqm.internal.core.connection.ConnectionFactory.createConnection(ConnectionFactory.java:59) at org.eclipse.datatools.connectivity.internal.ConnectionFactoryAdapterProvider.createConnection(ConnectionFactoryAdapterProvider.java:114) at org.eclipse.datatools.connectivity.internal.ManagedConnection.createConnection(ManagedConnection.java:163) at org.eclipse.datatools.connectivity.internal.CreateConnectionJob.run(CreateConnectionJob.java:56) at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54) Feb 13, 2012 2:30:37 PM org.eclipse.datatools.connectivity.internal.ConnectivityPlugin log Schwerwiegend: Unable to determine the default workspace location. Check your OSGi-less platform configuration of the plugin or datatools workspace path.
I readed, that maybe the windows authentication is an problem. Also readed that i have maybe to use DTP, but i dont know how. Maybe someone can help me.
[UPDATED INFOS]
My Connection URL is:
jdbc:sqlserver://localhost\3DA82F6B8F534B4\GRAPHPIC:1433;databaseName=GP8;integratedSecurity=true;
I use a standard JDBC connection with Microsoft SQL Server 2005 JDBC Driver and no Profil.
I use the option: JDBC Database Connection for Query Builder.
PS: Sorry vor bad english
PPS: BIRT is a damn good tool!
MultiQuote
