Re: newbie: query a table from java

> I get a proper result but when I want to query the table "HR"."JOBS"
> ResultSet rset = stmt.executeQuery("SELECT * FROM hr.jobs");
>
> I always receive
>
> <java.sql.SQLException: ORA-00942: table or view does not exist>
>
> How do I have to format the statement to specify the schema it belongs
> to? At the first glance it seemed to be "HR"."JOBS" but even this with
> and without quoting didn't solved it.

try this with user HR or SYSTEM

grant select on hr.jobs to scott;

It would resolve your little problem ;)

bye. Received on Tue Feb 25 2003 - 10:55:29 CST