Hello, I'm working with Cocoon 2.04 and Tomcat 4.1, I have a problem
with the "transformer sql".
I use the HSQL database that is integrate into Cocoon.
Windows Xp; JDk 1.4
Sitemap.xmap: (I don't mount any subsitemap)
<map:match pattern="project-feed-message">
<map:generate src="project/resources/sql_messages.xml"/>
<map:transform type="sql">
<map:parameter name="use-conection"
value="project"/>
</map:transform>
<map:serialize type="xml"/>
</map:match>
Cocoondb.conf:
<dburl>jdbc:hsqldb:hsql://localhost:9002</dburl>
<user>sa</user>
<password/>
</jdbc>
sql-messages.xml:
<page xmlns:sql="http://apache.org/cocoon/SQL/2.0";>
<content>
<sql:execute-query xmlns:sql="http://apache.org/cocoon/SQL/2.0";>
<sql:query name="message">
select id, title from MESSAGE_TABLE
</sql:query>
</sql:execute-query>
</content>
</page>
cocoondb.script:
CREATE TABLE MESSAGE_TABLE(ID INTEGER NOT NULL PRIMARY KEY,TITLE VARCHAR
NOT NULL,BODY VARCHAR,TIME VARCHAR NOT NULL)
CREATE USER SA PASSWORD "" ADMIN
INSERT INTO MESSAGE_TABLE VALUES(1,'Mensaje 1','Probando
Probando','01/01/2004')
INSERT INTO MESSAGE_TABLE VALUES(2,'Mensaje 2','Probando Probando
2','01/01/2004')
I have this error:
ERROR (2004-05-20) 16:45.58:846 [sitemap.transformer.sql]
(/cocoon/project-feed-message) http8080-Processor2/SQLTransformer$Query:
Caught a SQLException java.sql.SQLException: The url cannot be null
The pipeline return:
<page>
<content>
<rowset>
<error>The url cannot be null</error>
</rowset>
</content>
</page>
I think that I forget something, but I don�t know Ecould be.
Thank you and sorry for my English.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
