Skip to main content



      Home
Home » Archived » BIRT » BIRT and DB2
BIRT and DB2 [message #26036] Tue, 12 April 2005 05:54 Go to next message
Eclipse UserFriend
Originally posted by: jambu.profitera.com

Hi everyone,

I have a major crisis here that I couldn't fix at all. I'm running BIRT
to connect to DB2 v8.1 Fixpack 7, using db2jcc driver version 2.3. I have
placed my db2jcc.jar and db2jcc_license_cu.jar into the directory
org.eclipse.birt.report.data.oda.jdbc_0.0.1 in eclipse plugin directory.

I could add datasource using the driver, and tested the connection to my
database, the test was successful. And then I go ahead to create a
dataset. My dataset is very simple where it just selects all the rows of
a small table (about 20 rows). I click on all the option at left panel of
Edit Data Set form, options such as Computed Columns, Parameters, Output
Columns and Preview Results. They all seem to be fine, and Preview
Results returned me the rows from the table.

Now, I click OK, and I right click on my dataset in data explorer, I
choose insert in layout option from the menu. All the fields of my
dataset is not in the report design page.

I click on the tab preview, it takes about 10 seconds, and all that I get
is an empty report with only the headers.

I've tested my BIRT with the sample report given in tutorial, which uses
sfdata access db, it works fine, I even created my own simple report
accessing the same sfdata access db and it works fine.

So whats wrong with this DB BIRT combination? Please help.
Re: BIRT and DB2 [message #26077 is a reply to message #26036] Tue, 12 April 2005 06:01 Go to previous messageGo to next message
Eclipse UserFriend
> I click on the tab preview, it takes about 10 seconds, and all that I
> get is an empty report with only the headers.

This problem has come up a few times recently and really needs to go in
the FAQ.

The report viewer (which runs when you hit Preview) has a separate
classpath and so needs the driver jars too. As Roshan pointed out in an
earlier message:

"... copy the jdbc driver jars and the odaconfig.xml into the
eclipse/plugins/org.eclipse.birt.report.viewer_0.0.1/birt-vi ewer/WEB-INF/plugins/drivers
folder"

Hope this helps,

Rich
Re: BIRT and DB2 [message #26116 is a reply to message #26077] Tue, 12 April 2005 06:57 Go to previous message
Eclipse UserFriend
Originally posted by: jambu.profitera.com

works now.. thanks
Previous Topic:Oracle Driver
Next Topic:Missing build.xml in org.eclipse.birt.data
Goto Forum:
  


Current Time: Fri Jun 06 21:44:59 EDT 2025

Powered by FUDForum. Page generated in 0.03868 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top