DO NOT REPLY [Bug 14407] New: - Can't run DumpSQL.xsl samle with DB2

[bu...@apache.org]

DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://nagoya.apache.org/bugzilla/show_bug.cgi?id=14407>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
INSERTED IN THE BUG DATABASE.

http://nagoya.apache.org/bugzilla/show_bug.cgi?id=14407

Can't run DumpSQL.xsl samle with DB2

           Summary: Can't run DumpSQL.xsl samle with DB2
           Product: XalanJ2
           Version: 2.4
          Platform: PC
        OS/Version: Other
            Status: NEW
          Severity: Major
          Priority: Other
         Component: org.apache.xalan.processor
        AssignedTo: xalan-dev@xml.apache.org
        ReportedBy: yanl58@yahoo.com


tools used:
jdk1.3.1_06
xalan-j_2_4_0
OS: Windows 2000

Before running, I created a database booksdb1, shema books, table book, and
populate the book table using my java applicatoin.

I replaced driver and url by copied/pasted them from my application to Dump1SQL.
I changed the query to "select * from books.book" .

<?xml version="1.0"?> <xsl:stylesheet
xmlns:xsl="http://www.w3.org/1999/XSL/Transform"                 version="1.0" 
               xmlns:sql="org.apache.xalan.lib.sql.XConnection"                
extension-element-prefixes="sql">  <xsl:output method="html" indent="yes"/> 
<xsl:param name="driver" select="'COM.ibm.db2.jdbc.app.DB2Driver'"/> <xsl:param
name="datasource" select="'jdbc:db2:booksdb1'"/> 
<xsl:param name="userid" select="'lin'"/><xsl:param name="password"
select="'12345678'"/><xsl:param name="query" select="'SELECT * FROM
books.book'"/>  <xsl:template match="/">     <xsl:variable name="db"
select="sql:new($driver, $datasource,$userid,$password)"/>     
<xsl:variable name="error" select="sql:getError($db) "/>
<xsl:copy-of select="$error" />
<xsl:variable name="table" select='sql:query($db, $query)'/>     <xsl:copy-of
select="$table" />     <xsl:value-of select="sql:close($db)"/> </xsl:template> 
</xsl:stylesheet>

I ran it without any exception. However, the output file contains the following
information.

<ext-error>
	<message>Invalid Driver Name Specified!</message>
</ext-error>


The driver string is the one I used to create shema and table. Actually, I tried
com.ibm.db2.jdbc.app.DB2Driver. The result is the same.

The class pass I set  is as below:

.;C:\jdk1.3.1_06\lib;C:\jdk1.3.1_06\lib\tools.jar;C:\jdk1.3.1_06\jre\lib\rt.jar;
C:\xalan-j_2_4_0\bin\xalan.jar;C:\xalan-j_2_4_0\bin\xml-apis.jar;
C:\xalan-j_2_4_0\bin\xercesImpl.jar;C:\xalan-j_2_4_0\bin\xalansamples.jar;
C:\xalan-j_2_4_0\bin\bsf.jar;C:\Program Files\SQLLIB\java\db2java.zip;
C:\Program Files\SQLLIB\java\com\ibm\db2\jdbc\app\DB2Driver.class;
C:\Program Files\SQLLIB\java\runtime.zip;C:\Program Files\SQLLIB\bin

I followed all instructions. I still can't run the sample.

Can someone give me some suggetion ? 
Or this is a bug in XSLT SQL extension.

I tried to use xalan-user mail list to report my problem. However, I don't know
my email server name, so my account is not set correctly. I can't use it.

I'm looking forward to hearing from you.

Regards,
Yan Lin
yanl58@yahoo.com