Task E Setting up the Database Connection Parameters

This section explains the steps required to setup the parameters to connect to the database.

Procedure

  1. Open the ASG_CONFIG_HOME/asg/asg_cl.properties file for editing.
  2. Edit the following parameters to provide the values to connect to the appropriate database: 
       tibco.clientVar.CL/Database/Driver=database driver type
   tibco.clientVar.CL/Database/Url=database url
   tibco.clientVar.CL/Database/Username=database user name
   tibco.clientVar.CL/Database/Password=database password

    For example, the values are shown for MySql database as follows: 

       tibco.clientVar.CL/Database/Driver=com.mysql.jdbc.Driver
   tibco.clientVar.CL/Database/Url=jdbc:mysql://localhost:3306/asgstat
   tibco.clientVar.CL/Database/Username=asguser
   tibco.clientVar.CL/Database/Password=asgpass
   tibco.clientVar.CL/Database/Schema=asgstat

    For example, the values are shown for Oracle database as follows: 

       tibco.clientVar.CL/Database/Driver=com.oracle.jdbc.Driver
   tibco.clientVar.CL/Database/Url=jdbc:oracle:thin:@localhost:
   1521:ORCL
   tibco.clientVar.CL/Database/Username=asguser
   tibco.clientVar.CL/Database/Password=asgpass
   tibco.clientVar.CL/Database/Schema=asgstat

    For example, the values are shown for SQL Server database as follows: 

       tibco.clientVar.CL/Database/Driver=com.microsoft.sqlserver.jdbc   .SQLServerDriver
   tibco.clientVar.CL/Database/Url=jdbc:sqlserver://localhost:1433   ;databaseName=asgstat
   tibco.clientVar.CL/Database/Username=asguser
   tibco.clientVar.CL/Database/Password=asgpass
   tibco.clientVar.CL/Database/Schema=dbo

    For example, the values are shown for DB2 database as follows: 

       tibco.clientVar.CL/Database/Driver=com.ibm.db2.jcc.DB2Driver
   tibco.clientVar.CL/Database/Url=jdbc:db2://localhost:50000/asgstat
   tibco.clientVar.CL/Database/Username=asguser
   tibco.clientVar.CL/Database/Password=asgpass
   tibco.clientVar.CL/Database/Schema=asgstat
    Note: For the database Url field, replace localhost with the host name where database server runs, as required.