Hi,
We are developing an IVR application that uses a Database connection. We are using MySQL with jdbc Database Look up option.
We exported the war and deployed we get ClassNotFoundException. I've attached the stack trace below.
We tried the following to fix it both on tomcat and jboss.
Jar file is "mysql-connector-java-3.1.14-bin.jar"
1. Copy the jar file to common/lib for tomcat.
2. Copy the jar file to WEB-INF/lib for both tomcat and jboss.
3. Copy the jar file to all the lib directories in tomcat and jboss.
But none of worked. I expected that while exporting the application I'll get an option to include the dependent jar files but I didn't get any such options.
Any help is appreciated.
-- Regards,
Rajah
15:43:03,413 INFO [STDOUT] INFO |2008/09/15|15:43:03|p=MwediaExample|s=E9DE0CBD483AE0D073089D28F041CE47|e=0003> Execution "3" Ended
15:43:06,953 INFO [STDOUT] INFO |2008/09/15|15:43:06|p=MwediaExample|s=E9DE0CBD483AE0D073089D28F041CE47|e=0004> Execution "4" Started
15:43:06,953 INFO [STDOUT] INFO |2008/09/15|15:43:06|p=MwediaExample|s=E9DE0CBD483AE0D073089D28F041CE47|e=0004> Action "ServiceOptions" Starting
15:43:06,955 INFO [STDOUT] DEBUG|2008/09/15|15:43:06|p=MwediaExample|s=E9DE0CBD483AE0D073089D28F041CE47|e=0004> SelectionRequestAction
15:43:06,955 INFO [STDOUT] INFO |2008/09/15|15:43:06|p=MwediaExample|s=E9DE0CBD483AE0D073089D28F041CE47|e=0004> Got requested selection "Direcotry Listing"
15:43:06,956 INFO [STDOUT] INFO |2008/09/15|15:43:06|p=MwediaExample|s=E9DE0CBD483AE0D073089D28F041CE47|e=0004> Action "ServiceOptions" Ended
15:43:06,956 INFO [STDOUT] INFO |2008/09/15|15:43:06|p=MwediaExample|s=E9DE0CBD483AE0D073089D28F041CE47|e=0004> Action "Database Query" Starting
15:43:06,960 INFO [STDOUT] ERROR|2008/09/15|15:43:06|p=MwediaExample> com.mysql.jdbc.Driver
ERROR|2008/09/15|15:43:06|p=MwediaExample> java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
ERROR|2008/09/15|15:43:06|p=MwediaExample> at java.lang.ClassLoader.findClass(Unknown Source)
ERROR|2008/09/15|15:43:06|p=MwediaExample> at java.lang.ClassLoader.loadClass(Unknown Source)
ERROR|2008/09/15|15:43:06|p=MwediaExample> at java.lang.ClassLoader.loadClass(Unknown Source)
ERROR|2008/09/15|15:43:06|p=MwediaExample> at org.eclipse.osgi.framework.internal.core.BundleLoader.findClassInternal(BundleLoader.java:429)
ERROR|2008/09/15|15:43:06|p=MwediaExample> at org.eclipse.osgi.framework.internal.core.BundleLoader.findClass(BundleLoader.java:369)
ERROR|2008/09/15|15:43:06|p=MwediaExample> at org.eclipse.osgi.framework.internal.core.BundleLoader.findClass(BundleLoader.java:357)
ERROR|2008/09/15|15:43:06|p=MwediaExample> at org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader.loadClass(DefaultClassLoader.java:83)
ERROR|2008/09/15|15:43:06|p=MwediaExample> at java.lang.ClassLoader.loadClass(Unknown Source)
ERROR|2008/09/15|15:43:06|p=MwediaExample> at org.eclipse.osgi.framework.internal.core.BundleLoader.loadClass(BundleLoader.java:289)
ERROR|2008/09/15|15:43:06|p=MwediaExample> at org.eclipse.osgi.framework.internal.core.BundleHost.loadClass(BundleHost.java:227)
ERROR|2008/09/15|15:43:06|p=MwediaExample> at org.eclipse.osgi.framework.internal.core.AbstractBundle.loadClass(AbstractBundle.java:1269)
ERROR|2008/09/15|15:43:06|p=MwediaExample> at org.eclipse.vtp.framework.engine.http.Deployment.loadClass(Deployment.java:265)
ERROR|2008/09/15|15:43:06|p=MwediaExample> at org.eclipse.vtp.framework.engine.support.AbstractProcessContext.loadClass(AbstractProcessContext.java:167)
ERROR|2008/09/15|15:43:06|p=MwediaExample> at org.eclipse.vtp.framework.engine.support.ProcessContextWrapper.loadClass(ProcessContextWrapper.java:426)
ERROR|2008/09/15|15:43:06|p=MwediaExample> at org.eclipse.vtp.framework.databases.services.DatabaseRegistry$JdbcDatabase.<init>(DatabaseRegistry.java:257)
ERROR|2008/09/15|15:43:06|p=MwediaExample> at org.eclipse.vtp.framework.databases.services.DatabaseRegistry.<init>(DatabaseRegistry.java:78)
ERROR|2008/09/15|15:43:06|p=MwediaExample> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
ERROR|2008/09/15|15:43:06|p=MwediaExample> at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
ERROR|2008/09/15|15:43:06|p=MwediaExample> at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
ERROR|2008/09/15|15:43:06|p=MwediaExample> at java.lang.reflect.Constructor.newInstance(Unknown Source)
ERROR|2008/09/15|15:43:06|p=MwediaExample> at org.eclipse.vtp.framework.engine.runtime.RuntimeUtils.createInstance(RuntimeUtils.java:142)
ERROR|2008/09/15|15:43:06|p=MwediaExample> at org.eclipse.vtp.framework.engine.runtime.Builder.create(Builder.java:75)
ERROR|2008/09/15|15:43:06|p=MwediaExample> at org.eclipse.vtp.framework.engine.runtime.Scope.getServiceInstance(Scope.java:99)
ERROR|2008/09/15|15:43:06|p=MwediaExample> at org.eclipse.vtp.framework.engine.runtime.Service.getInstance(Service.java:224)
ERROR|2008/09/15|15:43:06|p=MwediaExample> at org.eclipse.vtp.framework.engine.runtime.Scope.lookupInScope(Scope.java:58)
ERROR|2008/09/15|15:43:06|p=MwediaExample> at org.eclipse.vtp.framework.engine.runtime.Process.lookupInScope(Process.java:64)
ERROR|2008/09/15|15:43:06|p=MwediaExample> at org.eclipse.vtp.framework.engine.runtime.Process$Context.lookupLocalService(Process.java:191)
ERROR|2008/09/15|15:43:06|p=MwediaExample> at org.eclipse.vtp.framework.engine.support.AbstractContext.lookup(AbstractContext.java:121)
ERROR|2008/09/15|15:43:06|p=MwediaExample> at org.eclipse.vtp.framework.engine.support.AbstractSessionContext.lookupInheritedService(AbstractSessionContext.java:160)
ERROR|2008/09/15|15:43:06|p=MwediaExample> at org.eclipse.vtp.framework.engine.support.AbstractContext.lookup(AbstractContext.java:124)
ERROR|2008/09/15|15:43:06|p=MwediaExample> at org.eclipse.vtp.framework.engine.support.AbstractExecutionContext.lookupInheritedService(AbstractExecutionContext.java:150)
ERROR|2008/09/15|15:43:06|p=MwediaExample> at org.eclipse.vtp.framework.engine.support.AbstractContext.lookup(AbstractContext.java:124)
ERROR|2008/09/15|15:43:06|p=MwediaExample> at org.eclipse.vtp.framework.engine.support.AbstractActionContext.lookupInheritedService(AbstractActionContext.java:112)
ERROR|2008/09/15|15:43:06|p=MwediaExample> at org.eclipse.vtp.framework.engine.support.AbstractContext.lookup(AbstractContext.java:124)
ERROR|2008/09/15|15:43:06|p=MwediaExample> at org.eclipse.vtp.framework.engine.runtime.Executable$ActionContext.lookup(Executable.java:159)
ERROR|2008/09/15|15:43:06|p=MwediaExample> at org.eclipse.vtp.framework.engine.runtime.Builder.resolveDependency(Builder.java:151)
ERROR|2008/09/15|15:43:06|p=MwediaExample> at org.eclipse.vtp.framework.engine.runtime.Builder.create(Builder.java:64)
ERROR|2008/09/15|15:43:06|p=MwediaExample> at org.eclipse.vtp.framework.engine.runtime.Executable.createInstance(Executable.java:115)
ERROR|2008/09/15|15:43:06|p=MwediaExample> at org.eclipse.vtp.framework.engine.runtime.Action.execute(Action.java:133)
ERROR|2008/09/15|15:43:06|p=MwediaExample> at org.eclipse.vtp.framework.engine.runtime.Sequence.next(Sequence.java:108)
ERROR|2008/09/15|15:43:06|p=MwediaExample> at org.eclipse.vtp.framework.engine.runtime.Execution$1.run(Execution.java:173)
ERROR|2008/09/15|15:43:06|p=MwediaExample> at org.eclipse.vtp.framework.engine.http.DeploymentExecution.visitRunnable(DeploymentExecution.java:461)
ERROR|2008/09/15|15:43:06|p=MwediaExample> at org.eclipse.vtp.framework.engine.runtime.Execution$1.accept(Execution.java:187)
ERROR|2008/09/15|15:43:06|p=MwediaExample> at org.eclipse.vtp.framework.engine.http.DeploymentExecution.doNext(DeploymentExecution.java:191)
ERROR|2008/09/15|15:43:06|p=MwediaExample> at org.eclipse.vtp.framework.engine.http.DeploymentSession.next(DeploymentSession.java:206)
ERROR|2008/09/15|15:43:06|p=MwediaExample> at org.eclipse.vtp.framework.engine.http.Deployment.next(Deployment.java:167)
ERROR|2008/09/15|15:43:06|p=MwediaExample> at org.eclipse.vtp.framework.engine.http.HttpConnector.invokeProcessEngine(HttpConnector.java:376)
ERROR|2008/09/15|15:43:06|p=MwediaExample> at org.eclipse.vtp.framework.engine.http.HttpConnector.process(HttpConnector.java:287)
ERROR|2008/09/15|15:43:06|p=MwediaExample> at org.eclipse.vtp.framework.engine.http.HttpConnectorServlet.process(HttpConnectorServlet.java:121)
ERROR|2008/09/15|15:43:06|p=MwediaExample> at org.eclipse.vtp.framework.engine.http.HttpConnectorServlet.doGet(HttpConnectorServlet.java:142)
ERROR|2008/09/15|15:43:06|p=MwediaExample> at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
ERROR|2008/09/15|15:43:06|p=MwediaExample> at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
ERROR|2008/09/15|15:43:06|p=MwediaExample> at org.eclipse.equinox.http.servlet.internal.ServletRegistration.handleRequest(ServletRegistration.java:90)
ERROR|2008/09/15|15:43:06|p=MwediaExample> at org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:111)
ERROR|2008/09/15|15:43:06|p=MwediaExample> at org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:75)
ERROR|2008/09/15|15:43:06|p=MwediaExample> at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
ERROR|2008/09/15|15:43:06|p=MwediaExample> at org.eclipse.equinox.servletbridge.BridgeServlet.service(BridgeServlet.java:115)
ERROR|2008/09/15|15:43:06|p=MwediaExample> at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
ERROR|2008/09/15|15:43:06|p=MwediaExample> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
ERROR|2008/09/15|15:43:06|p=MwediaExample> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
ERROR|2008/09/15|15:43:06|p=MwediaExample> at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
ERROR|2008/09/15|15:43:06|p=MwediaExample> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
ERROR|2008/09/15|15:43:06|p=MwediaExample> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
ERROR|2008/09/15|15:43:06|p=MwediaExample> at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
ERROR|2008/09/15|15:43:06|p=MwediaExample> at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
ERROR|2008/09/15|15:43:06|p=MwediaExample> at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179)
ERROR|2008/09/15|15:43:06|p=MwediaExample> at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
ERROR|2008/09/15|15:43:06|p=MwediaExample> at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
ERROR|2008/09/15|15:43:06|p=MwediaExample> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
ERROR|2008/09/15|15:43:06|p=MwediaExample> at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
ERROR|2008/09/15|15:43:06|p=MwediaExample> at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
ERROR|2008/09/15|15:43:06|p=MwediaExample> at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
ERROR|2008/09/15|15:43:06|p=MwediaExample> at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
ERROR|2008/09/15|15:43:06|p=MwediaExample> at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
ERROR|2008/09/15|15:43:06|p=MwediaExample> at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
ERROR|2008/09/15|15:43:06|p=MwediaExample> at java.lang.Thread.run(Unknown Source)
15:43:06,964 INFO [STDOUT] INFO |2008/09/15|15:43:06|p=MwediaExample|s=E9DE0CBD483AE0D073089D28F041CE47|e=0004> Preparing SQL statement.
15:43:06,964 INFO [STDOUT] INFO |2008/09/15|15:43:06|p=MwediaExample|s=E9DE0CBD483AE0D073089D28F041CE47|e=0004> SQL query complete.
15:43:06,964 INFO [STDOUT] INFO |2008/09/15|15:43:06|p=MwediaExample|s=E9DE0CBD483AE0D073089D28F041CE47|e=0004> Action "Database Query" Ended
15:43:06,964 INFO [STDOUT] INFO |2008/09/15|15:43:06|p=MwediaExample|s=E9DE0CBD483AE0D073089D28F041CE47|e=0004> Execution "4" Ended
15:43:06,965 INFO [STDOUT] INFO |2008/09/15|15:43:06|p=MwediaExample|s=E9DE0CBD483AE0D073089D28F041CE47|e=0005> Session "E9DE0CBD483AE0D073089D28F041CE47" Terminated
15:43:06,966 INFO [STDOUT] INFO |2008/09/15|15:43:06|p=MwediaExample|s=E9DE0CBD483AE0D073089D28F041CE47> Session "E9DE0CBD483AE0D073089D28F041CE47" disposed.
