Ad Hoc Update process

The AD Hoc Update process executes an ad hoc update against an SQL database. This process handles any necessary CDATA wrapping for SQL statements. The inputs must contain plain SQL statements.

The following table describes the process inputs for the SQL adapter with the Ad Hoc Update process.The [confluence_table-plus] macro is a standalone macro and it cannot be used inline. Click on this message for details.
This macro generates standalone content. As a consequence you need to make sure to use a syntax that separates your macro from the content before and after it so that it's on a line by itself. For example in XWiki Syntax 2.0+ this means having 2 newline characters (a.k.a line breaks) separating your macro from the content before and after it.

The following table describes the process output parameters for the SQL adapter with the Ad Hoc Update process.The [confluence_table-plus] macro is a standalone macro and it cannot be used inline. Click on this message for details.
This macro generates standalone content. As a consequence you need to make sure to use a syntax that separates your macro from the content before and after it so that it's on a line by itself. For example in XWiki Syntax 2.0+ this means having 2 newline characters (a.k.a line breaks) separating your macro from the content before and after it.The following figure shows a sample XML adapter request for the Ad Hoc Update process:

<sqlAdapterRequest>
<action>update employee set name='Emp_Name' where emp_id=12345</action>
</sqlAdapterRequest>

The following figure shows the adapter response for the request:

<sqlAdapterResponse>
<metadata>
<queryExecuted>update employee set name='Emp_Name' where emp_id=12345</queryExecuted>
<execution-milliseconds>2312</execution-milliseconds>
<status>success</status>
</metadata>
</sqlAdapterResponse>

Ad Hoc Update process

On this page