ORA-00942: table or view does not exist

[Aruna Ponaka]

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.

[Avi Abrami]

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.