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?


Connection conn = DriverManager.getConnection("jdbc:default:connection");