Sam, I was quick to send the email. I got the ClassNotFoundException on jboss but when tested with tomcat it worked fine. It seems I'm through with the db query.
Thanks for your help. -- Rajah On Tue, Sep 16, 2008 at 10:34 AM, Rajah Kalipatnapu <[EMAIL PROTECTED]>wrote: > Hi Sam, > > Thanks for the tip. I expected that, it is going to fix the problem but I > still got the ClassNotFoundException. Any thing else need to be fixed? > > I do see that now the jar file is exported. > > [EMAIL PROTECTED] deploy]# jar tvf dirlisting.war | grep mysql > 459094 Tue Sep 16 10:09:44 PDT 2008 > WEB-INF/eclipse/plugins/MwediaExample_0.0.0/project/Dependencies/mysql-connector-java-3.1.14-bin.jar > > What else could be wrong? > > -- Regards, > Rajah > On Tue, Sep 16, 2008 at 6:58 AM, Sam Hopkins <[EMAIL PROTECTED]>wrote: > >> Hello Rajah, >> >> >> >> Did you drag and drop the jdbc driver into the Dependencies directory in >> your OpenVXML application project? If not, please give that a try and let us >> know how it goes. >> >> >> >> --Sam Hopkins >> >> >> >> >> >> >> >> *From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] >> *On Behalf Of *Rajah Kalipatnapu >> *Sent:* Monday, September 15, 2008 6:23 PM >> *To:* Voice Tools general developers >> *Subject:* [vtp-dev] OpenVXML IVR app: >> java.lang.ClassNotFoundException:com.mysql.jdbc.Driver >> >> >> >> 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. >> >> No virus found in this incoming message. >> Checked by AVG - http://www.avg.com >> Version: 8.0.169 / Virus Database: 270.6.21/1672 - Release Date: 9/15/2008 >> 9:21 AM >> >> _______________________________________________ >> vtp-dev mailing list >> [email protected] >> https://dev.eclipse.org/mailman/listinfo/vtp-dev >> >> >
_______________________________________________ vtp-dev mailing list [email protected] https://dev.eclipse.org/mailman/listinfo/vtp-dev
