Skip to main content

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]
[birt-dev] RE: birt-dev Digest, Vol 1, Issue 3

Hi Roshan,

Here are the details of my environment.

JDBC Driver: sun.jdbc.odbc.JdbcOdbcDriver(2.1). This is a thin driver
(my connection URL appears like this-

Query Text:
This is the query generated by the BIRT wizard. 


The query as you can see has no parameters. If I execute the same query
from the sql prompt(or from TOAD), then the query works fine and
displays the result.

Oracle version:

BIRT version:1.0 M1 (the build I download was birt-designer-1.0M1

Thanks much.

Message: 1
Date: Mon, 4 Apr 2005 12:10:15 -0700
From: "Roshan Ail" <rail@xxxxxxxxxxx>
Subject: RE: [birt-dev] BIRT  and Oracle
To: "For developers on the BIRT project" <birt-dev@xxxxxxxxxxx>
Content-Type: text/plain; charset="us-ascii"

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?









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? 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.


-------------- next part --------------
An HTML attachment was scrubbed...


Message: 2
Date: Tue, 5 Apr 2005 20:45:48 +0530
From: "Raghavan, Srinivasa" <sraghavan@xxxxxxxxxxxxxxx>
Subject: [birt-dev] Oracle+BIRT issues
To: <birt-dev@xxxxxxxxxxx>
Content-Type: text/plain; charset="us-ascii"

Skipped content of type multipart/alternative


birt-dev mailing list

End of birt-dev Digest, Vol 1, Issue 3

Back to the top