Java passes the SQL on to the underlying database[/QB]
Thanks. I didn't think
executeUpdate( "CREATE TABLE #Temp ...")
would work, 'cus its DDL. It does and I'm surprised.
Now to find out if EJBs can become associated with Temp....
If this works we
might be able to do things like this in EJB-QL...
SELECT f
FROM Things f
where f.id IN (SELECT g.id FROM Temp WHERE ?1)
(assuming that you first create Temp via JDBC and populate it with
the Things of interest, the ids are compatible, and that you want to use a large "collection" of target items to select from f. )
Finally, delete the Temp.
Let us know if you think there is a better way of going about all this.
[ October 07, 2003: Message edited by: john prieur ]
Juan Rolando Prieur-Reza, M.S., LSSBB, SCEA, SCBCD, SCWCD, SCJP/1.6, IBM OOAD, SCSA