Expand my Community achievements bar.

SOLVED

Oracle Driver not found in AEM 6.5

Avatar

Level 2

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]

 

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

@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

 

 

View solution in original post

10 Replies

Avatar

Correct answer by
Community Advisor

@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

 

 

Avatar

Level 2

Hello,

I have the same problem.

How did you solve your problem?

 

Thanks

Erik

Avatar

Level 2

Hi Suraj,

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

Avatar

Community Advisor

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

Avatar

Level 2

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]

 

 

Avatar

Community Advisor

@shafali 

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

 

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