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=25197>.
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=25197

"No Suitable Driver" error in xalan SQL extensions 

           Summary: "No Suitable Driver" error in xalan SQL extensions
           Product: XalanJ2
           Version: 2.4Dx
          Platform: All
        OS/Version: Windows NT/2K
            Status: NEW
          Severity: Critical
          Priority: Other
         Component: org.apache.xalan.lib.sql
        AssignedTo: [EMAIL PROTECTED]
        ReportedBy: [EMAIL PROTECTED]


Hi,
I am using xalan extensions to connect to the database inside xsl. 
I am using oracle thin driver(classes12.zip) for connecting to database. 
I am trying to run the samples program that is coming along with xalan 
download. (inside extensions\sql\basic-connection directory).
I am using the oracle driver, oracle.jdbc.driver.OracleDriver.(the driver files 
are in classpath) I  have 
changed the parameters(datasource, driver, username, pwd) inside dbtest.xsl.
When I use this driver to connect to database through xsl, I am getting the 
error,
"No Suitable Driver".

When I tried the same program with a different  
driver(sun.jdbc.odbc.JdbcOdbcDriver), it works fine.

sample parameters:
<xsl:param name="driver" select="'oracle.jdbc.driver.OracleDriver'"/> 
<xsl:param name="datasource" 
         select="'jdbc:oracle:thin:@172.22.1.44:1521:dbn009'"/> 
<xsl:param name="query" select="'select * from TBL1'"/> 
<xsl:param name="username" select="'uid'"/> 
<xsl:param name="passwd" select="'pwd'"/>

Reply via email to