cSQLConnection Standard properties

Select the way the connection details will be set.

• Built-In: The connection details will be set locally for this component. You need to specify the values for all related connection properties manually.

• Repository: The connection details stored centrally in Repository > Metadata will be reused by this component.

  You need to click the [...] button next to it and in the pop-up Repository Content dialog box, select the connection details to be reused, and all related connection properties will be automatically filled in.

You can drag and drop a JDBC connection from the Metadata node of the Repository tree view to the design workspace to create a cSQLConnection component.

Driver Class

Enter the class name for the specified driver between double quotation marks.

Complete this table to load the driver JARs needed. To do this, click the [+] button under the table to add as many rows as needed, each row for a driver JAR, then select the cell and click the [...] button at the right side of the cell to open the Module dialog box from which you can select the driver JAR to be used.

For more information, see Importing a database driver.

Select this check box to enter the database user authentication data. The User Id and Password fields appear when this check box is selected.

To enter the password, click the [...] button next to the password field, enter the password in double quotes in the pop-up dialog box, and click OK to save the settings.

Select this check box and in the Data source alias field displayed, specify the alias of a data source created on the Talend Runtime side to use the shared connection pool defined in the data source configuration. This option works only when you deploy and run your Route in Talend Runtime.

Initial Connections

Specify the minimum number of idle connections (connections not used).

• Query Timeout (sec): Set a timeout period for the query in seconds. A value of -1 means that no timeout is set.
• Max Connection duration (sec): Set a maximum duration of the connection in seconds. A value of -1 means that no timeout is set.

• Validation Query Timeout (sec): Set a timeout period for the validation query in seconds. A value of -1 means that no timeout is set.
• Validation query: Enter an SQL SELECT statement to validate the connection.

Usage rule

cSQLConnection can be added directly in a Route without any input or output component linked.

Limitation

 n/a