SSDN - ClassNotFound trying to run Xalan sql extension

XML Editor

Sign Up

Search

Options

Chat

Help

News

Log in

Not Logged in

Topic

Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

j nellis

Subject: ClassNotFound trying to run Xalan sql extension
Author: j nellis
Date: 09 Oct 2005 09:41 PM

Greetings,

I am getting the following error with the following xsl.
<?xml version="1.0"?>
<xsl:stylesheet
xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
version="1.0"
xmlns:sql="http://xml.apache.org/xalan/sql"
extension-element-prefixes="sql">

<xsl:template match="/">

<xsl:param name="cinfo" select="//DBINFO"/>
<xsl:variable name="DB" select="sql:new($cinfo)"/>
</xsl:template>
</xsl:stylesheet>

The error:
dbinfo.xsl (9, 3)
Exception calling Java extension: java.lang.ClassNotFoundException: http:..xml.apache.org.xalan.sql at com.exln.stylus.CXClassLoader.findClass(CXClassLoader.java:204) at java.lang.ClassLoader.loadClass(Unknown Source) at com.exln.stylus.CXClassLoader.loadClass(CXClassLoader.java:246) at java.lang.ClassLoader.loadClass(Unknown Source)

I have seen someone else use the class name for the xmlns:sql="org.apache.xalan.lib.sql.XConnection" instead of the http address. It seems to like this better but gives this error regarding the new() function:
dbinfo.xsl (11, 3)
Exception calling Java extension: java.lang.NoSuchMethodError: new

I am using the following xml file as database params. I have also set the classpath in the IDE to include the mysql jar as well as xalan.jar, xalanhlp.jar, xercesImpl.jar, and xml-apis.jar.
<?xml version="1.0"?>
<databases>
<DBINFO>
<dbdriver>com.mysql.jdbc.Driver</dbdriver>
<dburl>jdbc:mysql://localhost:3306/jnellis2_db</dburl>
<user>jnellis</user>
<password>werd</password>
</DBINFO>
</databases>

Does anyone have an idea what is wrong? I'm using the 1.5jdk/jre.

Ivan Pedruzzi

Subject: ClassNotFound trying to run Xalan sql extension
Author: Ivan Pedruzzi
Date: 11 Oct 2005 04:27 PM

Get around the Stylus Studio custom class loader can be a challenge sometime.

The only solution is to copy the content of mysql.jar into
"c:\Program Files\Stylus Studio 6 XML Enterprise Edition\bin\xalan.jar"

Hope this helps
Ivan Pedruzzi
Stylus Studio Team

Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!

Go to Conference:

Log In Options Username: Password:

Site Map | Privacy Policy | Terms of Use | Trademarks

Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.