cocoon-docs mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From i92mo...@uco.es
Subject SQLException
Date Thu, 20 May 2004 17:42:20 GMT
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 what could be.

Thank you and sorry for my English.




Mime
View raw message