How to use JBoss datasource?

basti

Hi,

I'm now have some reports which work perfectly fine (thanks for your help), but just localy. The datasource is hardcoded in the rpt files with kind of encrypted password. But now, I want to deploy those files to a server, where the PostgreSQL database has a different password.

On the new Server there is a PostgreSQL datasource configured which is in use by some other apps. Now I would like to point the rpt files on the server to that datasource so the reports can be used on different machines without changing the user and password all the time. But unfortunately I didn't find anything about it.

Any hints are appreciated.

Thanks for you help and best regards,
Sebastian

bhanley

You can parameterize the report data source parameters. In the designer double-click the data source to edit it. Look at the functional groupings along the left of the editor. The last one deals with parameterization. If you create a hidden report parameter to hold the password you can bind that parameter to the matching data source property. Then when you invoke the report you can pass in whatever you need to to target the data source for the given environment.

You can also choose to use JNDI or connection profile stores if the parameter option cannot work for you. Check the Blogs, DevShare and the Wiki if you want more background on those options.

For initial development, the parameter option gives you the most flexibility and almost no setup time.

Good Luck!