Oracle Driver not found in AEM 6.5

[shafali]

Hi

Even after uploading oracle driver bundle and doing respective configurations for creating Form Data Model in aem 6.5 version. I am getting below error .

Followed steps of below mentioned post to build osgi bundle.

https://www.albinsblog.com/2015/03/how-to-connect-to-oracle-database-using.html#.XrUSXqgzZPY

Error:

08.05.2020 13:26:12.042 *ERROR* [0:0:0:0:0:0:0:1 [1588924571999] POST /libs/fd/fdm/content/crud.dermis.formDataModelManager.json HTTP/1.1] org.apache.metamodel.jdbc.JdbcUtils Error code=0, SQL state=null

Caused by: java.lang.ClassNotFoundException: oracle.jdbc.OracleDriver not found by org.apache.sling.datasource [56]

[Suraj_Kamdi · Accepted solution]

@shafali 

Just try this adobe's official documentation on JDBC connection pool this https://docs.adobe.com/content/help/en/experience-manager-64/developing/platform/jdbc.html

and 

Here is the best example for implementing JDBC connection pool

https://helpx.adobe.com/in/experience-manager/kb/HowToConfigureSlingDatasource.html

Thanks & Regards,

Suraj Kamdi

[shafali]

Thanks Suraj it helped to reslove my issue

[erik_passadore]

Hello,

I have the same problem.

How did you solve your problem?

Thanks

Erik

[Suraj_Kamdi]

Just go through this adobe's official documentation on JDBC connection pool this https://docs.adobe.com/content/help/en/experience-manager-65/developing/platform/jdbc.html

Here is the best example for implementing JDBC connection pool

https://helpx.adobe.com/in/experience-manager/kb/HowToConfigureSlingDatasource.html

[erik_passadore]

Hi Suraj,

Thanks for your answer, I have already tried to follow these links but I still have the issue.

[Suraj_Kamdi]

@erik_passadore Please add code snippet or screenshots for better understanding of issue.

[erik_passadore]

Hi Suraj,

I'm following this link https://experienceleague.adobe.com/docs/experience-manager-64/developing/platform/jdbc.html?lang=en and I created a project with the following POM.

<project xmlns="https://maven.apache.org/POM/4.0.0"
         xmlns:xsi="https://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="https://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>

    <groupId>com.sygest.oracle</groupId>
    <artifactId>oracle-jdbc-driver-bundle</artifactId>
    <version>0.0.1-SNAPSHOT</version>
    <name>wrapper-bundle-oracle-driver</name>
    <description>Exports the Oracle JDBC driver</description>
    <packaging>bundle</packaging>
    <properties>
        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    </properties>
    <build>
        <plugins>
            <plugin>
                <groupId>org.apache.felix</groupId>
                <artifactId>maven-bundle-plugin</artifactId>
                <version>3.5.0</version>
                <extensions>true</extensions>
                <configuration>
                    <instructions>
                        <Embed-Dependency>*</Embed-Dependency>
                        <_exportcontents>com.oracle.jdbc.*</_exportcontents>
                    </instructions>
                </configuration>
            </plugin>
        </plugins>
    </build>
    <dependencies>
        <dependency>
            <groupId>com.oracle</groupId>
            <artifactId>oraclejdbc</artifactId>
            <version>1.0.0</version>
        </dependency>
    </dependencies>
</project>

When I build my bundle all is ok, but when I install the bundle on my AEM instance i have this error in the log file.

23.09.2021 09:01:06.637 *ERROR* [FelixDispatchQueue] com.sygest.oracle.jdbc-driver-bundle FrameworkEvent ERROR (org.osgi.framework.BundleException: Unable to resolve com.sygest.oracle.jdbc-driver-bundle [737](R 737.0): missing requirement [com.sygest.oracle.jdbc-driver-bundle [737](R 737.0)] osgi.wiring.package; (osgi.wiring.package=com.oracle.common.base) Unresolved requirements: [[com.sygest.oracle.jdbc-driver-bundle [737](R 737.0)] osgi.wiring.package; (osgi.wiring.package=com.oracle.common.base)])
org.osgi.framework.BundleException: Unable to resolve com.sygest.oracle.jdbc-driver-bundle [737](R 737.0): missing requirement [com.sygest.oracle.jdbc-driver-bundle [737](R 737.0)] osgi.wiring.package; (osgi.wiring.package=com.oracle.common.base) Unresolved requirements: [[com.sygest.oracle.jdbc-driver-bundle [737](R 737.0)] osgi.wiring.package; (osgi.wiring.package=com.oracle.common.base)]
	at org.apache.felix.framework.Felix.resolveBundleRevision(Felix.java:4368)
	at org.apache.felix.framework.Felix.startBundle(Felix.java:2281)
	at org.apache.felix.framework.Felix.setBundleStartLevel(Felix.java:1727)
	at org.apache.felix.framework.FrameworkStartLevelImpl.run(FrameworkStartLevelImpl.java:338)
	at java.lang.Thread.run(Thread.java:745)

If I create my bundle in other way (for example with eclipse) I have this other error.

23.09.2021 08:55:24.170 *WARN* [[0:0:0:0:0:0:0:1] [1632380124164] POST /libs/fd/fdm/content/crud.dermis.formDataModelManager.json HTTP/1.1] com.googlecode.jsonrpc4j.JsonRpcBasicServer Error in JSON-RPC Service
org.apache.metamodel.MetaModelException: Could not establish connection: oracle.jdbc.OracleDriver not found by org.apache.sling.datasource [65]
	at org.apache.metamodel.jdbc.JdbcUtils.wrapException(JdbcUtils.java:76) [aem-dermis-core:3.0.176]

[MorisMonk]

@erik_passadore try this one https://github.com/chenjiou/ojdbc8-osgi/blob/master/pom.xml

[Suraj_Kamdi]

@shafaliI am Happy to help...

Please connect me on LinkedIn https://www.linkedin.com/in/suraj-kamdi-95a80194/  

[Suraj_Kamdi]

@shafali 

I think you have not added Oracle JDBC dependency in your Pom.xml 

https://mvnrepository.com/search?q=jdbc+oracle