Problem in Joint dataset + Hibernate query !!!!!!!!!!!!!!

ganesh1984

Hi All,

I am getting issues when i tried to use joint Data set with Hibernate Query.

I am using Hibernate data source. I have got all hibernate related plugins. I am able to generate most of my reports. But got stuck when i tried to use Joint Data Set.

I have created two data sets .

First data set returns records with four columns. Two columns are integer. one column is Float and one is String.

second data set returns records with three columns . Two columns are Integer and one is Float.

I am using a common column of both the tables as 'KEY'. when i try to see preview results i am getting exception as follows.

Exception :
A BIRT exception occurred.
Plug-in Provider:Eclipse.org
Plug-in Name:BIRT Data Engine
Plug-in ID:org.eclipse.birt.data
Version:2.3.2.r232_v20090211
Error Code:odaconsumer.CannotGetStringFromColumn
Error Message:Cannot get the string value from column: 4.
3

If i remove String column it works fine. I am getting records. But I am getting different problem there. Actually I am not at all seeing the columns of first table. Columns of second table is overlapping the first. I am getting the columns of second table twice.

I should get records with seven columns. three columns from First table and three columns from second column. but three columns of second table are overlapping first.

It works fine for native SQL. But It's not supporting for HQL(Hibernate query)
is this a Bug?.
any help is appreciated.

regards,
ganesh