Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » DB2 connect blank(Using Data Explorer, DB2 connection is blank)
icon4.gif  DB2 connect blank [message #1737261] Wed, 06 July 2016 17:18 Go to next message
Ed Overton is currently offline Ed OvertonFriend
Messages: 1
Registered: July 2016
Junior Member
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 10:55 Go to previous message
Ricardo Paz is currently offline Ricardo PazFriend
Messages: 2
Registered: July 2016
Junior Member
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:
  


Current Time: Sat Aug 08 15:10:40 GMT 2020

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

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

Back to the top