Eclipse Community Forums: BIRT

Home » Archived » BIRT » Newby to BIRT

Tue, 06 October 2009 09:28

Eclipse User

Hi all,

I started to try out Birt in favor of Itext.

I made a report and connected it to my running hsqldb

Connection test was: OK

Now i made a test report, just printing some lines from a table in my db.

Te result was wat I expected and was the same as in the preview !

But i still get some sever exception when i run my code :

6-okt-2009 15:16:02 org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager loadExtraDriver
SEVERE: DriverClassLoader failed to load class: org.hsqldb.jdbcDriver
java.lang.ClassNotFoundException: org.hsqldb.jdbcDriver
at org.eclipse.birt.core.framework.URLClassLoader.findClass1(UR LClassLoader.java:185)
at org.eclipse.birt.core.framework.URLClassLoader$1.run(URLClas sLoader.java:154)
at org.eclipse.birt.core.framework.URLClassLoader$1.run(URLClas sLoader.java:1)
at java.security.AccessController.doPrivileged(Native Method)
at org.eclipse.birt.core.framework.URLClassLoader.findClass(URL ClassLoader.java:149)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.load ExtraDriver(JDBCDriverManager.java:919)
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.find Driver(JDBCDriverManager.java:738)
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.regi sterDriver(JDBCDriverManager.java:879)
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.load AndRegisterDriver(JDBCDriverManager.java:862)
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.doCo nnect(JDBCDriverManager.java:246)
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getC onnection(JDBCDriverManager.java:212)
at org.eclipse.birt.report.data.oda.jdbc.Connection.connectByUr l(Connection.java:234)
at org.eclipse.birt.report.data.oda.jdbc.Connection.open(Connec tion.java:160)
at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaCo nnection.open(OdaConnection.java:238)
at org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.o penConnection(ConnectionManager.java:180)
at org.eclipse.birt.data.engine.executor.DataSource.newConnecti on(DataSource.java:193)
at org.eclipse.birt.data.engine.executor.DataSource.open(DataSo urce.java:181)
at org.eclipse.birt.data.engine.impl.DataSourceRuntime.openOdiD ataSource(DataSourceRuntime.java:209)
at org.eclipse.birt.data.engine.impl.QueryExecutor.openDataSour ce(QueryExecutor.java:396)
at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecu tion(QueryExecutor.java:315)
at org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(Pr eparedQuery.java:448)
at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.pr oduceQueryResults(PreparedDataSourceQuery.java:190)
at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.ex ecute(PreparedDataSourceQuery.java:178)
at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute (PreparedOdaDSQuery.java:144)
at org.eclipse.birt.report.data.adapter.impl.DataRequestSession Impl.execute(DataRequestSessionImpl.java:511)
at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExec uteQuery(DteDataEngine.java:139)
at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.e xecute(AbstractDataEngine.java:254)
at org.eclipse.birt.report.engine.executor.ExecutionContext.exe cuteQuery(ExecutionContext.java:1818)
at org.eclipse.birt.report.engine.executor.QueryItemExecutor.ex ecuteQuery(QueryItemExecutor.java:80)
at org.eclipse.birt.report.engine.executor.ListItemExecutor.exe cute(ListItemExecutor.java:66)
at org.eclipse.birt.report.engine.internal.executor.dup.Suppres sDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor .java:43)
at org.eclipse.birt.report.engine.internal.executor.wrap.Wrappe dReportItemExecutor.execute(WrappedReportItemExecutor.java:4 6)
at org.eclipse.birt.report.engine.internal.executor.l18n.Locali zedReportItemExecutor.execute(LocalizedReportItemExecutor.ja va:34)
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStacking LM.layoutNodes(HTMLBlockStackingLM.java:65)
at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout (HTMLPageLM.java:90)
at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutE ngine.layout(HTMLReportLayoutEngine.java:99)
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doR un(RunAndRenderTask.java:170)
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run (RunAndRenderTask.java:75)
at birt.ExecuteReport.executeReport(ExecuteReport.java:40)
at birt.BirtTestUsage.main(BirtTestUsage.java:7)
6-okt-2009 15:16:02 org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager loadExtraDriver
SEVERE: refreshUrlsWhenFail: true
6-okt-2009 15:16:02 org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager loadExtraDriver
SEVERE: driverClassPath: null
6-okt-2009 15:16:02 org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager loadExtraDriver
SEVERE: Registered URLs:

code that i ran:

public void executeReport() throws EngineException {

IReportEngine engine = null;
EngineConfig config = null;

try {
config = new EngineConfig();
config
.setBIRTHome(" C:\\Users\\javadev\\Desktop\\birt-runtime-2_5_1\\ReportEngin e ");
Platform.startup(config);
IReportEngineFactory factory = (IReportEngineFactory) Platform
.createFactoryObject(IReportEngineFactory.EXTENSION_REPORT_E NGINE_FACTORY);
engine = factory.createReportEngine(config);

IReportRunnable design = null;
design = engine
.openReportDesign("src/test/java/birt/reports/secondTry.rptdesign ");
IRunAndRenderTask task = engine.createRunAndRenderTask(design);

PDFRenderOption options = new PDFRenderOption();
options
.setOutputFileName("c:/Users/javadev/Desktop/tempbirt/test2.pdf ");

options.setOutputFormat("pdf");

task.setRenderOption(options);
task.run();
task.close();
engine.destroy();
} catch (Exception ex) {
System.out.println("Error in executeReport : ");
ex.printStackTrace();
} finally {
Platform.shutdown();
}
}

You might notice it's the example code from the wiki.

So i don't know what i'm doing wrong, since there were no errors making the preview and the result is fine, because i get a pdf file with the data :s

Could someone please help.

Re: Newby to BIRT [message #490047 is a reply to message #489913]

Wed, 07 October 2009 01:13

Eclipse User

This error:
DriverClassLoader failed to load class: org.hsqldb.jdbcDriver

indicates that the driver jar is not in the
birt-runtime-2_5_1\ReportEngine\plugins\org.eclipse.birt.rep ort.data.oda.jdbc_2.5.1.v20090821\drivers

directory. Can you copy it there? You can also alter your code to pass in the path like:

config.getAppContext().put("OdaJDBCDriverClassPath", "c:/birt/mysql/mysql-connector-java-5.0.4-bin.jar");

Jason

Re: Newby to BIRT [message #490059 is a reply to message #489913]

Wed, 07 October 2009 02:48

Eclipse User

Thx a lot, the errors are gone Smile

Re: Newby to BIRT [message #657736 is a reply to message #490047]

Thu, 03 March 2011 13:34

Eclipse User

Thank you Jason. I also encountered the same problem but using Oracle 10g XE (for learning). I had added the following to my classpath when running my stand alone Java app:

C:\software\birtruntime\birt-runtime-2_6_2\ReportEngine\lib\ *.jar

C:\software\oracle10gExpressEdition\app\oracle\product\10.2. 0\server\jdbc\lib\ojdbc14.jar

My stand alone app did generate the pdf file but got the same error:

DriverClassLoader failed to load class: oracle.jdbc.OracleDriver

I then proceeded to add the following to the java code, as you suggested in your post:

config.getAppContext().put("OdaJDBCDriverClassPath", " C:\\software\\oracle10gExpressEdition\\app\\oracle\\product\ \10.2.0\\server\\jdbc\\lib\\ojdbc14.jar ");

The errors are gone too!

Thanks again!
--Anna

Re: Newby to BIRT [message #677006 is a reply to message #657736]

Tue, 07 June 2011 06:00

Eclipse User

hi,

can you please say where i have to paste the code i.e which program

Please help

Re: Newby to BIRT [message #677014 is a reply to message #657736]

Tue, 07 June 2011 06:28

Eclipse User

in which program or where i have to add

"config.getAppContext().put("OdaJDBCDriverClassPath", " C:\\software\\oracle10gExpressEdition\\app\\oracle\\product\ \10.2.0\\server\\jdbc\\lib\\ojdbc14.jar ");"

Plz explain

Re: Newby to BIRT [message #677188 is a reply to message #677014]

Tue, 07 June 2011 12:43

Eclipse User

If you are using the RE API add it when you create the engine config.

eg

EngineConfig config = new EngineConfig();
config.getAppContext()......

If you are using the viewer you can add it to either the beforeFactory
script or the beforeOpen of the datasource. Just put it in like:

reportContext.getAppContext().put("OdaJDBCDriverClassPath",
"C:\\software\\oracle10gExpressEdition\\app\\oracle\\product\
\10.2.0\\server\\jdbc\\lib\\ojdbc14.jar");

Jason

On 6/7/2011 6:28 AM, jeyinul wrote:
> in which program or where i have to add
> "config.getAppContext().put("OdaJDBCDriverClassPath", "
> C:\\software\\oracle10gExpressEdition\\app\\oracle\\product\
> \10.2.0\\server\\jdbc\\lib\\ojdbc14.jar ");"
>
>
> Plz explain

Previous Topic:	Choosing the OS
Next Topic:	How to dynamically set the grouping range value for a table?

Goto Forum:

-=] Back to Top [=-

Current Time: Fri Jul 25 08:39:26 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter