Expand my Community achievements bar.

Don’t miss the AEM Skill Exchange in SF on Nov 14—hear from industry leaders, learn best practices, and enhance your AEM strategy with practical tips.
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