java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver

[aroc725]

I'm trying to run a Spring MVC application I've 'inherited', but it's not starting up. I'm getting the following error message listed below. The JAR file for Oracle database access is located within the "\spring-insight-instance\wtpwebapps\myapp\WEB-INF\lib" subdirectory of the tc server install directory.

Do I need to copy the JAR file to this subdirectory?

C:\springsource\vfabric-tc-server-developer-2.6.0.RELEASE\spring-insight-instance\lib

WARNING: Unexpected exception resolving reference
java.sql.SQLException: oracle.jdbc.driver.OracleDriver
at org.apache.tomcat.jdbc.pool.PooledConnection.conne ctUsingDriver(PooledConnection.java:243)
at org.apache.tomcat.jdbc.pool.PooledConnection.conne ct(PooledConnection.java:176)
at org.apache.tomcat.jdbc.pool.ConnectionPool.createC onnection(ConnectionPool.java:655)
at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowC onnection(ConnectionPool.java:597)
at org.apache.tomcat.jdbc.pool.ConnectionPool.init(Co nnectionPool.java:460)
at org.apache.tomcat.jdbc.pool.ConnectionPool.<init>( ConnectionPool.java:130)
at org.apache.tomcat.jdbc.pool.DataSourceProxy.pCreat ePool(DataSourceProxy.java:112)
at org.apache.tomcat.jdbc.pool.DataSourceProxy.create Pool(DataSourceProxy.java:99)
at org.apache.tomcat.jdbc.pool.DataSourceFactory.crea teDataSource(DataSourceFactory.java:499)
at org.apache.tomcat.jdbc.pool.DataSourceFactory.getO bjectInstance(DataSourceFactory.java:222)
at org.apache.naming.factory.ResourceFactory.getObjec tInstance(ResourceFactory.java:143)
at javax.naming.spi.NamingManager.getObjectInstance(N amingManager.java:304)
at org.apache.naming.NamingContext.lookup(NamingConte xt.java:826)
at org.apache.naming.NamingContext.lookup(NamingConte xt.java:145)
at org.apache.naming.NamingContext.lookup(NamingConte xt.java:814)
at org.apache.naming.NamingContext.lookup(NamingConte xt.java:145)
at org.apache.naming.NamingContext.lookup(NamingConte xt.java:814)
at org.apache.naming.NamingContext.lookup(NamingConte xt.java:145)
at org.apache.naming.NamingContext.lookup(NamingConte xt.java:814)
at org.apache.naming.NamingContext.lookup(NamingConte xt.java:159)
at org.apache.catalina.core.NamingContextListener.add Resource(NamingContextListener.java:1021)
at org.apache.catalina.core.NamingContextListener.cre ateNamingContext(NamingContextListener.java:631)
at org.apache.catalina.core.NamingContextListener.lif ecycleEvent(NamingContextListener.java:237)
at org.apache.catalina.util.LifecycleSupport.fireLife cycleEvent(LifecycleSupport.java:119)
at org.apache.catalina.util.LifecycleBase.fireLifecyc leEvent(LifecycleBase.java:89)
at org.apache.catalina.core.StandardServer.startInter nal(StandardServer.java:719)
at org.apache.catalina.util.LifecycleBase.start(Lifec ycleBase.java:145)
at org.apache.catalina.startup.Catalina.start(Catalin a.java:621)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Native MethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.startup.Bootstrap.start(Bootst rap.java:322)
at org.apache.catalina.startup.Bootstrap.main(Bootstr ap.java:450)
Caused by: java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
at org.aspectj.weaver.bcel.ExtensibleURLClassLoader.f indClass(ExtensibleURLClassLoader.java:54)
at java.lang.ClassLoader.loadClass(ClassLoader.java:3 06)
at java.lang.ClassLoader.loadClass(ClassLoader.java:2 47)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:247)
at org.apache.tomcat.jdbc.pool.PooledConnection.conne ctUsingDriver(PooledConnection.java:236)
... 33 more

[aroc725]

Yep, copying the Oracle JAR file to the '\spring-insight-instance\lib' subdirectory of the tc server directory fixed the 'ClassNotException' error.