You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by Lincoln Hochberg <li...@yahoo.com> on 2003/07/30 17:56:18 UTC
getting an xml fragment from the database
Hi all, I'm using:
Tomcate 4.1.24
Cocoon 2.0.4
MySql 4.0.13
MySql JDBC Connector 3.0.8
I have an xsp that selects from the database some xml
from a column of type TEXT. I'm trying to use cocoon
on the command line to get the xml output. I don't
use a transform and just have my serializer output xml
for the moment.
I'm using esql to try and get the xml. However when I
use the tag <esql:get-xml column="description"/> to
get my xml I always get the following error unless the
content of that column is just text (no xml tags):
ERROR 2003-07-29 22:56:42.332 [sitemap.] (): Could
not include pageorg.xml.sax.SAXParseException: Content
is not allowed in prolog.
That is, if my description column contains
hello
then I'm fine, but if it contains
<text>hello</text>
than it blows up with the above error.
Anyone know whats going on?
Thanks,
Lincoln
__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org
Re: getting an xml fragment from the database
Posted by Lincoln Hochberg <li...@yahoo.com>.
Problem solved. I could have sworn I already tried
this but when I added <?xml version="1.0"?> and a root
tag <db_content> to the database field <esql:get-xml>
worked just fine.
Lincoln
--- Lincoln Hochberg <li...@yahoo.com> wrote:
> Hi all, I'm using:
>
> Tomcate 4.1.24
> Cocoon 2.0.4
> MySql 4.0.13
> MySql JDBC Connector 3.0.8
>
> I have an xsp that selects from the database some
> xml
> from a column of type TEXT. I'm trying to use
> cocoon
> on the command line to get the xml output. I don't
> use a transform and just have my serializer output
> xml
> for the moment.
>
> I'm using esql to try and get the xml. However when
> I
> use the tag <esql:get-xml column="description"/> to
> get my xml I always get the following error unless
> the
> content of that column is just text (no xml tags):
>
> ERROR 2003-07-29 22:56:42.332 [sitemap.] (): Could
> not include pageorg.xml.sax.SAXParseException:
> Content
> is not allowed in prolog.
>
> That is, if my description column contains
>
> hello
>
> then I'm fine, but if it contains
>
> <text>hello</text>
>
> than it blows up with the above error.
>
> Anyone know whats going on?
>
> Thanks,
> Lincoln
>
> __________________________________
> Do you Yahoo!?
> Yahoo! SiteBuilder - Free, easy-to-use web site
> design software
> http://sitebuilder.yahoo.com
>
>
---------------------------------------------------------------------
> To unsubscribe, e-mail:
> users-unsubscribe@cocoon.apache.org
> For additional commands, e-mail:
> users-help@cocoon.apache.org
>
__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org