Portlet Factory, Version 6.1.2
SQL DataSource builder
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.
Quick tips
- 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.
Parent topic: Builder help
- About using the builder call editor
The builder call editor allows you to specify all the input values to a builder call.
- SQL Data Source builder Input
This topic describes the SQL Data Source builder inputs.
- SQL Datasource: tracking database events
This topic describes the database-related events that the SQL Datasource builder can fire in the model.
- About adding an SQL Datasource builder to an existing model
Use this approach to add basic database connectivity to a model.
- Working with a database
IBM WebSphere Portlet Factory provides a variety of database tools from high-level to low-level.
Library | Support |