Hi Hollis,
Any interaction that a Session bean (either stateful or
stateless) does with the database _must_ be done directly using
JDBC. You must put code into your session bean that connects to
the database and queries the database tables. This means using
classes in the java.sql package including Connection, Statement,
ResultSet, etc.
Therefore, in order to query a nested table, you use the same SQL
as you would from (say) an SQL*Plus session. Something like:
<pre>
Connection conn = DriverManager.getConnection();
Statement stmt = conn.getStatement();
ResultSet rs = stmt.executeQuery(" ... put your SQL here ...");
</pre>
Good Luck,
Avi.
------------------