Externalise configuration of the 'alfrescoReportingDatabaseHelper' bean

[GoogleCodeExporter]

Hi,

It would be great if the parameters of the 'alfrescoReportingDatabaseHelper' 
bean could be externalise into a properties file.

It would be appreciate to be able to override 'database', 'username' and 
'password' directly from alfresco-global.properties file.

Regards.

Original issue reported on code.google.com by Bertrand...@gmail.com on 16 Apr 2013 at 10:12

[GoogleCodeExporter]

Hi Bertrand,

That would be, if there was only 1 environment. However, I develop reports 
against another environment (db, credentials) than Test, Acceptance and 
Production. When executing the report, the report definition must know these 
credentials. You don't want to update your report definition when moving from 
DEV to TEST etc. Therefore I decided to go JNDI. And yes, that requires 
changing alfresco.xml... But hey, it is an Enterprise tool...

I am in process of migrating to MyBatis for the reportingdatabase connection 
and queries. Perhaps this feature will return...
(it was there in the past. I would'n be surprised if it still works (not 
tested, no support nor guarentee:
#reporting.db.name=alfrescoreporting
#reporting.db.username=alfresco
#reporting.db.password=a1fresco
#reporting.db.host=localhost
#reporting.db.port=3306
#reporting.db.driver=org.gjt.mm.mysql.Driver
#reporting.db.url=jdbc:mysql://${reporting.db.host}:${reporting.db.port}/${repor
ting.db.name}

Original comment by tjarda.p...@incentro.com on 16 Apr 2013 at 1:50

• Changed state: WontFix