Java classes that manipulate files - Running in database

We use some Java classes/functions that manipulate files. Example: The apache FOP processor... We call a method it provides, passing two arguments... THe location of an xml file, and the location of an XSL file. THe class takes those files, does its thing, and returns a PDF file.

We are moving to a PowerBuilder/.NET environment, where using Java classes will no longer be possible for us (we don't want to switch to a .NET equivalent either). Since we use an Oracle database, we figure we could load this java class in Oracle and invoke it there. Since we're inexperienced at this, I'd appreciate any feedback.

Should I create Oracle directory objects, and then save the content of the xml/xsl files there, and then invoke the Java class passing the paramaters of the file locations as being in that Oracle directory? Is that the only way to do it for a Java class that wants file locations as a paramater? Received on Mon Jan 08 2007 - 21:57:11 CST