Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (nike.apache.org: local policy)
Date: Tue, 27 May 2008 06:59:19 -0700
From: Rick Hillegas <Richard.Hillegas@Sun.COM>
Subject: Re: How to store many large files in the database?
In-reply-to: <00ec01c8bd1c$0f721d90$32b2a8c0@Sally>
Sender: Richard.Hillegas@Sun.COM
To: Derby Discussion <derby-user@db.apache.org>
Message-id: <483C13B7.9010200@sun.com>
MIME-version: 1.0
Content-type: text/plain; format=flowed; charset=ISO-8859-1
Content-transfer-encoding: 7BIT
References: <00cd01c8bc74$b5d0d710$32b2a8c0@Sally>
 <1372F93D-548C-44A9-B53D-8291B72C9276@sixfriedrice.com>
 <5627810d0805231042o181edf0etb045aa8069d0e0fa@mail.gmail.com>
 <00ec01c8bd1c$0f721d90$32b2a8c0@Sally>
User-Agent: Thunderbird 2.0.0.14 (Macintosh/20080421)

Christian Gruber wrote:
> Thanks for all the replys!
>  
> I know it is not the best solution to store large files in a database, 
> but it was the easiest in an ejb3 environment.
> My knowledge of the maximum file size seems to be a bit outdated. What 
> I have found now is a sizelimit for Fat32 of 4 GB, NTFS has no limit. 
> I hope no one has used Fat32 on his WindowsXP installation and my 
> fears are causeless.
>  
> None the less does anybody know of a working example of a table 
> function that returns a part of the filesystem as a ResultSet?
>  
> Thanks again!
> Christian
Hi Christian,

If what you need is an example of a table function which wraps a flat 
file, then please look in the demo directory or the Derby source code 
for org.apache.derbyDemo.vtis.example.PropertyFileVTI. That's a table 
function which presents a property file as a 2 column table. In the same 
package, there are some other table functions which wrap log files and 
reports.

Hope this helps,
-Rick