topic Adding Custom Tables to Alfresco repository in Alfresco Archive

Adding Custom Tables to Alfresco repository

pal_arunava83 — Mon, 07 Jul 2008 12:44:07 GMT

Hi,I am a new Alfresco user and don't have much exposure to Hibernate and other stuff. My objective is to add a custom table to the Alfresco repository and make Alfresco interact with it. For that I am planning to add a jsp page linked to the Alfresco dashboard to show the values picked up from the

Re: Adding Custom Tables to Alfresco repository

pmonks — Mon, 07 Jul 2008 14:26:57 GMT

For read-only scenarios (ie. your JSP only SELECTs data out of the custom table) I'd suggest using SpringJDBC instead (http://static.springframework.org/spring/docs/2.0.x/reference/jdbc.html). Imvho it's a better choice for simple read-only scenarios since it has a significantly lower learning curve than Hibernate and will likely be less work too (no mapping file, DTOs, etc. etc.).

Alfresco already includes the Spring library (and I'm pretty sure we include the "uber JAR" version of Spring, which includes the SpringJDBC module), so you should be able to get up and running with minimal hassle.

Cheers,
Peter

Re: Adding Custom Tables to Alfresco repository

pal_arunava83 — Mon, 07 Jul 2008 16:25:13 GMT

Thanks a lot, Peter!!!

But, my scenario is not read-only, and whether I want or not I have to understand Hibernate. Can u please share some information about how to make alfresco interact with custom tables in my database??

One more thing I cam across is that it is very inadvisable to tamper with the Alfresco database. So I am planning to create a new database and create my custom table there. Please help. It's very urgent.

Re: Adding Custom Tables to Alfresco repository

zaizi — Mon, 07 Jul 2008 19:40:31 GMT

Can you explain in more detail what solution you are trying to implement?

Re: Adding Custom Tables to Alfresco repository

pal_arunava83 — Tue, 08 Jul 2008 05:50:54 GMT

I just want to pick up values from a MySQL table and show them on a jsp screen integrated with Alfresco. I am facing problem, big time, with Hibernate. I am not able to understand the flow by which Alfresco loads its repository tables. Please advice.