Some time ago, I posted a similar problem. I got no responses.
I am not sure that it works at all! If you do get something running, I'd
love to see it!
THANKS!
Jake
-----Original Message-----
From: Arouza, Kevin [mailto:karouza(_at_)insste(_dot_)com]
Sent: Tuesday, November 11, 2003 3:09 PM
To: xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com
Subject: [xsl] Invalid Driver Name Specified.
Thanks for the previous answer, it was an issue with a <xsl:template> tag
actually..resolved it :)
I am getting a "Invalid Driver Name Specified!" when I try to do a
sql:query( ). Any ideas what could be causing it?
Here is an excerpt from my XSLT:
<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform";
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";
xmlns:sql="org.apache.xalan.lib.sql.XConnection"
extension-element-prefixes="sql"
xmlns:java="java">
<xsl:output method="html" indent="yes"/>
<xsl:param name="driver"
select="'oracle.jdbc.driver.OracleDriver'"/>
<xsl:param name="dbUrl"
select="'jdbc:oracle:thin:@devlp-srv:1521:dvlpnt01'"/>
<xsl:param name="user" select="'TEST'"/>
<xsl:param name="password" select="'TEST'"/>
<xsl:param name="query" select="'select * from QT_VIOL where
QUOTE_NO = 194038 and VIOLATION_NO = 1'"/>
<xsl:template match="/">
<!-- Make the connection -->
<xsl:variable name="dbObj" select="sql:new($dbUrl, $driver,
$user, $password)"/>
<HTML>
<HEAD></HEAD>
<BODY>
<TABLE border="1">
<!-- Execute the query -->
<xsl:variable name="table"
select='sql:query($dbObj, $query)'/>
Thanks,
Kevin
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list