XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
search
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Home » Boards » Stylus Studio Developer Network » Stylus Studio Technical Forum » ClassNotFound trying to run Xalan sql extension
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
- Stylus Studio Technical Forum (14621)
-> - Stylus Studio - Registrar en o... (1)
-> + Stylus Studio - Registrar en o... (2)
-> + Can a pipeline send a file by ... (2)
-> + After Updateing WIN10 to WIN11... (12)
-> + Where do I add the custom java... (3)
-> + Where is the Diagram tab? (5)
-> + Applying XSLT to Word DOCX/XML (2)
-> - CSV conversion via ConvertToXM... (1)
-> + Text symbols in SS not same as... (4)
-> + Exposing xquery as webservice ... (6)
-> + Syntax Identifier (2)
-> + Saving a Converted XML as an X... (5)
-> + Output document cannot be pars... (4)
-> - Archiving output from conversi... (1)
-> + EDIFACT guideline from Stylus ... (3)
-> + CSV file putting all the data ... (5)
-> + Can't install Home version 64b... (5)
-> + presale - Can I covers this sc... (5)
-> + Problem with UNB (5)
-> + Splitting EDIFACT files pipeli... (4)
-- [1-20] [21-40] [41-60] Next
+ Website Feedback (249)
+ XSLT Help and Discussion (7625)
+ XQuery Help and Discussion (2016)
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (364)
+ Stylus Studio Announcements (113)
Topic  
Postnext
j nellisSubject: 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="/">
<!-- 1. Make the connection -->
<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.
Posttop
Ivan PedruzziSubject: 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
   
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! 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

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
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.