Eclipse Community Forums: BIRT

Home » Archived » BIRT » Oracle Driver

Fri, 01 April 2005 03:58

Eclipse User

Originally posted by: thierry.legrand.olympus.fr

*Data Source:
no problem to declare a new data source on a Oracle.

*Data Sets:
-when I edit a DataSet linked to an odbc bridge data source, I everytime
receive the message below but the dataSet works and is available to fill a
report.
org.eclipse.jface.text.Assert$AssertionFailedException occurred
Assertion failed:

-with Data Set linked to an Oracle data source, I receive the message
below and the data set is not operational:

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: statement handle not executed: getMetaData
statement handle not executed: getMetaData

Do you have any suggestions to make Data Set operational with oracle
datasources ?

Is it reasonnable to continue to test BIRT with Oracle or should I better
wait for a new BIRT release ?

Re: Oracle Driver [message #24732 is a reply to message #24323]

Mon, 04 April 2005 16:09

Eclipse User

Hi Thierry,

Can you please provide more details about your environment, and how to
reproduce the problem? We tried with an Oracle type 4 JDBC driver, and
could not reproduce it.
Please also provide the following:

1) JDBC Driver info and which jar files are specified in the
odaconfig.xml
2) Query Text
3) Oracle version
4) Do you have any parameters in the query?
5) Which BIRT build are you using?

Please also submit an entry in Buzilla for tracking purpose. Thanks.

Linda
BIRT Data Engine team lead

Re: Oracle Driver [message #24770 is a reply to message #24732]

Mon, 04 April 2005 17:19

Eclipse User

Linda Chan wrote:

> Hi Thierry,

> Can you please provide more details about your environment, and how to
> reproduce the problem? We tried with an Oracle type 4 JDBC driver, and
> could not reproduce it.

I had the same problem but then I changed drivers. Looks like this issue
pops up when you use the older classes12.zip driver. I did not have any
connection troubles when I used the new ojdbc14.jar driver.

jaaron

Re: Oracle Driver [message #24804 is a reply to message #24732]

Tue, 05 April 2005 03:34

Eclipse User

Originally posted by: thierry.legrand.olympus.fr

Hi,

1) I use ojdbc14.jar driver

2) I tested with the simpliest query I can do but I get same error:
SELECT "MVXSECOFR"."ZTEST"."COLUMN1"
FROM "MVXSECOFR"."ZTEST"

3) Oracle 9i

4) no parameter

5)Development Build 02-28-2005

Thank you for your help.

Re: Oracle Driver - Problem Solved with latest release [message #24838 is a reply to message #24804]

Tue, 05 April 2005 05:02

Eclipse User

Originally posted by: thierry.legrand.olympus.fr

I downloaded and installed the S20050404 release and now my test queries
on Oracle are OK. I can see my data in the Preview Results panel. Great !

BUT when I preview my report , I don't see any data. the page is filled
with column headings only.

Unfortunately I don't receive any error message during report filling.

Re: Oracle Driver [message #24870 is a reply to message #24770]

Tue, 05 April 2005 09:35

Eclipse User

The classes12.jar drivers are for use with jdk 1.2 and 1.3 - the ojdbc14.jar
drivers are for use with jdk 1.4.

"J Aaron Farr" <farra@apache.org> wrote in message
news:6fa40c77581f5476837163ed0562229f$1@www.eclipse.org...
> Linda Chan wrote:
>
> > Hi Thierry,
>
> > Can you please provide more details about your environment, and how to
> > reproduce the problem? We tried with an Oracle type 4 JDBC driver, and
> > could not reproduce it.
>
> I had the same problem but then I changed drivers. Looks like this issue
> pops up when you use the older classes12.zip driver. I did not have any
> connection troubles when I used the new ojdbc14.jar driver.
>
> jaaron
>

Re: Oracle Driver - Problem Solved with latest release [message #24899 is a reply to message #24838]

Tue, 05 April 2005 09:45

Eclipse User

Thierry LEGRAND wrote:
> I downloaded and installed the S20050404 release and now my test queries
> on Oracle are OK. I can see my data in the Preview Results panel. Great !
> BUT when I preview my report , I don't see any data. the page is filled
> with column headings only.
> Unfortunately I don't receive any error message during report filling.

This is exactly the behaviour that I reported in an earlier message
"Missing data in reports in S20050328".

Unfortuntately, I've got a project deadline coming up so haven't got any
time to spend looking into this till next week. But it looks like the
problem affects PostgreSQL as well as Oracle.

Rich

Re: Oracle Driver - Problem Solved with latest release [message #25347 is a reply to message #24899]

Thu, 07 April 2005 18:46

Eclipse User

Hi Rich.

Did you copy the jdbc driver jars and the odaconfig.xml into the
eclipse/plugins/org.eclipse.birt.report.viewer_0.0.1/birt-vi ewer/WEB-INF/plugins/drivers
folder.
The viewer runs in a separate process as it is a web application under
tomcat.
You will need to make a copy of the files under the viewer as well.

Roshan

Rich Aston wrote:
> Thierry LEGRAND wrote:
>
>> I downloaded and installed the S20050404 release and now my test
>> queries on Oracle are OK. I can see my data in the Preview Results
>> panel. Great !
>> BUT when I preview my report , I don't see any data. the page is
>> filled with column headings only.
>> Unfortunately I don't receive any error message during report filling.
>
>
> This is exactly the behaviour that I reported in an earlier message
> "Missing data in reports in S20050328".
>
> Unfortuntately, I've got a project deadline coming up so haven't got any
> time to spend looking into this till next week. But it looks like the
> problem affects PostgreSQL as well as Oracle.
>
> Rich

Re: Oracle Driver - Problem Solved with latest release [message #25432 is a reply to message #25347]

Fri, 08 April 2005 06:59

Eclipse User

Roshan,

> Did you copy the jdbc driver jars and the odaconfig.xml into the
> eclipse/plugins/org.eclipse.birt.report.viewer_0.0.1/birt-vi ewer/WEB-INF/plugins/drivers
> folder.

Thanks. I have just had a chance to try this and it works perfectly.

I think that this information really needs to be added to the JDBC
section at the bottom of this page:

http://www.eclipse.org/birt/index.php?page=build/install.htm l

Cheers

Rich

> Rich Aston wrote:
>
>> Thierry LEGRAND wrote:
>>
>>> I downloaded and installed the S20050404 release and now my test
>>> queries on Oracle are OK. I can see my data in the Preview Results
>>> panel. Great !
>>> BUT when I preview my report , I don't see any data. the page is
>>> filled with column headings only.
>>> Unfortunately I don't receive any error message during report filling.
>>
>>
>>
>> This is exactly the behaviour that I reported in an earlier message
>> "Missing data in reports in S20050328".
>>
>> Unfortuntately, I've got a project deadline coming up so haven't got
>> any time to spend looking into this till next week. But it looks like
>> the problem affects PostgreSQL as well as Oracle.
>>
>> Rich

Re: Oracle Driver - Problem Solved with latest release [message #25834 is a reply to message #24899]

Mon, 11 April 2005 19:29

Eclipse User

Rich & Others,

I tested out the issue of the engine not reporting DB errors. This does
indeed occur. I've asked the development team to implement error reporting
for such cases so we have a bit more info to help track down problems.

- Paul

Paul Rogers
BIRT PMC

"Rich Aston" <rich@othermedia.com> wrote in message
news:d2u4vg$2kr$1@news.eclipse.org...
> Thierry LEGRAND wrote:
>> I downloaded and installed the S20050404 release and now my test queries
>> on Oracle are OK. I can see my data in the Preview Results panel. Great !
>> BUT when I preview my report , I don't see any data. the page is filled
>> with column headings only.
>> Unfortunately I don't receive any error message during report filling.
>
> This is exactly the behaviour that I reported in an earlier message
> "Missing data in reports in S20050328".
>
> Unfortuntately, I've got a project deadline coming up so haven't got any
> time to spend looking into this till next week. But it looks like the
> problem affects PostgreSQL as well as Oracle.
>
> Rich

Re: Oracle Driver - Problem Solved with latest release [message #25995 is a reply to message #25432]

Tue, 12 April 2005 02:23

Eclipse User

Rich,

I've added the information to the install page as you suggested.

- Paul

Paul Rogers
BIRT PMC

"Rich Aston" <rich@othermedia.com> wrote in message
news:d35oem$dov$1@news.eclipse.org...
> Roshan,
>
>> Did you copy the jdbc driver jars and the odaconfig.xml into the
>> eclipse/plugins/org.eclipse.birt.report.viewer_0.0.1/birt-vi ewer/WEB-INF/plugins/drivers
>> folder.
>
> Thanks. I have just had a chance to try this and it works perfectly.
>
> I think that this information really needs to be added to the JDBC section
> at the bottom of this page:
>
> http://www.eclipse.org/birt/index.php?page=build/install.htm l
>
> Cheers
>
> Rich
>
>
>
>
>> Rich Aston wrote:
>>
>>> Thierry LEGRAND wrote:
>>>
>>>> I downloaded and installed the S20050404 release and now my test
>>>> queries on Oracle are OK. I can see my data in the Preview Results
>>>> panel. Great !
>>>> BUT when I preview my report , I don't see any data. the page is filled
>>>> with column headings only.
>>>> Unfortunately I don't receive any error message during report filling.
>>>
>>>
>>>
>>> This is exactly the behaviour that I reported in an earlier message
>>> "Missing data in reports in S20050328".
>>>
>>> Unfortuntately, I've got a project deadline coming up so haven't got any
>>> time to spend looking into this till next week. But it looks like the
>>> problem affects PostgreSQL as well as Oracle.
>>>
>>> Rich

Previous Topic:	ODA for search engine
Next Topic:	BIRT and DB2

Goto Forum:

-=] Back to Top [=-

Current Time: Wed Mar 12 06:56:53 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter