You are viewing a plain text version of this content. The canonical link for it is here.
Posted to docs@cocoon.apache.org by i9...@uco.es on 2004/05/20 19:42:20 UTC
SQLException
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.
Re: SQLException
Posted by Joerg Heinicke <jo...@gmx.de>.
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.