Eric, Thanks for the reply.
I did check the manifest file in FOP.jar and it matches with the list of files, I have specified in the loadjava option. I'll download the commons-logging-1.1.1 and try again. But in such case, do I need to compile FOP because FOP.jar would refer to commons-logging-1.0.4.jar, isn't it? Oracle documentation recommends loading classes/jars from bottom of the hierarchy. How can I get the complete dependency tree for FOP.Jar and it's dependencies? Manifest in each jar is my only option? Thanks for your help. Regards, Jayant |------------> | From: | |------------> >--------------------------------------------------------------------------------------------------------------------------------------------------| |"Eric Douglas" <[email protected]> | >--------------------------------------------------------------------------------------------------------------------------------------------------| |------------> | To: | |------------> >--------------------------------------------------------------------------------------------------------------------------------------------------| |<[email protected]> | >--------------------------------------------------------------------------------------------------------------------------------------------------| |------------> | Date: | |------------> >--------------------------------------------------------------------------------------------------------------------------------------------------| |06/29/2010 09:16 AM | >--------------------------------------------------------------------------------------------------------------------------------------------------| |------------> | Subject: | |------------> >--------------------------------------------------------------------------------------------------------------------------------------------------| |RE: FOP 0.95 as Database Resident Objects in Oracle 11g Release 1 | >--------------------------------------------------------------------------------------------------------------------------------------------------| Yes, you're probably missing dependant jars. Did you verify that all the jars in that statement exist? Did you open the fop.jar and check the classpath statement in the manifest.mf file? You can open a jar as an archive to view it's contents with an archive program such as 7-zip which is a free download. I had to download a few of the jars fop referenced separately from their own project websites to get it working properly. I also had issues with the logger. Fop came packaged with commons-logging-1.0.4. It actually fixed the errors when I downloaded and replaced that with commons-logging-1.1.1. -----Original Message----- From: Jayant Ghagre [mailto:[email protected]] Sent: Tuesday, June 29, 2010 8:20 AM To: [email protected] Subject: FOP 0.95 as Database Resident Objects in Oracle 11g Release 1 Hello fellow FOP-users, I am trying to load FOP 0.95 (binary download) into Oracle database as database resident object using following command line utility provided by Oracle. loadjava -user User/passw...@mydatabase -verbose -force -order -resolve -recursivejars -jarsasdbobjects -prependjarnames .\lib \avalon-framework-4.2.0.jar .\lib\batik-all-1.7.jar .\lib \commons-io-1.3.1.jar .\lib\commons-logging-1.0.4.jar .\lib \serializer-2.7.0.jar .\lib\servlet-2.2.jar .\lib\xalan-2.7.0.jar .\lib \xercesImpl-2.7.1.jar .\lib\xml-apis-1.3.04.jar .\lib \xml-apis-ext-1.3.04.jar .\lib\xmlgraphics-commons-1.3.1.jar .\lib \fop-hyph.jar .\lib\jai_codec.jar .\lib\jai_core.jar .\lib \jai_imageio.jar .\lib\jimi-1.0.jar .\lib\xmlunit1.0.jar .\build\fop.jar -fileout loaderrors.txt The loadjava utility does load 9000 plus classes into USER_OBJECTS table but it's not able to resolve more than 3000 classes and marks them as INVALID. I am getting two types of errors as shown below. errors : class org/apache/avalon/framework/logger/Loggable ORA-29521: referenced name org/apache/log/Logger could not be found errors : class org/apache/batik/anim/AbstractAnimation ORA-29534: referenced object ../lib/batik-all-1.7.jar///org/apache/batik/anim/timing/TimedElement could not be resolved Has anyone tried to load FOP as database resident object in Oracle? Am I missing any dependant jar files? As per Oracle documentation, Oracle JVM resolves the references using -resolver option if the referenced objects reside in other schema. In my case I am loading all the FOP related classes in my schema. Thanks in advance for your help. Regards, Jayant --------------------------------------------------------------------- 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
