how to store form data into user specific table (oracle database)
This post has NOT been accepted by the mailing list yet.
I have installed Orbeon PE trial version. I am understanding work flow of this tool (novice user). I have created a form and i want to store all form information into user specific table after pressing button (custom button) (table is having same number/type of fields present on form). (currently storing form data into orbeon specific tables as xml)
Can you please let me know how to achieve this process? (links, or steps , video links)
actually we are analyzing business scenarios, if this tool satisfy our requirements we are going to purchase this tool.
Re: how to store form data into user specific table (oracle database)
1-You can find the crud.xpl file in orbeon/WEB-INF/lib/orbeon-form-runner.jar
2-Create this same path in your orbeon and copy this file, so you can make your changes to this file.
It seems that you just want to change the name of the table. So, you should change the following variable:
<xsl:variable name="table-name" as="xs:string" select="concat(
if ($is-data) then '<b>orbeon_form_data' else 'orbeon_form_definition',
if ($is-attachment) then '_attach' else '')"/>