Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-8930

i am using JBoos 4.1.2 and exection SQL's for DB2

    XMLWordPrintable

Details

    • Support Request
    • Resolution: Timed out
    • Medium
    • None
    • None
    • None
    • None

    Description

      java.sql.SQLException: Table not found: USR_USERS in statement [select usr_id from GLR.usr_users where lower(usr_email) = ? and usr_password = ? and usr_active ='T']
      14:36:47,423 INFO [STDOUT] at org.hsqldb.jdbc.Util.throwError(Unknown Source)
      14:36:47,423 INFO [STDOUT] at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)
      14:36:47,423 INFO [STDOUT] at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
      14:36:47,423 INFO [STDOUT] at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.prepareStatement(BaseWrapperManagedConnection.java:360)
      14:36:47,423 INFO [STDOUT] at org.jboss.resource.adapter.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:205)
      14:36:47,423 INFO [STDOUT] at com.hp.GLTool.data.UsersDAC.validateUserLogin(UsersDAC.java:91)
      14:36:47,423 INFO [STDOUT] at com.hp.GLTool.ejb.ThesaurusBean.ValidateUserLogin(ThesaurusBean.java:128)
      14:36:47,423 INFO [STDOUT] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      14:36:47,423 INFO [STDOUT] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      14:36:47,423 INFO [STDOUT] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      14:36:47,423 INFO [STDOUT] at java.lang.reflect.Method.invoke(Method.java:324)
      14:36:47,423 INFO [STDOUT] at org.jboss.invocation.Invocation.performCall(Invocation.java:345)
      14:36:47,423 INFO [STDOUT] at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:214)
      14:36:47,423 INFO [STDOUT] at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:185)
      14:36:47,423 INFO [STDOUT] at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:130)
      14:36:47,423 INFO [STDOUT] at org.jboss.webservice.server.ServiceEndpointInterceptor.invoke(ServiceEndpointInterceptor.java:51)
      14:36:47,423 INFO [STDOUT] at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:48)
      14:36:47,423 INFO [STDOUT] at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:105)
      14:36:47,423 INFO [STDOUT] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:335)
      14:36:47,423 INFO [STDOUT] at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:166)
      14:36:47,423 INFO [STDOUT] at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:139)
      14:36:47,423 INFO [STDOUT] at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:192)
      14:36:47,423 INFO [STDOUT] at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
      14:36:47,423 INFO [STDOUT] at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:624)
      14:36:47,438 INFO [STDOUT] at org.jboss.ejb.Container.invoke(Container.java:873)
      14:36:47,438 INFO [STDOUT] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      14:36:47,438 INFO [STDOUT] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      14:36:47,438 INFO [STDOUT] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      14:36:47,438 INFO [STDOUT] at java.lang.reflect.Method.invoke(Method.java:324)
      14:36:47,438 INFO [STDOUT] at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
      14:36:47,438 INFO [STDOUT] at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
      14:36:47,438 INFO [STDOUT] at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
      14:36:47,438 INFO [STDOUT] at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:249)
      14:36:47,438 INFO [STDOUT] at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
      14:36:47,438 INFO [STDOUT] at org.jboss.invocation.local.LocalInvoker$MBeanServerAction.invoke(LocalInvoker.java:155)
      14:36:47,438 INFO [STDOUT] at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:104)
      14:36:47,438 INFO [STDOUT] at org.jboss.invocation.InvokerInterceptor.invokeLocal(InvokerInterceptor.java:179)
      14:36:47,438 INFO [STDOUT] at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:165)
      14:36:47,438 INFO [STDOUT] at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:46)
      14:36:47,438 INFO [STDOUT] at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:55)
      14:36:47,438 INFO [STDOUT] at org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInterceptor.java:97)
      14:36:47,438 INFO [STDOUT] at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:86)
      14:36:47,438 INFO [STDOUT] at $Proxy60.ValidateUserLogin(Unknown Source)
      14:36:47,438 INFO [STDOUT] at com.hp.GLTool.controller.MySessionBean.submitAction(MySessionBean.java:559)
      14:36:47,438 INFO [STDOUT] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      14:36:47,438 INFO [STDOUT] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      14:36:47,438 INFO [STDOUT] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      14:36:47,438 INFO [STDOUT] at java.lang.reflect.Method.invoke(Method.java:324)
      14:36:47,438 INFO [STDOUT] at org.apache.myfaces.el.MethodBindingImpl.invoke(MethodBindingImpl.java:129)
      14:36:47,438 INFO [STDOUT] at org.apache.myfaces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:63)
      14:36:47,438 INFO [STDOUT] at javax.faces.component.UICommand.broadcast(UICommand.java:106)
      14:36:47,438 INFO [STDOUT] at javax.faces.component.UIViewRoot._broadcastForPhase(UIViewRoot.java:90)
      14:36:47,438 INFO [STDOUT] at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:164)
      14:36:47,438 INFO [STDOUT] at org.apache.myfaces.lifecycle.LifecycleImpl.invokeApplication(LifecycleImpl.java:316)
      14:36:47,438 INFO [STDOUT] at org.apache.myfaces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:86)
      14:36:47,438 INFO [STDOUT] at javax.faces.webapp.FacesServlet.service(FacesServlet.java:106)
      14:36:47,438 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
      14:36:47,438 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      14:36:47,438 INFO [STDOUT] at org.apache.myfaces.component.html.util.ExtensionsFilter.doFilter(ExtensionsFilter.java:122)
      14:36:47,438 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      14:36:47,438 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      14:36:47,438 INFO [STDOUT] at com.hp.GLTool.common.SessionCheckFilter.doFilter(SessionCheckFilter.java:65)
      14:36:47,438 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      14:36:47,438 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      14:36:47,438 INFO [STDOUT] at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81)
      14:36:47,438 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      14:36:47,438 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      14:36:47,438 INFO [STDOUT] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
      14:36:47,438 INFO [STDOUT] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
      14:36:47,438 INFO [STDOUT] at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39)
      14:36:47,438 INFO [STDOUT] at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:153)
      14:36:47,438 INFO [STDOUT] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:407)
      14:36:47,438 INFO [STDOUT] at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59)
      14:36:47,438 INFO [STDOUT] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
      14:36:47,438 INFO [STDOUT] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
      14:36:47,438 INFO [STDOUT] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
      14:36:47,438 INFO [STDOUT] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
      14:36:47,438 INFO [STDOUT] at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
      14:36:47,438 INFO [STDOUT] at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
      14:36:47,438 INFO [STDOUT] at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
      14:36:47,438 INFO [STDOUT] at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
      14:36:47,438 INFO [STDOUT] at java.lang.Thread.run(Thread.java:534)

      Attachments

        Activity

          People

            Unassigned Unassigned
            bdf105647380 Srikanth Reddy
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: