Ok, thanks alot...
I just had the problem that I didn't get any data inserted in the database.
I have set up the execute sql service to the following:
SQL Statement:
insert into table1 values({$ /process_data/@id $}, '{$ /process_data/formdata $}')
This inserts the processInstanceID in the DB but no data is inserted. I have also tried:
insert into table1 values({$ /process_data/@id $}, {$ /process_data/formdata $}) (without the quotes (' and '))
But this time the server gets an exception parsing the xml.
How should I set up the SQL statement to insert my xml-variable "formdata" into the DB?
Thank you in advance
Sincerely
Kim Christensen