db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bergquist, Brett" <BBergqu...@canoga.com>
Subject RE: Question on Derby Style Table Functions
Date Mon, 25 Jul 2011 16:42:14 GMT
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.

From: Dag H. Wanvik [dag.wanvik@oracle.com]
Sent: Monday, July 25, 2011 12:14 PM
To: derby-dev@db.apache.org
Subject: Re: Question on Derby Style Table Functions

"Bergquist, Brett" <BBergquist@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".


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

View raw message