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]
Solved! Go to Solution.
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
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
Hello,
I have the same problem.
How did you solve your problem?
Thanks
Erik
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
Hi Suraj,
Thanks for your answer, I have already tried to follow these links but I still have the issue.
@erik_passadore Please add code snippet or screenshots for better understanding of issue.
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]
@shafaliI am Happy to help...
Please connect me on LinkedIn https://www.linkedin.com/in/suraj-kamdi-95a80194/
I think you have not added Oracle JDBC dependency in your Pom.xml
Views
Likes
Replies