The data source created in the previous section will be configured. Select the data source to be configured in the Data Sources table, and also select the Configuration tab, which is the default setting. In the Configuration window, the data source JNDI name can be modified:
Other configuration options for a data source are listed in following table:
Data Source Setting |
Description |
---|---|
Row Prefetch |
Row Prefetch fetches multiple rows from the server to the client in a single server access, thus improving their performance. |
Row Prefetch Size |
If row prefetching is enabled, specify the number of rows to be fetched. Optimal size of the rows to be fetched depends on the query. |
Stream Chunk Size |
Specifies the data chunk size for streaming the data types. |
Select the Connection Pool link to configure the connection pool associated with the data source. Initial capacity, maximum capacity, and capacity increment can be set in the connection pool configuration. The Advanced...