topic Re: mysql connection in Alfresco Archive

mysql connection

xdonzel — Wed, 09 Dec 2009 17:12:16 GMT

Hello everyoneim new in alfresco dvpt,i have a question about scriptis 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)

Re: mysql connection

kbonnet — Fri, 11 Dec 2009 09:50:34 GMT

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.

Re: mysql connection

xdonzel — Mon, 14 Dec 2009 16:49:32 GMT

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

Re: mysql connection

kbonnet — Mon, 14 Dec 2009 16:54:56 GMT

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

Re: mysql connection

xdonzel — Tue, 15 Dec 2009 16:04:36 GMT

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