SQLServer Database Configuration

Step 1 Step 2 Step 3 Step 4 Step 5
Substep 1
Substep 2
Substep 3


Step 4: Create a DataSource Object

Substep 2: Define the DataSource

  1. In the Types view, right-click DataSources.
  2. From the pop-up menu, select Create.
  3. Use these values in the subsequent dialog:
    • Name: Type sample, in lower case
    • Database name: Type //<hostname>:<portnumber>;databaseName=SAMPLE
      Be sure to enter the actual hostname for the <hostname> field.
      The port number "19996" is the default port number used by SequeLink but it can be altered during the installation process. Use the default port number or the port number that was specified during the SequeLink install.
    • Driver: Select the JDBC driver you created in Step 4-SubStep 1: SQLServerSampleDriver
  4. Optionally you can use the Advanced tab to specify pooling parameters for the DataSource or you can accept the defaults.
  5. Click OK.
  6. Go to Substep 3


Take Note!
  • The name of the DataSource must be sample but the name of the database should match the one that you entered in Step 2. The Samples use the DataSource named sample to connect to a database and the DataSource uses the database name to connect to the particular database; therefore, the Samples do not directly use the database name to connect to the database.
  • The DataSource will be stored as "sample" in the /jdbc directory. In the servlet files, we specify "jdbc/sample" as the DataSource object and the code uses this to attach to the database. (In the ConnPoolTest servlet, we use this directory as the JNDI lookup name to locate this DataSource object as specified in its properties file, ConnPoolTestStrings.properties.)