search

xornand / alfresco-business-reporting

Automatically exported from code.google.com/p/alfresco-business-reporting
0 stars 0 forks source link

Does the reporting add-on support PostgreSQL? #4

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago 
Does the reporting add-on support PostgreSQL?

I used it to install with the base software installation.

I'm running into similar issues as other users that it's not creating the 
tables in the postgres alfrescoreporting database.

Original issue reported on code.google.com by lebla...@gmail.com on 25 Oct 2012 at 1:26

GoogleCodeExporter commented 8 years ago 
It is NOT supported on Postgres. See 
http://tpeelen.wordpress.com/2013/02/23/alfresco-business-reporting-alive-and-ki
cking/

It will be, somewhere soon. Actually, I am in process of getting it in. The 
trick is that I needed to include a framework that allows 
multi-vendor-databases in an easy manner, and work around the lack of Postgres 
before version 9.1 that does not support the syntax CREATE TABLE IF NOT EXIST 
$tablename. 

Both have been solved technically by usng MyBatis (like Alfresco itself does) 
and injecting some stored procedures to work around the syntax... Soon...

Original comment by tjarda.p...@incentro.com on 13 Mar 2013 at 9:39

GoogleCodeExporter commented 8 years ago 
Changed to Wont-fix for the upcoming release

Original comment by tjarda.p...@incentro.com on 13 Mar 2013 at 9:55