Data connection

Hi,

I'm trying out the Actuate components. I have existing reports that work fine in the Birt viewer. When I view them with the reports studio or with the deployment kit all I see are my reports without any data.

I copied my report in the WEB-INFrepositoryPublic folder. Do I need to make changes to my existing report? The xml in my report to connect to my existing database looks like this:

<data-sources>
<oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc" name="XXXX" id="45">
<property name="odaDriverClass">com.mysql.jdbc.Driver</property>
<property name="odaURL">jdbc:mysql://xxxxx.aaaa.vvv/</property>
<property name="odaUser">report</property>
<encrypted-property name="odaPassword" encryptionID="base64">m</encrypted-property>
</oda-data-source>
</data-sources>

Can anyone help? I thought no changes were needed...

thanks

Find more posts tagged with

Comments

rmurphy

There are not any changes to the report required. What app server have you deployed the components to? Please check the app servers log files as well as the Report Engine log files. The report engine logs information into the context/logs directory (i.e. ActuateJavaComponent/logs).

Rob

Virgil Dodson

You might have already done this... but you also have to make sure that you have deployed your database JDBC drivers correctly.. This URL may help <a class='bbc_url' href='http://www.birt-exchange.org/devshare/deploying-birt-reports/169-placing-jdbc-drivers-for-birt-and-e-spreadsheet-reports/#description'>Placing JDBC drivers for BIRT and e.Spreadsheet Reports - Tips & Tricks - BIRT Exchange</a>