Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> newbie: query a table from java
Hi,
one basically simple thing. I'd like to work with the example tables given provided with the standard setup within a java prog.
When issuing the example from a book:
Statement stmt = conn.createStatement(); ResultSet rset = stmt.executeQuery("SELECT ename FROM emp");
======================================
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.
Would be very grateful to get a hint how to touch tables in different schemas from JAVA.
TIA
Frank
frank_ratzlow_at_nojunk.hotmail.com
Received on Mon Feb 24 2003 - 18:39:06 CST