I have a RAILS app running inside of JBOSS.

Using RAILS and ActiveRecord to upload large files is slow and timeouts occur.

I decided to [try and] use sqlldr to push these large files to the oracle database.

What works fine:

1. I can generate my upload file in a public folder under the app.

2. I can generate a valid sqlldr command string.

What doesn't work:

1. No files can be written BY sqlldr to the my web application folders.

This must be a permission problem?  But I run JBOSS (local development) under my own account.  If I run the same generated command from IRB or even just from the Windows cmd prompt it works like a charm.  But it does not even generate a log file when run from the "system" command.  The error that the ruby system command gives is a cryptic integer value that can mean a variety of things.  The return value is a simple "false" indicating failure.

So I guess my question is:

Has anyone done something like this successfully?  And can it be done?

Thank you for any help or pointers.