RE: Xalan SQL Extension DB Connection Question

[Jinhua Fan]

Thank you for your response.

I found out the problem I had was caused by JDK.  I was using JDK1.4.0 at
the time.  After I switched to JDK1.3.1, the problem disappeared.  Xalan
document did mention the issues using Xalan with JDK 1.4.X.

Jinhua

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, January 28, 2003 10:04 AM
To: Jinhua Fan
Cc: '[EMAIL PROTECTED]'
Subject: Re: Xalan SQL Extension DB Connection Question


This message usually means that the JDBC driver class cannot be found.
Please check whether the class "oracle.jdbc.driver.OracleDriver" is actually
on your classpath.

Morris Kwan
XSLT Development
IBM Toronto Lab
Tel: (905)413-3729
Email: [EMAIL PROTECTED]



 

                      Jinhua Fan

                      <[EMAIL PROTECTED]>          To:
"'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>           
                                               cc:

                      01/27/2003 03:16         Subject:  Xalan SQL Extension
DB Connection Question                                
                      PM

 

 




I am new to XALAN SQL Extension.  I read about the SQL extension and want to
try it is a style sheet.

I got "Invalid Driver Name Specified!" error message when try to query the
db.  Could any one help me to identify where the problem is. The DbUser and
password are both fine.

Thank you.

****************************************************************************

********

The following is the snippet of the style sheet that I used.

<?xml version="1.0"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform";
                         xmlns:java="http://xml.apache.org/xslt/java";
                         version="1.0"
                         xmlns:sql="org.apache.xalan.lib.sql.XConnection"
                         extension-element-prefixes="sql">

    <xsl:output method="xml" indent="yes"/>

    <xsl:param name="driver" select="'oracle.jdbc.driver.OracleDriver'"/>
    <xsl:param name="dbUrl"
select="'jdbc:oracle:thin:@servername:####:instanceName'"/>


    <!-- define a query -->
    <xsl:param name="pquery" select="'SELECT * FROM mytable '"/>



    <xsl:template match="/">
        <!-- connect to db -->
        <xsl:variable name = "dbobj" select = "sql:new($driver, $dbUrl,
'userName', 'password')" />

        <xsl:element name="ROWSET">
                ... ...

            <xsl:for-each select="/DataSet/DataRow" >

                         ... ...

                <!-- query the data -->
                <xsl:variable name="resultSet" select='sql:query($dbobj,
$pquery )'/>

                <!-- Error Checking, it is stored in the connection since
$resultSet will be either data or null -->
                <xsl:if test="not($resultSet)" >
                       <xsl:message >Error in query</xsl:message>
                    <xsl:copy-of select="sql:getError($dbobj)/ext-error" />
                </xsl:if>

            </xsl:for-each>
        </xsl:element>

        <!-- Close the connection -->
        <xsl:value-of select="sql:close($dbobj)"/>
    </xsl:template>
</xsl:stylesheet>