XPAAJ and XML Parsers

[Former Community Member]

Does anyone know which XML parser is used by default in the XPAAJ API's.



We are trying to compile an application into the Oracle Database. The solution then uses the internal Oracle JVM which strips out form data. However there appears to be a problem extracting xml data and we think its down to the Oracle XML parsers. Running the solution from the command line works as expected.



Anyone have any ideas?



Regards

Kris

[Former Community Member]

Hi,

I've got the same problem, but when importing data to a PDF file. The problem apperas when I add the jar: 'xmlparserv2.jar'.

I'm using the Oracle XML Developers Kit on NT (version 10.1.0.2.0).

Have you found a solution?



Thanks

Roberto Teran

[Former Community Member]

Hi Roberto,

Yes we did find a solution. We now have extraction working 100% correctly inside the database. After logging a call with Oracle support we discovered that the xml parser api's should almost certainly work within the database and the classpath used first is the user's schema.

To cut a long story short we needed to also load in xalan.jar. You will need to take a trip to the apache foundation website and visit the Xalan pages and Xerces pages. In summary you will need to load the following additional API's into your db schema. I'm not actually sure which jars are included with which apache download. Best to give them a try.

• resolver.jar


• 
  
  
  


• serializer.jar


• 
  
  
  


• xalan.jar


• 
  
  
  


• xercesImpl.jar


• 
  
  
  


• xml-apis.jar


• 
  
  
  
  Kris

[Former Community Member]

Hi Kris,

Thanks for your help. I'll download the files and test them.



Reagards



Roberto