Niklas,
Thanks for your help. I'm using org.apache.commons.dbcp.BasicDataSource for the database connection, configured in the ftpd.xml file under db-user-manager, and com.ibm.as400.access.AS400 for the backend server connection and com.ibm.as400.access.IFSFile and com.ibm.as400.access.IFSFileInputStream for the file information and the filestream. I just used the DbFile, DbFileSystemFactory, and DbFileSystemView classes that Brett provided, and edited them to fit what I needed, and made sure to re-use existing connections, and close them when I was done with them. Then, I wrote a custom FtpLet because I need to mark the file as 'read' in the database once it's finished downloading. I also use this FtpLet to setup the connections in onLogin() and close them in onDisconnect(). I'll keep looking for the proxy information, and post back if I find anything useful, or if someone wants that information. Thanks again, -Brad >On Tue, Nov 30, 2010 at 6:54 PM, <[email protected]> wrote: >> I even managed to control/close all of the data and database connections to >> IFS and the Database (which are on the same server, but separate from the >> server used for Apache FTP Server), so that the number of established >> sockets remains the same after several logins/downloads/disconnects. I can >> provide this code if anyone else is interested. > >Is this using JTOpen? > >> What I need to do next is set up the production environment that this FTP >> server will operate in. There is an outward facing server in the DMZ which >> users will connect to, but the database access and processing needs to be >> done on the application server, behind the firewall. Only the application >> server can connect to the database and IFS. >> >> Does anyone have any ideas on how to set this up with Apache FTP server? >> Some type of FTP front-end to handle the connections, and then pass all the >> commands to the application server, and receive all the responses and >> filestreams, etc. > >FTP is somewhat hard to proxy due to the complexity with the data >connections. There are dedicated FTP proxy products but I do not have >any experience myself. I know that there has been some discussions >here on similar topics, so there might be others with more experience. > >As for FtpServer, we support configuring a external IP for passive >data connections which should help. > >/niklas The information contained in and transmitted with this Email may be privileged, proprietary, confidential and protected from disclosure. No privilege is hereby intended to be waived. This Email is intended only for the person to whom it is addressed. If you are not the intended recipient/addressee, any use of the Email and/or its contents, including, but not limited to, dissemination, distribution or copying is strictly prohibited and may be unlawful, and you must not take any action in reliance on it. If you receive this Email in error, please immediately notify the sender and delete the original message and any copies of it from your computer system. We deny any liability for damages resulting from the use of this Email by the unintended recipient, including the recipient in error.
