Eclipse Community Forums: BIRT » genReport on Linux using Oracle jdbc - Unable to open a connection with the database connection prof

Home » Archived » BIRT » genReport on Linux using Oracle jdbc - Unable to open a connection with the database connection prof

Show: Today's Messages :: Show Polls :: Message Navigator

genReport on Linux using Oracle jdbc - Unable to open a connection with the database connection prof [message #1833078]

Thu, 01 October 2020 19:03

R A

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

Report message to a moderator

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

rbaak Mising name

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.

Robert Baakel
https://www.youtube.com/playlist?list=PLht0txJzVxKFp1WRUOouv7rQfkCmLjVas

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 23:57:04 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter