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

["Roshan Ail" <rail@xxxxxxxxxxx>]

Hi Raghavan,

I just noticed something.
You are using the jdbc odbc driver.
This works with a odbc bridge. For the thin driver you need the oracle
thin driver in your class path.

Refer to the following newsgroup thread for information on configuring
jdbc drivers

http://www.eclipse.org/newsportal/article.php?id=232&group=eclipse.birt#
232


Please note.
The newsgroup is the best place to find information.
It already has a lot of information in it.


Thanks,


Roshan


-----Original Message-----
From: birt-dev-bounces@xxxxxxxxxxx [mailto:birt-dev-bounces@xxxxxxxxxxx]
On Behalf Of Roshan Ail
Sent: Wednesday, April 06, 2005 10:54 AM
To: For developers on the BIRT project
Subject: RE: [birt-dev] RE: birt-dev Digest, Vol 1, Issue 3

Hi Raghavan,

We have fixed a number of issues with data sets since the milestone
release.
Please download the latest stable build and try it.

Please note:
For future reference, this dev mailing list is typically used for
discussions from BIRT Committers rather than questions about using BIRT.
Questions around using BIRT are best answered via the newsgroup.


Thanks,


Roshan

-----Original Message-----
From: birt-dev-bounces@xxxxxxxxxxx [mailto:birt-dev-bounces@xxxxxxxxxxx]
On Behalf Of Raghavan, Srinivasa
Sent: Tuesday, April 05, 2005 9:25 PM
To: birt-dev@xxxxxxxxxxx
Subject: [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-
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
**************************************

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