genReport on Linux using Oracle jdbc - Unable to open a connection with the database connection prof [message #1833078] |
Thu, 01 October 2020 19:03  |
Eclipse User |
|
|
|
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
|
|
|
|
Powered by
FUDForum. Page generated in 0.02766 seconds