Database Pooling

Database Pooling

Issue

The way UW connects to a Database to run queries, it uses a single connection for each DB object created.  Thus if you have multiple queries that are run against that connection, they are processed in order, one at a time.  A very long query can therefore hold up multiple shorter queries, as they must wait in the queue.


Solution

Enable Database Connection Pooling to provide more than one connection.

You should have an existing file that will allow for the configuration and enabling of Database Connection Pooling:

/stoneware/config/DatabaseConnectionPool.xml.sample.


This feature requires making some extra Database Connection objects, but what it will do is allow the loader to randomly use a connection from a small pool, instead of having to queue all queries to a single connection.

For Example, what you would do is create 4 more database connection objects (we'd recommend to have at least 5 total to increase the randomness), so that you have the following:
  • CN=dbs-sql,OU=stoneware,dc=com (This is Your current DB connection object.)
  • CN=dbs-sql-2,OU=stoneware,dc=com
  • CN=dbs-sql-3,OU=stoneware,dc=com
  • CN=dbs-sql-4,OU=stoneware,dc=com
  • CN=dbs-sql-5,OU=stoneware,dc=com

Then put those in as a pool in the above referenced file.
Rename the file to remove the .sample extension.
Restart Report Services on the loader, via the 8090 Management Console.

Now when a query is run against the default dbs-sql connection, the server will either use that connection or one of the others connections in the pool to run the query.



The following debug options will provide information on the status of the database pools:

  • com.stoneware.service.pubic.report.connectionpool
  • com.stoneware.service.pubic.report.connectionpoolbuilder

    Can't find the KB

    Unable to find the KB to address your issue ?  

      • Recent Articles

      • Lenovo Unified Workspace End-of-Life Questions and Answers

        Will the shutdown of LUW servers and access to downloads affect my server licensing? No, the shutdown of the customer servers and access to the product and licensing downloads will not affect your server licensing. This license is downloaded and ...
      • How do I determine my Unified Workspace license expiration date?

        The best method for determining the licensing information including the expiration date of your Unified Workspace license: Login to your 8090 management console on each server This may take remoting into each LUW server and relay, opening a browser, ...
      • Lenovo Unified Workspace 7.0.2.13 Released

        Highlights of Unified Workspace 7.0.2.13 Before you install: Please view the installation notes here. 7.0.2.13 requires a 7.0 license file. Below is a list of enhancements and fixes released in Unified Workspace 7.0.2.13 Fixed external storage ...
      • LanSchool Documentation Guides

        LanSchool Classic Teacher Console The LanSchool Teacher Console is the interface teachers will use to manage their classroom and students. It contains all the tools necessary for a teacher to effectively interact with students and create a ...
      • Lenovo Unified Workspace 7.0.1.41 Released

        Highlights of Unified Workspace 7.0.1.41 Before you install: Please view the installation notes here. 7.0.1.41 requires a 7.0 license file. Below is a list of enhancements and fixes for Unified Workspace 7.0.1.41 Updated Log4j Updated Java Updated ...
      • Related Articles

      • Data Recorded in the Audit Database

        Issue Customer would like to build reports to view specific information logged by UW, that is not available from Analytics.  What additional information is logged in the Audit Database? Solution There is quite a bit more information recorded into the ...
      • Move database logging to SQL server.

        Changing / migrating the Logging Database from HSQL to MySQL , MSSQL. By default, the Stoneware Relay logs all transactions to a Java database called HyperSonic SQL. This database is installed as part of the portal installation and automatically ...
      • Potential issues with HSQL database during upgrades

        With the release if 6.3.1.x and higher the HSQL database was updated.  This upgrade requires us to check each of your HSQL database files in \stoneware\hsql and upgrade the format to a newer storage method. It does this by reading the data from each ...
      • HSQL database driver updated in Unified Workspace

        As of Unified Workspace 6.3.1.x, the driver used to communicate with the built-in HSQL databases is being updated. This update changes the delimiter used when storing the information.  If you are using HSQL for anything other than webStore (which ...
      • Unable to see database connection in Report Builder

        You must add each uers/group to have access to those database connections. WebNetwork 5 has added security to see the database connections.