connection profile problem

purushdk

Hi

I am using birt 2.3.

i have created connection profile jdbc connection

whenever create data source using connection profile.

in reptdesign xml

below content is displaying.

<data-sources>
<script-data-source name="emp_ret" id="24"/>
<oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc" name="manavreports" id="157">
<property name="odaDriverClass">org.gjt.mm.mysql.Driver</property>
<property name="odaURL">jdbc:mysql://localhost:3306/manavsofter</property>
<property name="odaUser">root</property>
<encrypted-property name="odaPassword" encryptionID="base64">cGFzc3dvcmQ=</encrypted-property>
<property name="OdaConnProfileName">manavreports</property>
<property name="OdaConnProfileStorePath">/home/manavsoft/workspace/manavreportstrunk/WebContent/WEB-INF/jdbcconnection.xml</property>
</oda-data-source>
</data-sources>

its working fine in local machine but while deploying production server i am geeting error like
no connection profile found manavreports

please provide details about each note like

<property name="OdaConnProfileStorePath">/home/manavsoft/workspace/manavreportstrunk/WebContent/WEB-INF/jdbcconnection.xml</property>

Thanks & Regards,
k.purushothaman

Virgil Dodson

Hi k.purushothaman,

When you created your connection profile store, a file was created at
/home/manavsoft/workspace/manavreportstrunk/WebContent/WEB-INF/jdbcconnection.xml on your local machine. You will need to place that file in the same location on the server. You can also use the property binding tab on your Data Source in the designer to pass in the location using a parameter.