I am trying to deploy a web app (EAR/WAR) that uses XSQL.

If I include xercesImpl-2.2.1.jar, JBoss won't deploy (SAX Parser issue).

If I exclude that jar, the app deploys, but i get two issues:

1. It complains about not being able to find the jdbc driver, but executing the page a second (and subsequent) time works.

2. I get this execution error:

file:/C:/Products/jboss-5.0.1.GA/server/default/tmp/5c4o5k5o-rxi2ue-fruwltla-1-fruwnk24-9m/ontrack.war/reports/manifest/container_lbl.xsl: XML-22043: (Error) Extension function error: Method not found 'generate'

I suspect this is caused by an incompatibility between the org.apache.xerces.* classes in JBoss vs the ones in xercesImpl-2.2.1.jar ?

Has anyone successfully used XSQL with JBoss 5 ?

Thanks,
Craig.