Eclipse Community Forums: BIRT » Error1:Cannot open connection (jdbc) in Report Design /Preview

Home » Archived » BIRT » Error1:Cannot open connection (jdbc) in Report Design /Preview

Error1:Cannot open connection (jdbc) in Report Design /Preview [message #46008]

Tue, 14 June 2005 19:46

Eclipse User

Originally posted by: skr1.charter.net

When I use the Report Design /Preview tab to view a very simple report I get
no data and the following error in the report:

There are errors on the report page:
Error1:Cannot open the connection for the driver (jdbc).

The report Data Source is using an oracle.jdbc.driver.OracleDriver (1.0)
driver class from
....\eclipse\plugins\org.eclipse.birt.report.data.oda.jdbc_0 .0.1\drivers\ojdbc14.jar
to connect to an Oracle 8.1.7 database.

Edit Data Source /Test Connection returns "Connection Successful".

Edit Data Set /Query shows all database tables and table columns. I dragged
the table columns into the Select clause and tables into to the From clause
in the query from the Available Items.

Edit Data Set /Preview Results returns the correct results set.

Could someone help get me past this error?

Thanks,
- Steve

Re: Error1:Cannot open connection (jdbc) in Report Design /Preview [message #46173 is a reply to message #46008]

Wed, 15 June 2005 03:28

Eclipse User

Originally posted by: juergen.schwarz.gefasoft.de

Check that the .jar files (ojdbc14.jar) for your JDBC driver are also
present in the directory:

\eclipse\plugins\org.eclipse.birt.report.viewer_1.0.0\birt\W EB-INF\plugins\org.eclipse.birt.report.data.oda.jdbc\drivers

If not, copy it to this location. The Preview uses that directory while
the DataSet/Query uses another location...

Steve Roffler schrieb:
> When I use the Report Design /Preview tab to view a very simple report I get
> no data and the following error in the report:
>
> There are errors on the report page:
> Error1:Cannot open the connection for the driver (jdbc).
>
> The report Data Source is using an oracle.jdbc.driver.OracleDriver (1.0)
> driver class from
> ...\eclipse\plugins\org.eclipse.birt.report.data.oda.jdbc_0. 0.1\drivers\ojdbc14.jar
> to connect to an Oracle 8.1.7 database.
>
> Edit Data Source /Test Connection returns "Connection Successful".
>
> Edit Data Set /Query shows all database tables and table columns. I dragged
> the table columns into the Select clause and tables into to the From clause
> in the query from the Available Items.
>
> Edit Data Set /Preview Results returns the correct results set.
>
> Could someone help get me past this error?
>
> Thanks,
> - Steve
>
>

Re: Error1:Cannot open connection (jdbc) in Report Design /Preview [message #46904 is a reply to message #46173]

Wed, 15 June 2005 23:24

Eclipse User

Originally posted by: skr1.charter.net

That fixes it. Thank you.

"Juergen Schwarz" <juergen.schwarz@gefasoft.de> wrote in message
news:d8olbp$s90$1@news.eclipse.org...
> Check that the .jar files (ojdbc14.jar) for your JDBC driver are also
> present in the directory:
>
> \eclipse\plugins\org.eclipse.birt.report.viewer_1.0.0\birt\W EB-INF\plugins\org.eclipse.birt.report.data.oda.jdbc\drivers
>
> If not, copy it to this location. The Preview uses that directory while
> the DataSet/Query uses another location...
>
>
>
>
> Steve Roffler schrieb:
>> When I use the Report Design /Preview tab to view a very simple report I
>> get
>> no data and the following error in the report:
>>
>> There are errors on the report page:
>> Error1:Cannot open the connection for the driver (jdbc).
>>
>> The report Data Source is using an oracle.jdbc.driver.OracleDriver (1.0)
>> driver class from
>> ...\eclipse\plugins\org.eclipse.birt.report.data.oda.jdbc_0. 0.1\drivers\ojdbc14.jar
>> to connect to an Oracle 8.1.7 database.
>>
>> Edit Data Source /Test Connection returns "Connection Successful".
>>
>> Edit Data Set /Query shows all database tables and table columns. I
>> dragged
>> the table columns into the Select clause and tables into to the From
>> clause
>> in the query from the Available Items.
>>
>> Edit Data Set /Preview Results returns the correct results set.
>>
>> Could someone help get me past this error?
>>
>> Thanks,
>> - Steve
>>
>>

Previous Topic:	memroy leak not detected/memory profiler stopping?
Next Topic:	BIRT Integration

Goto Forum:

-=] Back to Top [=-

Current Time: Thu Jun 12 04:27:31 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter