After some work, we were able to get the 0.20.5 loaded on the database.
We did it by building one big jar that contains all the apache fop jars,
along with a "wrapper" function to produce a PDF, which was based on the
example java code. It runs fine as a JAR on a win32 machine, invoking it
directly.
However, as an Oracle Java stored proc, when we invoke the procedure to
generate the PDF, Oracle returns with the error: ORA-03113: end-of-file
on communication channel
We re-directed the console and file logging all to one log file... when
we call it, we can see it filling the log file and making progress. But
it then just craps out with the above error, and makes a 1KB PDF file
that is no-good.
Would love to hear from anyone that has loaded Apache FOP to run as an
Oracle java stored proc, if they've encountered this error before.
-Original Message-
From: Glen Mazza [mailto:[EMAIL PROTECTED]
Sent: Monday, January 15, 2007 14:00
To: fop-users@xmlgraphics.apache.org
Subject: Re: Running FOP as a Java Stored Procedure on Oracle
Perhaps this would be a good skeleton for what you want to do:
http://www.renderx.com/support/oracle.html
Of course, the Java API between FOP and RenderX are different and will
need changing, etc. But the basic principle should be the same.
HTH,
Glen
Luciano Belotto wrote:
> I use Apache FOP to turn xml into PDF using an xsl.
>
>
>
> I wish to have this functionality run on the Oracle database as a Java
> stored procedure. What I want to ask is that if anyone has done this
> before, and can pass along some info or where I could find information
> on doing this. I've searched mailing list archives and the web, I
> couldn't find anything specific to loading FOP on Oracle, just on
> loading Java classes in general on the database. I'd like any tips on
> FOP in specific, if it has been done before.
>
>
>
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
