Thanks Dag. I have tested this and it does work. I did not know how or when to close the prepared statements, etc., but through the example I can see that when I implement the ResultSet interface I can leverage on its "close" method.
Thanks for taking the time to get back. Brett ________________________________________ From: Dag H. Wanvik [[email protected]] Sent: Monday, July 25, 2011 12:14 PM To: [email protected] Subject: Re: Question on Derby Style Table Functions "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");
