RE: [birt-dev] BIRT and Oracle

["Roshan Ail" <rail@xxxxxxxxxxx>]

Hi Raghavan,

 

Can you please provide more details about your environment?

I used the oracle thin driver and it worked for me.

Can you please provide the following?

 

1)       JDBC Driver

2)       Query Text

3)       Oracle version

4)       Do you have any parameters in the query?

5)       What build of BIRT are you using?

 

 

Thanks,

 

 

Roshan

 

---

From: birt-dev-bounces@xxxxxxxxxxx [mailto:birt-dev-bounces@xxxxxxxxxxx] On Behalf Of Raghavan, Srinivasa
Sent: Monday, April 04, 2005 8:31 AM
To: birt-dev@xxxxxxxxxxx
Subject: [birt-dev] BIRT and Oracle

 

Hi all,

 

I am trying to create a New Data Set with an Oracle connection. I have a successful Data Sources connection with Oracle. I have a really small table with just a department Id, departname and employee name. When I try to build a data set with this table, I am getting the below exception. Can some one throw some light on this?

 

org.eclipse.birt.data.engine.core.DataException occurred

Error Code:DATA_EXCEPTION_odaconsumer.CannotGetResultSetMetaData

  Error Code:DATA_EXCEPTION_odaconsumer.CannotGetResultSetMetaData

  Error Message:Cannot get the result set metadata.

  A JDBC Exception occured: ORA-01003: no statement parsed

 

  ORA-01003: no statement parsed

 

 

Thanks much.

Srini