Eclipse Community Forums: BIRT » DB2 connect blank

Home

Home » Archived » BIRT » DB2 connect blank(Using Data Explorer, DB2 connection is blank)

DB2 connect blank [message #1737261]

Wed, 06 July 2016 13:18

Eclipse User

I am using BIRT 4.3.1, with db2 11.1.0.
I can connect to the database, but everything under it is blank.
I used IBM Data Studio 4.1.2, this works.
How do I debug this issue?

Re: DB2 connect blank [message #1738838 is a reply to message #1737261]

Mon, 25 July 2016 06:55

Eclipse User

Hi Ed.

I use BIRT report design to create my reports.
To connect to DB2 databases I use jt400.jar drivers.

I just copy Jt400.jar file to the ...eclipse\plugins\org.eclipse.birt.report.data.oda.jdbc_...\drivers directory and works fine.

To create the data source connection right click Data Sources and select New Data Source in the Data Explorer Tab.

In driver class select com.ibm.as400.access.AS400JDBCDriver (v9.9)
Database URL: jdbc:as400:<server_ip>/<database>
User name: <your username to connect the database>
Password: <your password to connect the database>

Click test connection to verify if the connection it's ok.

I hope it helps.

Previous Topic:	Related Cascade Parameters
Next Topic:	BIRT on AIX

Goto Forum:

-=] Back to Top [=-

Current Time: Thu Jul 03 07:01:32 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter