I haven't used SQL server from C2.
All I can suggest is to keep on isolating the problem, e.g try the JDBC
driver directly under Tomcat using JSP
e.g. try the following - put it under webapps/jsp-examples
(substitute driver & url accordingly, the following is for Oracle)
If it works, the problem is your Cocoon setup or Cocoon. If not, the
problem is the driver or JDBC setup.
Sometimes I think that it would be quicker and easier to strip away
*all* of the layers and go back to using the file system.
<?xml version="1.0"?>
<jsp:root version="1.2"
xmlns:jsp="http://java.sun.com/JSP/Page";
xmlns:c="http://java.sun.com/jsp/jstl/core";
xmlns:sql="http://java.sun.com/jsp/jstl/sql";>
<jsp:directive.page contentType="text/html"/>
<jsp:directive.page import="java.text.*"/>
<sql:setDataSource var="xdb" driver="oracle.jdbc.driver.OracleDriver"
url="jdbc:oracle:thin:@localhost:1521:dbname" user="scott"
password="tiger" />
<html>
<body>
<sql:query var="qkpi" dataSource="${xdb}" maxRows="20"
startRow="0">SELECT * FROM mytable</sql:query>
<table border="1">
<c:forEach var="columnName" items="${qkpi.columnNames}"><td><c:out
value="${columnName}"/></td></c:forEach>
<c:forEach var="row" items="${qkpi.rowsByIndex}" varStatus="vs">
<tr><c:forEach var="col" items="${row}"><td><c:out
value="${col}"/></td></c:forEach></tr>
</c:forEach>
</table>
</body>
</html>
</jsp:root>
Tuomo L wrote:
Thanks, I tested the sample, and it does work with HSQLDB. But when I
tested it against SQL Server with similar results I got before: Upload
works but reading the file with DatabaseReader returns 0 bytes. :(
So, my guess is, something has changed between 2.1.5 and 2.1.7 that makes
the JDBC driver for SQL Server incompatible with Cocoon. With the
jar-files from 2.1.5 (same setup otherwise) this works. What could
this change be?
The method that throws this error "Assuming client reset stream" in
DatabaseReader.java is:
public void generate() throws ProcessingException, SAXException,
IOException {
try {
Response response =
ObjectModelHelper.getResponse(objectModel);
this.serialize(response);
} catch (IOException ioe) {
getLogger().warn("Assuming client reset stream");
this.doCommit = false;
} catch (Exception e) {
this.doCommit = false;
throw new ResourceNotFoundException("DatabaseReader
error:", e);
}
}
-Tuomo
On Sun, 17 Jul 2005, Andrew Franz wrote:
DatabaseReader is used in the samples:
http://localhost:8080/cocoon/samples/blocks/databases/mod-db/file-upload-blob
(Cocoon 2.1.7, Tomcat 5.5)
After upload, this uses DatabaseReader to retrieve the image from
HSQLDB.
If this works ok, then the problems are with SQL Server maybe the
column definition
Tuomo L wrote:
Hi,
Is anyone using the DatabaseReader with Cocooon 2.1.7 ? We just
cannot get
it to function. Log says "Assuming client reset stream".
If it works, could you please tell which versions of Java, Tomcat
and db you have on what system? We're trying to figure out the
source for this
problem. With Cocoon 2.1.5 everything works fine. We are using SQL
Server
2000 and it's latest JDBC driver provided by MS.
-Tuomo
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
