Re: Java classes that manipulate files - Running in database

Luch ha escrito:

> 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?

Not necessarily.
You can manage files with java classes loaded in the DB wrapped in PL/SQL code (packages, procedures, functions). You will need rights to read/write files in the directories (via DBMS_JAVA) to manage them.

HTH. Cheers.

Carlos. Received on Tue Jan 09 2007 - 02:46:39 CST