Welcome to Knowage Q&A, where you can ask questions and receive answers from other members of the community.
0 votes
1 view

Hi,

I am trying to connect KNOWAGE with Oracle database and getting this following error. If someone can help me to resolve this error.

Here is the error partly from catalina.out

Caused by: java.lang.ClassNotFoundException: Unable to load class: oracle.jdbc.driver.OracleDriver from ClassLoader:java.net.URLClassLoader@1218025c;ClassLoader:ParallelWebappClassLoader

  context: knowage

  delegate: false

----------> Parent Classloader:

Here is Server.xml

Caused by: 

 

Part from Catalina.outCatalina.out

07-Jul-2022 13:13:21.528 SEVERE [main] org.apache.tomcat.jdbc.pool.ConnectionPool.init Unable to create initial connections of pool.

java.sql.SQLException: Unable to load class: oracle.jdbc.driver.OracleDriver from 

ClassLoader:java.net.URLClassLoader@548c4f57;ClassLoader:java.net.URLClassLoader@548c4f57

at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:292)

at org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:212)

at org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:736)

at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:668)

at org.apache.tomcat.jdbc.pool.ConnectionPool.init(ConnectionPool.java:483)

at org.apache.tomcat.jdbc.pool.ConnectionPool.<init>(ConnectionPool.java:154)

at org.apache.tomcat.jdbc.pool.DataSourceProxy.pCreatePool(DataSourceProxy.java:118)

at org.apache.tomcat.jdbc.pool.DataSourceProxy.createPool(DataSourceProxy.java:107)

at org.apache.tomcat.jdbc.pool.DataSourceFactory.createDataSource(DataSourceFactory.java:560)

at org.apache.tomcat.jdbc.pool.DataSourceFactory.getObjectInstance(DataSourceFactory.java:244)

at org.apache.naming.factory.FactoryBase.getObjectInstance(FactoryBase.java:94)

at javax.naming.spi.NamingManager.getObjectInstance(NamingManager.java:331)

at org.apache.naming.NamingContext.lookup(NamingContext.java:839)

at org.apache.naming.NamingContext.lookup(NamingContext.java:159)

at org.apache.naming.NamingContext.lookup(NamingContext.java:827)

at org.apache.naming.NamingContext.lookup(NamingContext.java:173)

at org.apache.catalina.core.NamingContextListener.addResource(NamingContextListener.java:1017)

at org.apache.catalina.core.NamingContextListener.createNamingContext(NamingContextListener.java:557)

at org.apache.catalina.core.NamingContextListener.lifecycleEvent(NamingContextListener.java:253)

at org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.java:94)

at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:762)

at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)

at org.apache.catalina.startup.Catalina.start(Catalina.java:688)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:498)

at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:353)

at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:493)

Caused by: java.lang.ClassNotFoundException: Unable to load class: oracle.jdbc.driver.OracleDriver from ClassLoader:java.net.URLClassLoader@548c4f57;ClassLoader:java.net.URLClassLoader@548c4f57

at org.apache.tomcat.jdbc.pool.ClassLoaderUtil.loadClass(ClassLoaderUtil.java:56)

at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:280)

Thanks

Abu Muyeen

Environment Environment Knowage 7.4, LINUX (Redhat 7.9), Oracle database 2.2
in Installer by (320 points)

1 Answer

+1 vote
Hi,

looking at your error I think you miss the Oracle JDBC driver in the lib folder of Tomcat.

On our test environments we use the official driver from Oracle. You can get it from:

https://broadinstitute.jfrog.io/artifactory/libs-release-local/com/oracle/jdbc/ojdbc8/12.2.0.1/ojdbc8-12.2.0.1.jar
by (5.1k points)

Hi,

I did add the jar file but getting same error.

Thanks

Abu

...