The SQL DataSource builder allows your model (and the other SQL builders) to obtain database connections from a local or remote JNDI-based DataSource.
The DataSource is typically defined and managed by your application server and made available through a JNDI server provided as part of the application server's implementation.
The DataSource created by the application server will usually provide a set of additional features beyond simply handing out JDBC connections for access to a database. Some of those features might include connection pooling, stale connection handling, and connection timeouts.
This builder provides flexibility by allowing you to access secure JNDI servers where authentication is required. The builder also allows you to control the flow of your application by specifying various timeout settings that prevent an application from hanging while attempting to acquire the database connection from the DataSource.
Support multiple connections
Create multiple instances of this builder, each of which defines a different JNDI data source. These data sources are then available in a model as selectable inputs in other SQL builders, allowing you to mix-and-match data sources as you build various statements and transforms.Using IBM® WebSphere® Application Server 5 datasources
IBM WebSphere Portlet Factory supports the use of both version 5 and version 4 data sources. The version you can use, however, depends on the version of J2EE application you are building. The limitations are as follows:
J2EE 1.2-based applications
Must use version 4 datasources.J2EE 1.3-based applications
Must use version 5 datasources.
WebSphere Portlet Factory cannot mix datasource versions (v4 and v5) in the same project. You must match the appropriate datasource version with the J2EE version you chose when you created the project with the Project Wizard.
SQL Data Source builder inputs
This topic describes the inputs for the SQL Data Source builder.
SQL Datasource: tracking database events
This topic describes the database-related events that the SQL Datasource builder can fire in the model.
Parent topic: Builder help
About using the builder call editor
About adding an SQL Datasource builder to an existing model
Working with a database