nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

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.

Find more posts tagged with

Comments

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.

inocka

There is nothing wrong with jdbc. I just forgot about this solution. Thanks