cocoon-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 19810] New: - No suitable driver error when trying to connect to MsSQL db
Date Fri, 09 May 2003 20:43:12 GMT
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=19810>.
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=19810

No suitable driver  error when trying to connect to MsSQL db

           Summary: No suitable driver  error when trying to connect to
                    MsSQL db
           Product: Cocoon 2
           Version: 2.0.4
          Platform: PC
        OS/Version: Windows NT/2K
            Status: NEW
          Severity: Normal
          Priority: Other
         Component: core
        AssignedTo: cocoon-dev@xml.apache.org
        ReportedBy: tbachta@kopent.com


I am attempting to connect to my MsSQL DB and I keep getting this error.  I 
have double checked my code and I dont see the error there.  Here is my code:
report.xsp:
<?xml version="1.0" encoding="ISO-8859-1"?>

<xsp:page language="java" xmlns:xsp="http://apache.org/xsp" 
xmlns:esql="http://apache.org/cocoon/SQL/v2" xmlns:xsp-
session="http://apache.org/xsp/session/2.0">

	<xsp:structure>
		<xsp:include>java.util.Date</xsp:include>
	</xsp:structure>
	<xsp:logic>
		Date now = new Date();
	</xsp:logic>
	
	<page>
		<title>Overdue Tasks as of <xsp:expr>now</xsp:expr></title>
		
		<content>
		
		<esql:connection>
			<esql:pool>vyzo</esql:pool>
			<esql:execute-query>
				<esql:query>
					select * from vwOverdueTasks
				</esql:query>
				<esql:results>
					<tasks>
						<esql:row-results>
							<task>
							
	<esql:getcolumns/>
							</task>
						</esql:row-results>
					</tasks>
				</esql:results>
			</esql:execute-query>
		</esql:connection>
		
		</content>
	</page>
</xsp:page>
	
report.xsl:
<?xml version="1.0"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
	<xsl:param name="view-source"/>
	<xsl:template match="page">
		<html>
			<head>
				<title>
					<xsl:value-of select="title"/>
				</title>
			</head>
			<body bgcolor="white" alink="red" link="blue" 
vlink="blue">
				<xsl:apply-templates/>
			</body>
		</html>
	</xsl:template>
	
	<xsl:template match="tasks">
		<table border="1">
			<xsl:apply-templates/>
		</table>
	</xsl:template>
	
	<xsl:template match="task">
		<tr>
			<xsl:for-each select="*">
			<td>
				<xsl:apply-templates/>
			</td>
			</xsl:for-each>
		</tr>
	</xsl:template>
</xsl:stylesheet>
sitemap:
<map:match pattern="report.html">
			<map:generate type="serverpages" src="xsp/report.xsp"/>
			<map:transform src="style/report.xsl"/>
			<map:transform type="sql">
				<map:parameter name="use-connection" 
value="vyzo"/>
			</map:transform>
			<map:serialize type="html"/>
		</map:match>
	</map:pipeline>
cocoon.xconfig:

<jdbc name="vyzo">
    	<pool-controller min="5" max="10"/>
    
	<dburl>jdbc:microsoft:sqlserver://kopentpdc:1433;DatabaseName=Joshua;Sel
ectMethod=Cursor;</dburl>
    	<user>vyzouser</user>
    	<password>vyzouser</password>
    </jdbc>

web.xml:
<param-name>load-class</param-name>
    		<param-value>
    			com.microsoft.jdbc.sqlserver.SQLServerDriver
    		</param-value>

Mime
View raw message