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");
