db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From dag.wan...@oracle.com (Dag H. Wanvik)
Subject Re: Question on Derby Style Table Functions
Date Mon, 25 Jul 2011 16:14:03 GMT
"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".

Dag

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

Mime
View raw message