Category: Data
The SQL statement specified in the Statement property are executed, one after the other, on the same SQL connection
Properties
| Name | Description | Mandatory | Initial Value | Runtime Expression | Type | Conditional | Data Type | Comments |
|---|---|---|---|---|---|---|---|---|
| NodeType | Contains the type for node | No | No | No | Output | No | Text | |
| Name | Name of the workflow node | Yes | Yes | No | Input | No | Text | |
| Description | Description of the workflow node | No | Yes | No | Input | No | Text | |
| LogData | Any string to output to the workflow log | No | No | No | Input | No | Text | |
| UseAdaptivaDataBase |
If this is set to true, the following properties are ignored, and the values for the adaptiva database are used, as present in the Adaptiva Server registry key. Ignored properties: DatabaseUrl, JdbcDriverName, UserName, PassWord. |
Yes | Yes | No | Input | No | Boolean | Default is true |
| AutoCommit | If this is set to true, the statements are executed with auto-commit turned on, else auto-commit is turned off while executing the statements | Yes | Yes | Yes | Input | No | Boolean | Default is true |
| Statements | The SQL statements that are to be executed | Yes | Yes | Yes | Input | No | Text | |
| UpdateCount | Contains the number of rows that have been affected by the last SQL statement that was executed or -1 in case of any error. | No | No | No | Output | No | Whole Number | |
| ThrowExceptions |
When set to true the following properties are not available: ExceptionOccurred, ExceptionType, ExceptionMessage, ExceptionObject |
Yes | Yes | No | Input | No | Boolean | Defaults to false |
| ExceptionOccurred | The property is dynamic, and it is present only if the ThrowExceptions property is set to false. Will return true when an exception occurs in the execution of the DatabaseURL (when used) or SQL Statement | No | No | No | Output | No | Boolean | |
| ExceptionType | The property is dynamic, and it is present only if the ThrowExceptions property is set to false. Contains the fully qualified class name of the exception when an exception occurs | No | No | No | Output | No | Text | |
| ExceptionMessage | The property is dynamic, and it is present only if the ThrowExceptions property is set to false. Contains the exceptions message when an exception occurs | No | No | No | Output | No | Text | |
| ExceptionObject | The property is dynamic, and it is present only if the ThrowExceptions property is set to false. Contains the exception object when an exception occurs | No | No | No | Output | No | Java Object | |
| DatabaseUrl |
When UseAdaptivaDatabase is false, this field is used to connect to the Database server and database. Enter in the form: jdbc:jtds:sqlserver://Servername;DatabaseName=Name; Domain=NebiosName; SelectMethod=cursor; IntegratedSecurity=SSPI; SocketTimeout=360; |
Yes | Yes | Yes | Input | No | Text | |
| JdbcDriverName |
When UseAdaptivaDatabase is false, this field is used to define the JDBC driver. To connect to another SQL Server use: net.sourceforge.jtds.jdbc.Driver |
Yes | Yes | Yes | Input | No | Text | |
| UserName | When UseAdaptivaDatabase is false, this field is used to define the username with permissions in the database. If the Adaptiva server has access to the database enter "" in the Runtime expression field | Yes | Yes | Yes | Input | No | Text | |
| Password | When UseAdaptivaDatabase is false, this field is used to define the password for the user account | Yes | Yes | Yes | Input | No | Text |
|
Note
|
|---|
|
For every column in the the query entered in Statement, create a User defined property with the appropriate Data Type. For an example of this Activity, please review this article for a full Walkthrough. |