cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From i92mo...@uco.es
Subject SQLException
Date Fri, 21 May 2004 16:22:10 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 Ecould be.
 
 Thank you and sorry for my English.

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org


Mime
View raw message