cancel
Showing results for 
Search instead for 
Did you mean: 

How to Creat Custom Table and accessing it

koteswar
Champ in-the-making
Champ in-the-making
Hi ,
  I need to create new table and i have to store some custom data into table , How we can Create and how we can access it ?
DB is HSQL only
Please let me know ASAP
19 REPLIES 19

hbf
Champ on-the-rise
Champ on-the-rise
I need something similar. To integrate Alfresco with our caching architecture, I need an additional table within Alfresco, managed by my Alfresco Module Package which will catch node update events and alter the table within the current transaction. (I need highest performance here and therefore don't want to use Alfresco's content model.)

Is there an example around that shows how to add another table, probably using Hibernate?

Thanks,
Kaspar

snig
Champ in-the-making
Champ in-the-making
Hi Guys

Did you find any solution for this?
My requirement is the same, and struggling to find out any clue…

Please share…

Thanks in advance.
Snig.

snig
Champ in-the-making
Champ in-the-making
Any news on this guys…?
I am really in a road-block in this issue…

hbf
Champ on-the-rise
Champ on-the-rise
If you know French (or use Google translate), take a look at this reply on the French forum: http://forums.alfresco.com/fr/viewtopic.php?f=11&t=1329&p=6086

I'd say trying to add your custom tables is the wrong approach as you need to know a lot about Alfesco's inner workings.

hansraj
Champ in-the-making
Champ in-the-making
Hi,

could anybody please answer for how to create custom table?

Regards,
Hansraj

mrogers
Star Contributor
Star Contributor
I quite agree with what 'hbf' has said above that this is probably the wrong approach to use with Alfresco.

But if you do need to create a database table and access it from a JSP. It's easy to do and is the type of thing they cover on the first day of a Java programming course.   You can either use jdbc directly or a tool like hibernate.    But of course you are not using Alfresco and are in probably in the wrong forum.

asurjit
Champ in-the-making
Champ in-the-making
Folks,

As part of the content deployment, we can deploy files on file system quite easily using Alfresco but if I want to send Alfresco content records to database then we are unable to find any way. Our requirement is quite simple at the moment where we want to populate the content in our portal database so that portal can fetch the records at run time and render them on website.

I would like to know if Alfresco content deployment system supports content deployment to custom tables on the portal database?

Any quick feedback is appreciated.

Regards
-Amar

asurjit
Champ in-the-making
Champ in-the-making
Folks,

We are looking on couple of features on Alfresco and

deployment to database and customizing web forms are key requirement for our client while making selection for Alfresco. These features are critical factors while making a decision on the product.

Would like to know the next steps if we need to get the confirmation on this feature set? If these are already available then instructions to implement them and if they are not available then roadmap for the same?

Regards
-Amar

mabayona
Champ on-the-rise
Champ on-the-rise
If you need to store some information from Alfresco into a table (a database?) the WRONG approach it to try to add tables to Alfresco DB.

Possible CORRECT approaches are:

- Use web services
- Use web scripts

in both cases, the approach is to design the table/database (external to alfresco) to contain the information you are looking for and to extract the information to populate them using one of the above mentioned methods.

Another option is to extend Alfresco content model with your custom data model, however, it seems that what you need is just a mechanism to extract information from Alfresco as the ones expresed above.