Discussions

EJB programming & troubleshooting: java.sql.SQLException: ORA-00942:

Bookmark and Share Get thread feed

  1. java.sql.SQLException: ORA-00942: (4 messages)

    • Posted by: Rahul ..
    • Posted on: May 24 2001 18:45 EDT
    hi there,
    i am facing the following error while starting wl5.1 server.

    java.sql.SQLException: ORA-00942: table or view doesn't exist

    at weblogic.db.oci.OciCursor.getCDAException(OciCursor.java:228)
    at weblogic.jdbcbase.oci.Statement.private_parse(Statement.java:717)
    at weblogic.jdbc.oci.Connection.prepareStatement(Connection.java:42)
    at weblogic.jdbc.common.internal.ConnectionEnv.getStatementHolderForC


    I am sure that the database and table are created properly(oracle 8i)
    Reply to this

    Threaded Messages (4)

  2. java.sql.SQLException: ORA-00942:[ Go to top ]

    Is the user id that Weblogic is logging on as the owner of the missing table. If it is not has the user id been granted permissions to see the table.
    Reply to this Reply to original

  3. java.sql.SQLException: ORA-00942:[ Go to top ]

    Hi,
     
      The user that you created for accessing the database has dba permission.

    Try to access the table through sql plus client.

    cheers,
    balu
    Reply to this Reply to original

  4. java.sql.SQLException: ORA-00942:[ Go to top ]

    hi there
    first check it out table name u r providing is there or not check the there may be a apelling mistake
    Manoj

    Reply to this Reply to original

  5. java.sql.SQLException: ORA-00942:[ Go to top ]

    its was spelling
    soory for speeling mistake now u can
    this is reason why ur getting this error
    Reply to this Reply to original