[birt-dev] RE: birt-dev Digest, Vol 1, Issue 3

["Raghavan, Srinivasa" <sraghavan@xxxxxxxxxxxxxxx>]

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-
jdbc:oracle:thin:@<hostname>:<port>:<SID>

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

SELECT "SRINI"."BIRTTABLE"."ID",
"SRINI"."BIRTTABLE"."NAME",
"SRINI"."BIRTTABLE"."DEPARTMENTID" 
FROM "SRINI"."BIRTTABLE"  

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: 9.2.0.1

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

Thanks much.
Srini


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>
Message-ID:
	<21E318EED90BEE42BDA27AC8FED5D28003B2FB86@xxxxxxxxxxxxxxxxxxxxx>
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?

 

 

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://eclipse.org/pipermail/birt-dev/attachments/20050404/245852af/atta
chment-0001.html

------------------------------

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>
Message-ID:
	
<763587D019086647ADB989804A89D097789DB5@xxxxxxxxxxxxxxxxxxxxxxxx>
Content-Type: text/plain; charset="us-ascii"

Skipped content of type multipart/alternative

------------------------------

_______________________________________________
birt-dev mailing list
birt-dev@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/birt-dev


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