Re: newbie: query a table from java

Hi,

thanx for the hint but this raises another question. As far as I've read a schema is a collection of objects that belong to a certain user. But can one user own more than one schemas or not have a schema at all? I cannot recall having seen an account "HR" in the user list. But grantig the appropriate permission will hopefully do the job.

bye

Frank
candido.dessanti_at_blunet.it (Candido Dessanti) wrote in message news:<11c1e2d8.0302250855.666cd610_at_posting.google.com>...
> > 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 - 18:06:49 CST