Error with Oracle drivers on preview [message #63914] |
Wed, 03 August 2005 07:56  |
Eclipse User |
|
|
|
Originally posted by: ejemba.free.fr
Hi all,
I have a problem that seems simple with a connection with oracle9i.
When setting up the Datasource, I specify the jar of the driver
ojdbc14.jar and I have no problem the connection test was successfull.
The jar is well present here
<eclipse_path> \plugins\org.eclipse.birt.report.data.oda.jdbc_1.0.1\drivers \
And then the Dataset there was no problem. I specify my request and I
was able to preview it
select
PROD_CDB.ACTION.ACTION_KEY ,
PROD_CDB.ACTION.PRESENTATION_RESOURCE_NAME ,
PROD_CDB.ACTION.SHOW_ACTION_CLASS_NAME
from PROD_CDB.ACTION
Then I create a simple a new Report ("Etat" in french) but when trying a
simple preview, it cannot be generated, and I have this message :
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
La page d'état comporte des erreurs :
- There are error(s) in Table:table1
Error0 : odaconsumer.CannotOpenConnection(1 time)detail: Impossible
détablir la connexion pour le pilote ({0}).Impossible de charger la
classe de pilote JDBC : [oracle.jdbc.driver.OracleDriver]. Impossible de
charger la classe de pilote JDBC : [oracle.jdbc.driver.OracleDriver].
- - - - - - - - - in english - - - - - - - - -
La page d'état comporte des erreurs :
- There are error(s) in Table:table1
Error0 : odaconsumer.CannotOpenConnection(1 time)detail: Impossible to
establish the connection for the pilot ({0}).Impossible to load the JDBC
class : [oracle.jdbc.driver.OracleDriver]. Impossible to load the JDBC
class : [oracle.jdbc.driver.OracleDriver].
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Perhaps I miss a step.
May someone can help me?
Thank you
Epo
|
|
|
Re: Error with Oracle drivers on preview [message #64059 is a reply to message #63914] |
Wed, 03 August 2005 10:46  |
Eclipse User |
|
|
|
Originally posted by: rajagopal.xxxxx.com
Epo wrote:
> Hi all,
> I have a problem that seems simple with a connection with oracle9i.
> When setting up the Datasource, I specify the jar of the driver
> ojdbc14.jar and I have no problem the connection test was successfull.
> The jar is well present here
> <eclipse_path>pluginsorg.eclipse.birt.report.data.oda.jdbc_1.0.1drivers
> And then the Dataset there was no problem. I specify my request and I
> was able to preview it
> select
> PROD_CDB.ACTION.ACTION_KEY ,
> PROD_CDB.ACTION.PRESENTATION_RESOURCE_NAME ,
> PROD_CDB.ACTION.SHOW_ACTION_CLASS_NAME
> from PROD_CDB.ACTION
> Then I create a simple a new Report ("Etat" in french) but when trying a
> simple preview, it cannot be generated, and I have this message :
> - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
> La page d'état comporte des erreurs :
> - There are error(s) in Table:table1
> Error0 : odaconsumer.CannotOpenConnection(1 time)detail: Impossible
> détablir la connexion pour le pilote ({0}).Impossible de charger la
> classe de pilote JDBC : [oracle.jdbc.driver.OracleDriver]. Impossible de
> charger la classe de pilote JDBC : [oracle.jdbc.driver.OracleDriver].
> - - - - - - - - - in english - - - - - - - - -
> La page d'état comporte des erreurs :
> - There are error(s) in Table:table1
> Error0 : odaconsumer.CannotOpenConnection(1 time)detail: Impossible to
> establish the connection for the pilot ({0}).Impossible to load the JDBC
> class : [oracle.jdbc.driver.OracleDriver]. Impossible to load the JDBC
> class : [oracle.jdbc.driver.OracleDriver].
> - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
> Perhaps I miss a step.
> May someone can help me?
> Thank you
> Epo
There is an issue with Eclipse copying the drivers only to the jdbc of the
plugins and not to the jdbc location in the viewer.
You need to manually copy the Oracle driver to
<eclipse
install> \plugins\org.eclipse.birt.report.viewer_1.0.1\plugins\org.ec lipse.birt.report.data.oda.jdbc\drivers
folder (if you are using birt 1.0, then the plugins folder of the viewer
is under WEB_INF sub directory.
|
|
|
Powered by
FUDForum. Page generated in 0.03757 seconds