Oracle Database connection from AEM as a cloud service

Description

The below steps contains the required maven dependency, OSGi service and configurations required to connect the Oracle database from AEM as a cloud service.

Resolution

To connect the oracle database from AEM as a cloud service, please follow the below 3.

• Adding Maven dependency in pom
• AEM Service to connect with Oracle database
• OSGi Configuration

Adding Maven dependency in pom

Step 1: Include the below maven dependency in your projects main pom.xml

dependency
                groupIdcom.oracle.database.jdbc/groupId
                artifactIdojdbc-bom/artifactId
                version21.5.0.0/version
                typepom/type
                scopeimport/scope
            /dependency

Step 2 : Include the below maven dependency in pom.xml of both “core” and “all”.

dependency
            groupIdcom.oracle.database.jdbc/groupId
            artifactIdojdbc8/artifactId
        /dependency
        dependency
            groupIdcom.oracle.database.jdbc/groupId
            artifactIducp/artifactId
        /dependency
        dependency
            groupIdcom.oracle.database.xml/groupId
            artifactIdxdb/artifactId
        /dependency

AEM Service to connect with Oracle database

Sample service code to connect with the database from AEM as a cloud service, it can be included in the path 0

0 project folder - core - service

DatabaseService.java
package com.mysite.core.services;
public interface DatabaseService {}
DatabaseServiceImpl.java
package com.mysite.core.services;
import com.day.commons.datasource.poolservice.DataSourcePool;
import org.osgi.service.component.annotations.Activate;
import org.osgi.service.component.annotations.Component;
import org.osgi.service.component.annotations.Reference;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import javax.sql.DataSource;
import java.sql.Connection;
@Component(  service = DatabaseService.class,   immediate = true) public class DatabaseServiceImpl implements DatabaseService {
    private final Logger LOGGER = LoggerFactory.getLogger(DatabaseService.class);
    @Reference   private DataSourcePool dataSourcePool;
    @Activate   public void activate() {
        try {
            DataSource dataSource = (DataSource) dataSourcePool.getDataSource("oracle");
            Connection connection = dataSource.getConnection();
            if (connection != null) {
                if (!connection.isClosed()) {
                    LOGGER.info("Connected with connection #4");
                    connection.close();
                }
            }
            else {
                LOGGER.info("Connection is null");
            }
        } catch (Exception ex) {
            LOGGER.error("It was not possible to get the data source: " + ex.getMessage(), ex);
        }
    }
}

OSGi Configuration

 Step 1: Go to AEM OSGI configuration2 in local

Step 2: Search for “JDBC Connection pool” and configuration the below values with respect to your DB (refer to screenshot for sample values)

• JDBC Driver class
• JDBC Connection URL
• Username and Password
• Datasource name

Step 3: Follow the steps in 3 and convert the osgi configuration into “.cfg.json” file and add the same into your project configuration as per AEMaaCS Standard.

2 http://localhost:4502/system/console/configMgr

3 https://experienceleague.adobe.com/docs/experience-manager-cloud-service/content/implementing/deploying/configuring-osgi.html?lang=en#generating-osgi-configurations-using-the-aem-sdk-quickstart

Business.Adobe.com resources