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 | 10 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
      EJBLocalObjectInvocationHandler.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)
      3 frames