Re: Question on Derby Style Table Functions

[Dag H. Wanvik]

Bergquist, Brett bbergqu...@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);

RE: Question on Derby Style Table Functions

[Bergquist, Brett]

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 [dag.wan...@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 bbergqu...@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);

Question on Derby Style Table Functions

[Bergquist, Brett]

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