...
Microsoft SQL Server (MSSQL) is a commercial database product available from Microsoft at http://www.microsoft.com/sql/default.mspx
Further technical information on this product may be found here
| Warning | ||
|---|---|---|
| ||
Adopters running uPortal 3 on MS SQL Server should enable the ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT options in the portal database. Perform the following commands to enable these settings:
Without these options, MS SQL Server will encounter deadlocks in the portlet preferences subsystem under load. You can read more about these settings here. |
Obtaining a Driver
Since the jTDS JDBC driver for MSSQL is not available in the central Maven repository, it must be placed into the local repository of each machine on which you wish to build uPortal.
...
You will have to change the db-version entry to match your version of MS SQL Server.
Testing
...
the Configuration
Running the dbtest ant target will tell you if you have configured the database connection properly.
| Code Block |
|---|
ant dbtest |
...
Then, following a successful test, you can execute
| Code Block |
|---|
ant initportal
|
to build the database tables and copy files to your servlet container.
Start your servlet container.
Issues and Known Bugs
Additional Notes
...
Much of the information on this page was provided by ~bneupane Bikrant Neupane on the uportal-user list. Thanks.