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: [EMAIL PROTECTED] ReportedBy: [EMAIL PROTECTED] 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 [EMAIL PROTECTED]
