WSO2 Business Process Server v3.0.1 Documentation

##### Overview

- Home
- Release Note
- WS-BPEL Compliance
- License

##### Downloads

- Releases

##### Installation Guide

- Installing WSO2 BPS

##### Quick Start Guide

- Modeling the process
- Deploying the process
- Testing the process

##### User Guide

- Deploying BPEL Processes
- Deploying Human Tasks
- Managing BPEL processes
- Managing BPEL process instances
- QoS for BPEL processes
- Securing BPEL processes
- Invoking secured partner services
- Versioning
- Management API

##### Human Task Guide

- Human Tasks Quick Start Guide
- Deploying HumanTasks
- Managing Tasks
- Developing a Human Task Artifact
- Human Task Management and Configuration
- Human Task Concepts

##### Administrator Guide

- External data sources Configuration
- Registry Configuration
- Events
- Unified Endpoints
- BPEL Extensions
- Transaction Factory Configuration
- Message Exchange Interceptors
- OpenJPA specific properties
- JMS Transport Configuration
- Process Instance Cleanup Tasks
- Process Hydration and Dehydration
- Enabling Peer-to-Peer(P2P) Communication
- Setting up a BPS Cluster

##### Best Practices

- Process Deployment Best Practices

##### Concepts

- Process Versioning
- Process instance events
- Partner links

##### WS-BPEL Extensions

- Activity Failure and Recovery
- Extension Activities and Extensible Assign Operations
- XPath Extensions
- Iterable ForEach
- Flexible Assigns
- BPEL4People Extension

##### Samples

- HelloWorld
- If-Else
- ForEach
- While
- Repeat Until
- Flow and Links
- Pick
- Synchronous and Asynchronous Service Invocations
- Fault Handling
- Split
- XslTransform
- Compensation Handler
- Event Handler

##### Resources

- FAQ
- External Articles
- Library
- Source Code

##### Community

- Forum
- Mailing Lists

##### Project Information

- Issue Tracking

# Data Sources

Use this configuration panel to configure data sources, and connection pools.

1. In the navigator, under Manage, click Data Sources. The Data Sources page appears.

   Figure 1. Add New Data Source

2. Click AddDataSource. The New Data Source page appears.
3. Add your data source configuration details. Depending on the selection of your data source repository (InMemory, JNDI ) different configuration parameters will be available.
4. Click Add. Your data source will be added.

Figure 2. Adding Data Source with InMemory configuration

Figure 3. Data Source configuration with JNDI

## Field Descriptions

The meanings of many field descriptions are similar to the DBCPconfiguration guide. Please refer that for more information. The following table only briefly summaries some of them.

New Data Source
Field Name | Description
Name | Name of the data source (This value should be unique.)
Data Source Name | A name to identify the data source, if a value is not specified,
Driver | The JDBC driver to be used.
URL | The connection URL to be passed to the JDBC driver to establish a connection
User Name | The connection user name to be passed to the JDBC driver to establish a connection
Password | The connection password to be passed to the JDBC driver to establish a connection
Data Source Pool Implementation | The type of the data source pool implementation
Pool type | This can be either: BasicDataSource or PerUserPoolDataSource. BasicDataSource - This data source is an implementation of javax.sql.DataSource that is configured via Java Bean properties. PerUserPoolDataSource :- This data source uses individual pools per user. Some properties can be set specifically for a given user, if the deployment environment can support initialization of mapped properties. For example, a pool of admin or write-access Connections can be guaranteed a certain number of connections, separate from a maximum set for users with read-only connections
Repository type | The type of the data source repository.
IC Factory | Initial context factory of the JNDI
Provider Port | If specified, it will be used to create a JNDI provider URL internally.
Provider URL | The URL of the JNDI provider. It is assumed that this URL exists and is accessible.
Max Active | The maximum number of active connections that can be allocated from this pool at the same time. If a negative value is specified, there wont be a limit to the number of connections. The default value is 8.
Max Idle | The minimum number of connections that can remain idle in the pool, without extra ones being created.It can be zero, to create none. The default value is 8.
Initial Size (int) | The initial number of connections that are created when the pool is started.
Max Open Statements (int) | The maximum number of active connections that can be allocated from this pool at the same time. If a negative value is specifed, there wont be a limit to the number of connections. The default value is 8.
Transaction Isolation | For the isolation values, please refer to the javadoc.
Auto Commit | The default auto-commit state of connections created by this pool.
Pool Statements | Enables prepared statement pooling for this pool. The default value is False.
Test On Borrow | Indicates whether objects will be validated before being borrowed from the pool. If the object fails to validate, it will be dropped from the pool, and we will attempt to borrow another. The default value is T rue. Note - For the value True to have any effect, the `validationQuery` parameter must be set to a non-null string
Test While Idle | Indicates whether objects will be validated by the idle object evictor (if any). If an object fails to validate, it will be dropped from the pool. The default value is False. Note - For the value True to have any effect, the `validationQuery` parameter must be set to a non-null string.
Validation Query | The SQL query that will be used to validate connections from this pool before returning them to the caller. If specified, this query must be an SQL SELECT statement that returns at least one row