Installing the Squirrelsql Client

To disable the auto logout feature of Dashboard we need to modify BSD_OPTION table of Derby database which is use by Tomcat web server. To connect and update the table we need to use Squirrel SQL Client tool. Below are the steps:

Installation

To use the SquirrelSQL client to connect to Dashboards' Derby database, you will need to download and install the SquirrelSQL client and also the Apache Derby JDBC client driver.

Installing the SquirrelSQL client

Download the latest JAR installer for SquirrelSQL from the Downloads section of the SquirrelSQL site.

Run the installer to install the client. The default installation path is C:\Program Files\SquirreL SQL Client. If you change this path please make a note of it as it will be required in the next step.

When prompted to select the packs, choose Optional Plugin - Derby

To execute: Start => Program => SQuirreL SQL Client => SQuirreL SQL Client

Installing the Apache Derby JDBC Client driver

Download the Apache Derby Client JDBC Driver and extract the derbyclient.jar file from the ZIP archive to the lib folder of your SquirrelSQL installation, such as C:\Program Files\SquirreL SQL Client\lib.

Configuration

After launching SquirrelSQL for the first time you will need to configure the Apache Derby Client driver and create an alias for Dashboards' Apache Derby database.

Configuring the Apache Derby Client driver

·  Select the Apache Derby Client in the Drivers list in SquirrelSQL.

·  Click the edit (pencil) icon to edit the driver properties.

·  On the Extra Class Path tab, click the Add button to add a new driver JAR file.

·  Browse to the lib folder of your SquirrelSQL installation and select the derbyclient.jar, then click Open.

·  Click OK to save the change.

The Apache Derby Client driver should now have a blue tick beside it, indicating that the driver is available for use.

Creating an alias for Dashboards' Apache Derby database

·  In the Aliases list, click the add (plus sign) icon to add a new alias.

·  Enter Dashboards as the name.

·  Select Apache Derby Client as the driver.

·  Enter jdbc:derby://localhost:1528/bsmdashboards as the URL.

·  Enter bsmdashboardsapp as the User Name and Password.

·  Check the 'Auto logon option.

·  Click the OK button to save the alias.

To connect to Dashboards you can now simply double-click on the Dashboards alias in the Aliases list.

Once you connect to derby database then search for table called BSD_OPTION as shown in below snapshot.

Right click on loginTimeout and select make editable.

Then change the value to 0. Once you set the value to Squirrel then auto logout feature will get disable.