cocoon-docs mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Joerg Heinicke <joerg.heini...@gmx.de>
Subject Re: SQLException
Date Thu, 20 May 2004 22:09:42 GMT
Hello,

please ask your question on the Cocoon users list [1]. This docs list is 
only used for wiki modification messages and you will probably get no 
answer.

Regards,

Joerg

[1] http://cocoon.apache.org/community/mail-lists.html



On 20.05.2004 19:42, i92molof@uco.es wrote:
> 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