...
4. From the "IP Address" tab, disable "TCP Dynamic Ports" by leaving it blank and give a valid "TCP Port" so that MSSQL server will listen in that port.
| Info | ||
|---|---|---|
| ||
You can use port 1433 in order processor services, so it is better to use that port. |
...
1. Edit the default database configuration defined in the master-datasources.xml file located at $CARBON$PRODUCT_HOME/repository/conf/datasources directory as below. Both the database configurations in registry.xml and user-mgt.xml refer this data source.
...
- url - The URL of the database.
- username - The name of the database user.
- password - The password of the database user.
- driverClassName - The class name of the database driver.
- maxActive - The maximum number of active connections that can be allocated from this pool at the same time or negative for no limit.
- maxWait - The maximum number of milliseconds that the pool will wait (when there are no available connections) for a connection to be returned before throwing an exception, or <= 0 to wait indefinitely.
- minIdle - The minimum number of active connections that can remain idle in the pool without extra ones being created or 0 to create none.
| Info | ||
|---|---|---|
| ||
Default port for MSSQL is 1433. |
...
Copy MSSQL JDBC driver jtds-1.2.2.jar to $CARBON$PRODUCT_HOME/repository/components/lib.
| Info | title | Tip
|---|
JDBC driver can be downloaded from http://sourceforge.net/projects/jtds/files/ |
...
Database tables can be created manually by logging in to created database and running $CARBON$PRODUCT_HOME/dbscripts/mssql.sql.
- Using start-up Parameters
Windows users can run $CARBON$PRODUCT_HOME/bin/wso2server.bat -Dsetup to create the database tables when starting WSO2 BPS for the first time.
Linux users should use $CARBON$PRODUCT_HOME/bin/wso2server.sh -Dsetup.
...