Oracle database configuration

Oracle is one of the most popular and powerful database management systems. Oracle database has complete data management capabilities and complete distributed processing capabilities. iPortal supports the use of Oracle database to store portal data and security information.

• Install and configure the Oracle database
• Add a JDBC driver package
• Portal data storage configuration
• Security information storage configuration

Install and configure the Oracle database

If you've already installed the Oracle database, after create the database instance, tablespace, add and authorize the user, you can directly configure the portal data storage and security information storage. If you didn't install Oracle yet, please refer to: Oracle installation and configuration.

Note: In iPortal, it's recommended that you use different Oracle users to store portal data and security information separately.

Add a JDBC driver package

Before enabling the Oracle database, you need to add Oracle's JDBC driver package to iPortal. See the process as follows:

1. Download the Oracle JDBC driver package such as ojdbc7.jar, available on the official Oracle website (https://www.oracle.com/technetwork/database/features/jdbc/jdbc-drivers-12c-download-1958347.html)
2. After download, place the downloaded Oracle JDBC driver package in the [iPortal installation directory]\lib folder. If you need to enable the standalone service proxy, you also need to add the driver package to the [iPortal Proxy installation directory]\lib folder.

Portal data storage configuration

It's recommended to configure the portal data storage before staring iPortal(before creating the initial administrator account). The configuration information is in the iportal.xml configuration file in the installation directory (%SuperMap iPortal_HOME%\webapps\iportal\WEB-INF). For details, see: iPortal configuration file description. When using an Oracle database, you only need remove or delete the default SQLite database connection pool configuration information and add the Oracle database connection pool configuration information. The sample configuration is as follows:

<dbType>ORACLE</dbType>

<driverClass>oracle.jdbc.driver.OracleDriver</driverClass>

<jdbcUrl>jdbc:oracle:thin:@localhost:1521:iportal</jdbcUrl>

<maxPoolSize>30</maxPoolSize> 

<initialPoolSize>5</initialPoolSize> 

<minPoolSize>5</minPoolSize>

<maxIdleTime>3000</maxIdleTime> 

<maxWait>300000</maxWait> 

<username>orcluser1</username> 

<password></password>

• <dbType>: Database type, characters need to be uppercase.
• <driverClass>: The full name of the databas driver class.
• <jdbcUrl>: The url used to connect the driver. . If SuperMap iPortal and Oracle are on the same machine, the IP is localhost. If they are not on the same machine, the IP here should write the IP of the machine where Oracle is located. Oracle's default port is: 1521, which you can configure based on your actual installed Oracle. iportal is the database instance name, just the same as the database instance name you created.
• <maxPoolSize>: The maximum number of active connections the connection pool provides at the same time.
• <initialPoolSize>: The initial size of the connection pool.
• <minPoolSize>: The minimum number of active connections the connection pool provides at the same time.
• <maxIdleTime>: Maximum idle time, the connection is discarded if not used within maxIdleTime. The default value is 0 and if maxIdleTime is 0, it will never be discarded.
• <maxWait>: The maximum number of milliseconds the database waits for, when an exception occurs (when no connection is available).
• <username>: Username of the user, who has granted the database permission.
• <password>: Password of the user, who has granted the database permission.

Security information storage configuration

You can configure the iPortal security information storage after the iPortal is started. Log in to iPortal as the administrator, enter Management > Security, you can perform the security information configuration operations on the "Security Config" page. For details, see: Security information storage.