How to Creat Custom Table and accessing it

[koteswar]

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

[hbf]

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]

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]

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

[hbf]

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]

Hi,

could anybody please answer for how to create custom table?

Regards,
Hansraj

[mrogers]

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]

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]

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]

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.