mysql connection

[xdonzel]

Hello everyone
im new in alfresco dvpt,
i have a question about script
is it possible to connect to an mysql database (other than Alfresco but same server) an update a table by script?

the goal is to do an auto update  on a table when you upload a document in alfresco (by giving document name's and url)

perhaps my question is idiot but dont find any solutions on the forum.

with regards

[kbonnet]

By default this is not possible. If you really want this, maybe you can investigate if you can customize the rhinoscript wrapper around java method to include database manipulation methods? In my opinion it would be cleaner to talk to a web/rest service which does the database manipulation.

[xdonzel]

thank you for the answer,

so is it possible to do an action for sending my data through an url like (http://myserver/process.php?data1=name&data2=url) where data are take from the document that i upload (for example name of the document and url in alfresco of the document)?

if yes, is there a place in the wiki which explains this?

thank in advance

[kbonnet]

I dont have a turn-key solution, but you could investigate writing a javascript to be triggered via a content rule or behaviour and calling the remote.connect() method in that. This is just a thought for investigating; i have never tried it.

Koen

[xdonzel]

ok thanks a lot,
i will try it and reply if i find a solution
^^