how to connect IBM Cloudscape v5.1 in BIRT

TurCo

Hi ,

I want to generate report from Tivoli Provisioning Manager Express. It uses IBM Cloudscape V5.1 database.

Therefore, in BIRT i need to connect to this database. But i couldn't do this.

First i added driver. (com.ibm.db2j.jdbc.DB2jDriver (v5.1) (db2j.jar))

then
added the url : ( jdbc:db2j:net://****.****.****/tpmxdb )

But i got these following errors.
Do you have any idea about this.

org.eclipse.birt.report.data.oda.jdbc.JDBCException: There is an error in get connection, java.lang.reflect.InvocationTargetException : Error opening socket to server /9.172.126.15 on port 1527 with message : null DB2ConnectionCorrelator: null.
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.doConnect(JDBCDriverManager.java:211)
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getConnection(JDBCDriverManager.java:142)
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.tryCreateConnection(JDBCDriverManager.java:643)
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.testConnection(JDBCDriverManager.java:571)
at org.eclipse.birt.report.data.oda.jdbc.ui.util.DriverLoader.testConnection(DriverLoader.java:118)
at org.eclipse.birt.report.data.oda.jdbc.ui.profile.JDBCSelectionPageHelper.testConnection(JDBCSelectionPageHelper.java:635)
at org.eclipse.birt.report.data.oda.jdbc.ui.profile.JDBCSelectionPageHelper.access$7(JDBCSelectionPageHelper.java:619)
at org.eclipse.birt.report.data.oda.jdbc.ui.profile.JDBCSelectionPageHelper$7.widgetSelected(JDBCSelectionPageHelper.java:541)
at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:228)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1003)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3823)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3422)
at org.eclipse.jface.window.Window.runEventLoop(Window.java:825)