"Bergquist, Brett" <bbergqu...@canoga.com> 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");