Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » genReport on Linux using Oracle jdbc - Unable to open a connection with the database connection prof
genReport on Linux using Oracle jdbc - Unable to open a connection with the database connection prof [message #1833078] Thu, 01 October 2020 19:03 Go to next message
R A is currently offline R AFriend
Messages: 1
Registered: October 2020
Junior Member
Hello,

My team has created a number of BIRT (running on v4.8) reports that work when executed from Eclipse. These reports query our database.

When we take the rptdesign files to our Linux environment, and run genReport.sh with the following command:

genReport.sh -f pdf -o samples/TestSample.pdf samples/Test.rptdesign

When this job is run, we get a openConnection failure but am unsure what is wrong in our data-sources set up. Any ideas?

Exception thrown:

Oct 01, 2020 6:34:04 PM org.eclipse.birt.data.engine.odaconsumer.ConnectionManager openConnection
SEVERE: Unable to open connection.
org.eclipse.datatools.connectivity.oda.OdaException: Unable to open a connection with the database connection profile.
at org.eclipse.birt.report.data.oda.jdbc.dbprofile.impl.Connection.open(Connection.java:84)
at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaConnection.open(OdaConnection.java:250)
.
.
.
Oct 01, 2020 6:34:04 PM org.eclipse.birt.report.engine.executor.ExtendedGenerateExecutor execute
SEVERE: An exception occurred during processing. Please see the following message for details:
Cannot open the connection for the driver: org.eclipse.birt.report.data.oda.jdbc.dbprofile.
org.eclipse.datatools.connectivity.oda.OdaException: Unable to open a connection with the database connection profile.
org.eclipse.birt.report.data.adapter.api.AdapterException: An exception occurred during processing. Please see the following message for details:
Cannot open the connection for the driver: org.eclipse.birt.report.data.oda.jdbc.dbprofile.
org.eclipse.datatools.connectivity.oda.OdaException: Unable to open a connection with the database connection profile.
at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:672)

My data-sources looks like this, with some edits to actual names/URLs. I've tried using the ojdbc7.jar and ojdbc.8.jar and get the same error.

<data-sources>
<oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc.dbprofile" name="TEST-DS" id="4"
extends="OP_Library.TEST-DS">
<property name="databaseName">TEST1</property>
<property name="username">TESTUSER1</property>
<encrypted-property name="password" encryptionID="base64">xxxxxxxxxxxxxxxxxxxxxxxxxxx</encrypted-property>
<property name="URL">jdbc:oracle:thin:@10.10.10.10:1867:TEST1</property>
<property name="driverClass">oracle.jdbc.OracleDriver</property>
<property name="jarList">/PATH/TO/JARFILE/ojdbc7.jar</property>
</oda-data-source>
</data-sources>

Thank you,
RA
Re: genReport on Linux using Oracle jdbc - Unable to open a connection with the database connection [message #1833966 is a reply to message #1833078] Thu, 29 October 2020 00:48 Go to previous message
rbaak Mising name is currently offline rbaak Mising nameFriend
Messages: 31
Registered: July 2009
Member
Try changing your data source Driver Class in your report. There should be a driver option that is more specific to the version of Oracle you are using.

Previous Topic:New Page Output per unique ID/Column
Next Topic:Costing for BIRT Reporting
Goto Forum:
  


Current Time: Tue Sep 28 20:54:54 GMT 2021

Powered by FUDForum. Page generated in 0.01507 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top