Show TOC

Connecting to a DatabaseLocate this document in the navigation structure

Use

This procedure enables you to connect to a remote database and display an installed AS Java configuration.

Procedure

  1. Start the Config Tool by double-clicking the configtool script file in <SAP_install_dir>/<system_name>/<instance_name>/j2ee/configtool directory.

  2. In the Connection settings dialog window, choose " Yes " if you want to connect to the default database, or " No " to connect to a different one.

    The default database connection is via the Secure Store.

    Note

    If you check the " Do not ask me again " indicator, next time you start the Config Tool, it will automatically connect to the default database.

    To connect to a different database, you can remove the config.properties file from the configtool directory. Then, start the Config Tool.

  3. In the Connect dialog window, choose whether to connect via secure store or via direct login and enter the required data in the relevant fields.

Secure Store Settings

Description

Example

Secure Store File

Contains the path to the secure store properties file. This file is encrypted for security reasons.

C:\usr\sap\LKG\SYS\global\security\data\SecStore.properties

Secure Store Key File

Contains the path to the secure store key file. The key file contains the password for the encrypted store file.

C:\usr\sap\LKG\SYS\global\security\data\SecStore.key

System Name

Displays the name of the system to which this data applies.

LKG

Secure Store Lib

Specifies the security directory. It contains IAIK JAR files you need to use to open the Secure Store.

C:\usr\sap\LKG\SYS\global\security\lib

RDBMS Connections

A property key, by which the value contains the DB connection settings.

jdbc/pool/LKG

Direct Login Settings

Description

Example

RDBMS URL

Specifies the URL for the database connection in the correct format for the corresponding driver.

jdbc:sapdb://sofD60163517A/CE1?timeout=0&spaceoption=true&unicode=true

Driver name

Specifies the class name of the JDBC driver to be used for database connections.

com.sap.dbtech.jdbc.DriverSapDB

RDBMS user

Specifies the user name for this database connection.

SAPLKGDB

RDBMS password

Specifies the password set during the installation of the relevant AS Java.

  

IAIK Library

Specifies the IAIK JAR files directory. It enables the encrypting and decrypting of the properties file.

;C:\usr\sap\LKG\SYS\global\security\lib\tools\iaik_jce.jar; C:\usr\sap\LKG\SYS\global\security\lib\tools\iaik_jsse.jar; C:\usr\sap\LKG\SYS\global\security\lib\tools\iaik_smime.jar; C:\usr\sap\LKG\SYS\global\security\lib\tools\iaik_ssl.jar

General Settings

Description

Example

RDBMS Driver Location

Contains the path to the RDBMS driver.

C:\\sapdb\programs\runtime\jar\sapdbc.jar

RDBMS Initial Connections

Specifies the number of database connections to be created initially in the connection pool.

1

RDBMS Maximum Connections

Specifies the maximum number of database connections to be kept in the connection pool.

10

After filling in the connection fields, you have the following options:

  • Directly connect to the relevant database. Choose Connect to DB .

  • Save the connection properties you have just set as following:

    1. Choose Save Connection As .

    2. Enter a file name with the extension " .properties ", for example user.properties .

    3. Choose Save .

  • Open a previously saved " .properties " file to connect to a database. Choose Load Connection Settings .

Result

You have successfully connected to a database.

After opening the GUI Config Tool, you can proceed the following steps for better future use:

  • If you want the Connection settings dialog box to appear again on startup, choose Start of the navigation path View Next navigation step Startup Options. End of the navigation path. Then, in the dialog window, check Show connection dialog .

    The other way is to delete the visual.properties file. Then, start the Config Tool.

  • If you use a Linux or Unix operating system, choose Start of the navigation path View Next navigation step Startup Options End of the navigation path. Then, in the dialog box, check Use loading indicator .

    This is necessary for the system to provide a better performance of the GUI Config Tool when you work with instances.

    Note

    If you are not available to proceed this via the GUI tool, in the configtool folder, open the visual.properties file for text editing. Then, add the line: show.loading.indicator=YES .