java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Invalid object name 'USERS'.Error Code: 208 > Call:SELECT MSISDN, PASSWORD, ADDRESS, FIRSTNAME, BROKERACC, AGE, LASTNAME, DEVICEID FROM USERS > Query:ReportQuery(commerc.Users) >

Oracle Community | deepak1234 | 10 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    MS SQL Server 2000 for JDBC with NetBeans IDE 5.5 and Java EE 5

    Oracle Community | 10 years ago | deepak1234
    java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Invalid object name 'USERS'.Error Code: 208 > Call:SELECT MSISDN, PASSWORD, ADDRESS, FIRSTNAME, BROKERACC, AGE, LASTNAME, DEVICEID FROM USERS > Query:ReportQuery(commerc.Users) >
  2. 0

    GlassFish Users - java.sql.SQLException: Error in allocating a connection

    nabble.com | 9 months ago
    java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Invalid object name 'Users'.Error Code: 208 > Call:SELECT MSISDN, Password, address, FirstName, BrokerAcc, age, LastName, DeviceID FROM Users > Query:ReportQuery(commerce.Users)

    Root Cause Analysis

    1. java.sql.SQLException

      [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Invalid object name 'USERS'.Error Code: 208 > Call:SELECT MSISDN, PASSWORD, ADDRESS, FIRSTNAME, BROKERACC, AGE, LASTNAME, DEVICEID FROM USERS > Query:ReportQuery(commerc.Users) >

      at oracle.toplink.essentials.exceptions.DatabaseException.sqlException()
    2. oracle.toplink.essentials
      EJBQueryImpl.getResultList
      1. oracle.toplink.essentials.exceptions.DatabaseException.sqlException(DatabaseException.java:303)
      2. oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:551)
      3. oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:437)
      4. oracle.toplink.essentials.threetier.ServerSession.executeCall(ServerSession.java:465)
      5. oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:213)
      6. oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:199)
      7. oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:270)
      8. oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:600)
      9. oracle.toplink.essentials.internal.queryframework.ExpressionQueryMechanism.selectAllRowsFromTable(ExpressionQueryMechanism.java:2115)
      10. oracle.toplink.essentials.internal.queryframework.ExpressionQueryMechanism.selectAllReportQueryRows(ExpressionQueryMechanism.java:2081)
      11. oracle.toplink.essentials.queryframework.ReportQuery.executeDatabaseQuery(ReportQuery.java:774)
      12. oracle.toplink.essentials.queryframework.DatabaseQuery.execute(DatabaseQuery.java:609)
      13. oracle.toplink.essentials.queryframework.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:677)
      14. oracle.toplink.essentials.queryframework.ObjectLevelReadQuery.executeInUnitOfWork(ObjectLevelReadQuery.java:731)
      15. oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2218)
      16. oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:937)
      17. oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:909)
      18. oracle.toplink.essentials.internal.ejb.cmp3.base.EJBQueryImpl.executeReadQuery(EJBQueryImpl.java:346)
      19. oracle.toplink.essentials.internal.ejb.cmp3.base.EJBQueryImpl.getResultList(EJBQueryImpl.java:447)
      19 frames
    3. commerc
      UsersFacade.findAll
      1. commerc.UsersFacade.findAll(UsersFacade.java:49)
      1 frame
    4. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:597)
      4 frames
    5. com.sun.enterprise
      EJBSecurityManager.runMethod
      1. com.sun.enterprise.security.application.EJBSecurityManager.runMethod(EJBSecurityManager.java:1050)
      1 frame
    6. Security Core Classes
      SecurityUtil.invoke
      1. com.sun.enterprise.security.SecurityUtil.invoke(SecurityUtil.java:165)
      1 frame
    7. Embedded GlassFish Web
      EJBLocalObjectInvocationHandlerDelegate.invoke
      1. com.sun.ejb.containers.BaseContainer.invokeTargetBeanMethod(BaseContainer.java:2766)
      2. com.sun.ejb.containers.BaseContainer.intercept(BaseContainer.java:3847)
      3. com.sun.ejb.containers.EJBLocalObjectInvocationHandler.invoke(EJBLocalObjectInvocationHandler.java:184)
      4. com.sun.ejb.containers.EJBLocalObjectInvocationHandlerDelegate.invoke(EJBLocalObjectInvocationHandlerDelegate.java:118)
      4 frames
    8. Unknown
      $Proxy39.findAll
      1. $Proxy39.findAll(Unknown Source)
      1 frame
    9. mcommerce
      ListUsers.doGet
      1. mcommerce.ListUsers.processRequest(ListUsers.java:48)
      2. mcommerce.ListUsers.doGet(ListUsers.java:64)
      2 frames
    10. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
      2. javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
      2 frames
    11. Glassfish Core
      StandardPipeline.doInvoke
      1. org.apache.catalina.core.ApplicationFilterChain.servletService(ApplicationFilterChain.java:397)
      2. org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:278)
      3. org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:566)
      4. org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:536)
      5. org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:240)
      6. org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:179)
      7. org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:566)
      7 frames
    12. Glassfish
      WebPipeline.invoke
      1. com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:73)
      1 frame
    13. Glassfish Core
      StandardPipeline.doInvoke
      1. org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:182)
      2. org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:566)
      2 frames
    14. Glassfish
      VirtualServerPipeline.invoke
      1. com.sun.enterprise.web.VirtualServerPipeline.invoke(VirtualServerPipeline.java:120)
      1 frame
    15. Glassfish Core
      ContainerBase.invoke
      1. org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:939)
      2. org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:137)
      3. org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:566)
      4. org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:536)
      5. org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:939)
      5 frames
    16. org.apache.coyote
      CoyoteAdapter.service
      1. org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:239)
      1 frame
    17. Glassfish Core
      WorkerThread.run
      1. com.sun.enterprise.web.connector.grizzly.ProcessorTask.invokeAdapter(ProcessorTask.java:667)
      2. com.sun.enterprise.web.connector.grizzly.ProcessorTask.processNonBlocked(ProcessorTask.java:574)
      3. com.sun.enterprise.web.connector.grizzly.ProcessorTask.process(ProcessorTask.java:844)
      4. com.sun.enterprise.web.connector.grizzly.ReadTask.executeProcessorTask(ReadTask.java:287)
      5. com.sun.enterprise.web.connector.grizzly.ReadTask.doTask(ReadTask.java:212)
      6. com.sun.enterprise.web.connector.grizzly.TaskBase.run(TaskBase.java:252)
      7. com.sun.enterprise.web.connector.grizzly.WorkerThread.run(WorkerThread.java:75)
      7 frames