Creating a report using the runtime engine and connecting to a MS SQL Server on a windows machine

Hello,

I recently downloaded the 3_7_1 BIRT runtime engine and have had some problems generating a report that connects to a MS SQL Server 2008 Express database. I Google'd around a bit and discovered that a plugin directory needs to be created to place the JDBC driver that is necessary to connect to the database. So I created the following:

C:\birt3.7.1\ReportEngine\plugins\org.eclipse.birt.report.data.oda.jdbc__3.7.0\drivers\jtds-1.2.5.jar

My jdbc error went away but now I am getting another error:

C:\birt3.7.1\ReportEngine>genReport -f PDF datum/ReverseMapping.rptdesign

C:\birt3.7.1\ReportEngine>ECHO off
Oct 19, 2011 4:03:39 PM org.eclipse.birt.report.engine.api.ReportRunner execute
SEVERE: exception in parsing the paramters
org.eclipse.birt.core.exception.BirtException: error.CannotStartupOSGIPlatform
at org.eclipse.birt.core.framework.Platform.startup(Platform.java:81)
at org.eclipse.birt.report.engine.api.ReportRunner.execute(ReportRunner.java:142)
at org.eclipse.birt.report.engine.api.ReportRunner.main(ReportRunner.java:122)
Caused by: org.eclipse.birt.core.framework.FrameworkException
at org.eclipse.birt.core.framework.osgi.OSGILauncher.startup(OSGILauncher.java:90)
at org.eclipse.birt.core.framework.Platform.startup(Platform.java:75)
... 2 more
Caused by: java.security.PrivilegedActionException: org.eclipse.birt.core.framework.FrameworkException: Could not find the Framework - org.eclipse.osgi i
n path c:\birt3.7.1\ReportEngine\plugins
at java.security.AccessController.doPrivileged(Native Method)
at org.eclipse.birt.core.framework.osgi.OSGILauncher.startup(OSGILauncher.java:75)
... 3 more
Caused by: org.eclipse.birt.core.framework.FrameworkException: Could not find the Framework - org.eclipse.osgi in path c:\birt3.7.1\ReportEngine\plugins
at org.eclipse.birt.core.framework.osgi.OSGILauncher.doStartup(OSGILauncher.java:123)
at org.eclipse.birt.core.framework.osgi.OSGILauncher.access$0(OSGILauncher.java:94)
at org.eclipse.birt.core.framework.osgi.OSGILauncher$1.run(OSGILauncher.java:79)
... 5 more
Oct 19, 2011 4:03:39 PM org.eclipse.birt.core.framework.osgi.OSGILauncher doShutdown
WARNING: Framework is already shutdown

Do I need any additional files in my plugin directory or elsewhere?

Best, Carl

Find more posts tagged with

Comments

harsimran

<blockquote class='ipsBlockquote' data-author="'cjmorris'" data-cid="84346" data-time="1319054778" data-date="19 October 2011 - 01:06 PM">
Hello, 
 
I recently downloaded the 3_7_1 BIRT runtime engine and have had some problems generating a report that connects to a MS SQL Server 2008 Express database. I Google'd around a bit and discovered that a plugin directory needs to be created to place the JDBC driver that is necessary to connect to the database. So I created the following: 
 
C:\birt3.7.1\ReportEngine\plugins\org.eclipse.birt.report.data.oda.jdbc__3.7.0\drivers\jtds-1.2.5.jar 
 
My jdbc error went away but now I am getting another error:

C:\birt3.7.1\ReportEngine>genReport -f PDF datum/ReverseMapping.rptdesign 
 
C:\birt3.7.1\ReportEngine>ECHO off 
Oct 19, 2011 4:03:39 PM org.eclipse.birt.report.engine.api.ReportRunner execute 
SEVERE: exception in parsing the paramters 
org.eclipse.birt.core.exception.BirtException: error.CannotStartupOSGIPlatform 
at org.eclipse.birt.core.framework.Platform.startup(Platform.java:81) 
at org.eclipse.birt.report.engine.api.ReportRunner.execute(ReportRunner.java:142) 
at org.eclipse.birt.report.engine.api.ReportRunner.main(ReportRunner.java:122) 
Caused by: org.eclipse.birt.core.framework.FrameworkException 
at org.eclipse.birt.core.framework.osgi.OSGILauncher.startup(OSGILauncher.java:90) 
at org.eclipse.birt.core.framework.Platform.startup(Platform.java:75) 
... 2 more 
Caused by: java.security.PrivilegedActionException: org.eclipse.birt.core.framework.FrameworkException: Could not find the Framework - org.eclipse.osgi i 
n path c:\birt3.7.1\ReportEngine\plugins 
at java.security.AccessController.doPrivileged(Native Method) 
at org.eclipse.birt.core.framework.osgi.OSGILauncher.startup(OSGILauncher.java:75) 
... 3 more 
Caused by: org.eclipse.birt.core.framework.FrameworkException: Could not find the Framework - org.eclipse.osgi in path c:\birt3.7.1\ReportEngine\plugins 
at org.eclipse.birt.core.framework.osgi.OSGILauncher.doStartup(OSGILauncher.java:123) 
at org.eclipse.birt.core.framework.osgi.OSGILauncher.access$0(OSGILauncher.java:94) 
at org.eclipse.birt.core.framework.osgi.OSGILauncher$1.run(OSGILauncher.java:79) 
... 5 more 
Oct 19, 2011 4:03:39 PM org.eclipse.birt.core.framework.osgi.OSGILauncher doShutdown 
WARNING: Framework is already shutdown

Do I need any additional files in my plugin directory or elsewhere? 
 
Best, Carl </blockquote>
 
 
Hi 
It looks like your birt Engine is not starting .so do first basic check like BIRT run time engine path is correct and is there proper permission to access all directory in side BIRT run time Setup.

cjmorris

<blockquote class='ipsBlockquote' data-author="'harsimran'" data-cid="84351" data-time="1319057026" data-date="19 October 2011 - 01:43 PM">
Hi 
It looks like your birt Engine is not starting .so do first basic check like BIRT run time engine path is correct and is there proper permission to access all directory in side BIRT run time Setup. </blockquote>
 
Thank you for the reply harsimran! 
 
I believe that the permissions are okay, but how do I set the run time engine path? Are you referring to the "set BIRT_HOME=c:\birt3.7.1" command? 
 
I should had noted previously that I previously ran the hello_world.rtpdesign report included in the samples folder and generated an output file. However, as soon as I created the plugin directory it stops working and throws the error(s) I provided earlier. If I delete the plugins directory, I can execute the hello_world report again successfully. 
 
I also should note that I use the RCP Designer to design my reports. My reports execute successfully through the Designer but I need to enable my reports to be generated via command line. The reports will then be executed by a job scheduler in a Windows 7 environment using the genReport.bat file.

sober

I have exactly the same issue on my Mac. I downloaded and unzipped the BIRT runtime files and set the BIRT_HOME variable to point to folder, where I unzipped the files. I ran the sample report successfully and tried to run my own reports afterwards.

While trying this, I stumbled over the missing JDBC drivers. I created a plugin sub directory under $BIRT_HOME/ReportEngine and copied the JDBC drivers (JAR files) to $BIRT_HOME/ReportEngine/plugins/org.eclipse.birt.report.data.oda.jdbc_3.7.1.v20110905/drivers. Afterwards, I receive the same error as the original poster.

This issue disappeared by copying the file org.eclipse.osgi_3.7.1.R37x_v20110808-1106.jar to the plugin directory $BIRT_HOME/ReportEngine/plugins.