Forums Register Login

ORA-00942: table or view does not exist

+Pie Number of slices to send: Send
i have enabled "show_sql" to true and can see the following hibernate query

Hibernate: insert into defaultschema.rca_param (param_val_t, param_remk_t, defunct_f, param_t) values (?, ?, ?, ?)

but i get the SEVERE: ORA-00942: table or view does not exist.

The database has the rca_param table and the columns.

When i run the same sql removing the defaultschema from the query, i.e.

insert into rca_param (param_val_t, param_remk_t, defunct_f, param_t) values ('T','T',"Y','Y');

the query executes in TOAD, but when i run the code, i get the table or view not found exception.

1
+Pie Number of slices to send: Send
Aruna,
I am aware of only two causes for the Oracle error code ORA-00942
  • The table (or view) really doesn't exist
  • The database user does not have permission to access (or modify) the table

  • Since you claim to be able to modify the table via TOAD but not via Hibernate, my guess is that you are using different database users in TOAD and Hibernate.
    Also, when accessing a table in Oracle, you only really need to prefix the table name with its schema name if you are accessing it from a different schema.

    Hope this helps you.

    Good Luck,
    Avi.
    My favorite is a chocolate cupcake with white frosting and tiny ad sprinkles.
    a bit of art, as a gift, that will fit in a stocking
    https://gardener-gift.com


    reply
    reply
    This thread has been viewed 4509 times.
    Similar Threads
    weird executeUpdate error?
    Exception when having different class and table name
    javax.servlet.ServletException:[Oracle][ODBC] [Ora]ORA-00942: table or view does not exist
    java.sql.SQLException: ORA-00942
    no. of connection
    More...

    All times above are in ranch (not your local) time.
    The current ranch time is
    Mar 29, 2024 07:10:14.