Eclipse Community Forums: BIRT » Resultset problem using db2 with Eclipse BIRT

Help

Home

Home » Archived » BIRT » Resultset problem using db2 with Eclipse BIRT

Show: Today's Messages :: Show Polls :: Message Navigator

Resultset problem using db2 with Eclipse BIRT [message #516830]

Thu, 25 February 2010 10:03

prodigy

Messages: 1
Registered: February 2010

Junior Member

Hello,

I am using db2 as databse server with Eclipse BIRT for generating reports. (I have created db2inst1 as an instance).
I have successfully installed and added required db2 jar files for successful jdbc connection.

So I could create datasource without any problem too. But I failed to create dataset with the following error.

(P.S. - I have used simple select statement as : "select * from DB2INST1.APPLI_MAP" to get resultset. APPLI_MAP is some table)

A BIRT exception occurred.
Plug-in Provider:Eclipse.org
Plug-in Name:BIRT Data Engine
Plug-in ID:org.eclipse.birt.data
Version:2.5.1.v20090826
Error Code:odaconsumer.CannotGetResultSetMetaData
Error Message:Cannot get the result set metadata.
SQL statement does not return a ResultSet object.
SQL error #1: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=;;m DB2INST1.APPLI_MAP;END-OF-STATEMENT, DRIVER=3.50.152
SQL error #2: DB2 SQL Error: SQLCODE=-727, SQLSTATE=56098, SQLERRMC=2;-104;42601;;|m DB2INST1.APPLI_MAP|END-OF-STATEMENT, DRIVER=3.50.152
SQL error #3: DB2 SQL Error: SQLCODE=-727, SQLSTATE=56098, SQLERRMC=2;-104;42601;;|m DB2INST1.APPLI_MAP|END-OF-STATEMENT, DRIVER=3.50.152

I would be very thankful if anybody hepls me out in this issue.

Thanks,
prodigy..

Report message to a moderator