Give me a few hours and I will get the files together and provide them. It turns out, I was not using JPA in the FTP side of things but put a JPA interface on top of the database side to allow my web application to provide an easy interface to list what was in the storage, delete files, etc. from a Web page. So the code is straight JDBC access that right now is targeted to a Derby database, but nothing really special used from that.

Kenneth Vanvik Hansen wrote:
Not using JPA at the moment, but i probably could if i wanted to. If you
could send me the files it might save me a lot of work. Using an Oracle
database, but I could probably make the required changes myself. Thanks.

Kenneth

[email protected]

-----Original Message-----
From: Brett M. Bergquist [mailto:[email protected]] Sent: 19. mars 2010 16:42
To: [email protected]
Subject: Re: LIST from database

Kenneth are you using JPA or can use JPA?  I have this implemented in JPA
and I could send you the files but they are not clean in that they reference
tables in my database, etc.  From the files, you could extract what you
need, however.  Or probably by Monday, I could have this cleaned up enough
to submit back.

Files are stored in the DB as blobs and I have directory/subdirectory, list,
put, get, and delete all working using Derby as my target database.

Kenneth Vanvik Hansen wrote:
Thanks, got it running. Now i'm trying to make it look for files in a db table called FTPTEST. But no matter what I do it returns:
Java.io.FileNotFoundException: res\home\kenneth (Access is denied)

I created a file from a blob and returned it in getFile(), but how am I supposed to make it LIST from the db? All I need atm is the ftp showing files in a single folder. No dir's needed. Anyone got a good idea how to do this?

Kenneth

-----Original Message-----
From: Niklas Gustavsson [mailto:[email protected]]
Sent: 19. mars 2010 14:43
To: [email protected]
Subject: Re: LIST from database

On Fri, Mar 19, 2010 at 11:42 AM, David Latorre <[email protected]> wrote:
You should create your own FileSystemFactory and set it in the DefaultFtpServerContext like this:
 context.setFileSystemManager(filesystemFactory);
Or you can set it on the FtpServerFactory. Or, you can configure it as a bean in the Spring config.

/niklas






Reply via email to