"Bergquist, Brett" <[email protected]> writes:
> I am implementing a poor man's data partitioning with data being
> inserted into different tables depending on the week of the year. I
> want to bring these tables back together as single virtual unified
> table that can be queried up only, no inserts or updates required.
>
> I am looking at maybe using a Restricted Derby Style Table Function to
> do so because I have some optimization mechanisms that I would like to
> employ in the implementation. Can a Derby Style Table uses the nested
> connection?
I believe the asnwer is "yes".
Dag
>
> Connection conn = DriverManager.getConnection("jdbc:default:connection");