This site contains the documentation that is relevant to older WSO2 product versions and offerings.
For the latest WSO2 documentation, visit https://wso2.com/documentation/.
Working with Databases
- Former user (Deleted)
WSO2 products provide scripts for installing and configuring several types of relational databases, including MySQL, IBM DB2, Oracle, and more. Each of these databases supports stored procedures, which allow business logic to be embedded inside the database as an API, providing a powerful mechanism to interact with a relational database. Because these procedures are stored in a precompiled format within the database itself, execution speed is very fast. Client programs can be restricted to access a database via stored procedures only, thereby enforcing fine-grained security, preservation of data integrity, and improved productivity.
The embedded H2 database is suitable for development, testing, and some production environments. For most enterprise production environments, however, we recommend you use an industry-standard RDBMS such as Oracle, PostgreSQL, MySQL, MS SQL, etc.