Saving data to another DB schema or calling external program

[inocka]

Hi,
The functionality I am searching for:
On the workflow step some java or javascript action should be called. This action should save particular information to external DB/ call external project method/ call oracle db webscript method.
The aim of that action is documents synchronization with external system.
Any ideas?

Thanks a lot.

[mrogers]

What's the problem?

[savic_prvoslav]

you can add hibernate and add this, few overrides and you are set.

[inocka]

Hi,
Thanks for reply. May be savic.prvoslav you could explain your idea in more detail? What I need to override to hibernate?
mrogers my problem is that after I created the document (I use workflow step javascript action for that) I need to synchronize that information to external system and I am searching for best solution to do that at the moment.

Thanks again

[savic_prvoslav]

you have your external system and his database, you can use hibernate to connect to it and work with the data.

This is big job and I do not think that it could be explaind in steps, if you are not able to do that you can hire some alfresco developer company to do this for you. sorry.

[inocka]

Thanks. As I understand I should study a lot on my own. If you provide me some links there to read about that I'll appreciate that. Are any specific points about using hibernate in Alfresco?
I'll try to ask more exact questions in the future.

[hsohaib]

In Alfresco you just need to provide your action class that will be invoked by the workflow step, and will have access to all informations you will need, from there it's hibernate/sql stuff that got nothing to do with your experience with Alfresco, have you tried connecting or using a DB from java before (JDBC, Hibernate etc..) ? if not, you should start by learning how to do that.

Here is a simple tutoriel using netbeans : http://platform.netbeans.org/tutorials/nbm-crud.html .

[inocka]

Hi,
We use jpa/spring/hibernate in other project. I already studied about workflows and actions it is the easy part for me.
The main problem is hibernate part. Then I am trying to do the same staff ass in other project in Alfresco I get lots of errors about dialect (we are using Oracle 11). May be were are any tutorials how to put data from Alfresco to external system?

[mrogers]

Hibernate may be overkill for your requirements.   But the dialect stuff is easily solved by setting your dialect directly.

What's wrong with using plain old JDBC? or ibatis if you think that's too low level.  

Or provide a web based interface on your oracle system that you call from Alf.

[savic_prvoslav]

At my company we do something with hibernate, we have used jdbc. let me tell you when we crossed to hibernate we ware spending 10 times less time on database.