Adding Custom Tables to Alfresco repository

[pal_arunava83]

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 table.

But as I am not very conversant with Hibernate, I am unable to read values from the table. Can somebody provide me with the steps to accomplish my objective, alongwith the names of the files that need to be changed?

[pmonks]

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

[pal_arunava83]

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.

[zaizi]

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

[pal_arunava83]

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.