What Database are you using? PostgreSQL has an error if you are using the type INT2 or SMALLINT for the key. More info in datatypes in postgreSQL.
Antonio Gallardo El Viernes, 30 de Agosto de 2002 05:02, Simon Price escribió: > I'm having real problems doing a "trivial" tranformation (in the style > of Matthew and Carsten's excellent book). > > I generate xml which then gets transformed by the sql transformer. > Unfortunately, it only works if I have no containing elements in the > input to the transformer. I'm guessing its related to the namespace? Or > is it a bug in the sql transformer? Any suggestions welcomed! > > Here's the full details (stripped down to simplest repro so please don't > worry about the stylesheet now being pointless)... > > > version info: > > tomcat 4.0.1 > java 1.3.1 > cocoon 2.1 head > > > sitemap fragment: > > <map:match pattern="test3.xml"> > <map:generate src="model/bootstrap.xml"/> > <map:transform src="model/staff_model.xsl"/> > <map:transform type="sql"/> > <map:serialize type="xml"/> > </map:match> > > > model/bootstrap.xml: > > <?xml version="1.0"?> > <bootstrap/> > > > model/staff_model.xsl > > <?xml version="1.0"?> > <xsl:stylesheet version="1.0" > xmlns:xsl="http://www.w3.org/1999/XSL/Transform"; > xmlns:sql="http://apache.org/cocoon/SQL/2.0";> > <xsl:template match="bootstrap"> > <user> > <execute-query xmlns="http://apache.org/cocoon/SQL/2.0";> > <use-connection>pool-TAL</use-connection> > <query> > select > USERNAME, > SURNAME, > INITIALS > from > STAFF > where > STAFFID = '24' > </query> > </execute-query> > </user> > </xsl:template> > </xsl:stylesheet> > > > error in browser (reformatted by hand to make more readable): > > Multiple colons are not allowed in a name. Error processing resource > 'http://localhost:8080/cocoon/tal/admin/test3.xml'. Line 2, Position 18 > > <user xmlns:xmlns:sql="http://apache.org/cocoon/SQL/2.0";> > -----------------^ > <rowset xmlns="http://apache.org/cocoon/SQL/2.0"; > xmlns:sql="http://apache.org/cocoon/SQL/2.0";> > <row> > <username>ecsnp</username> > <surname>Price</surname> > <initials>S</initials> > </row> > </rowset> > </user> > > To help diagnose, the intermediate XML that comes out of the stylesheet > transformation, before going into the sql transformer is: > > <?xml version="1.0" encoding="UTF-8" ?> > <user xmlns:sql="http://apache.org/cocoon/SQL/2.0";> > <execute-query xmlns="http://apache.org/cocoon/SQL/2.0";> > <use-connection>pool-TAL</use-connection> > <query>select USERNAME, SURNAME, INITIALS from STAFF where STAFFID = > '24'</query> > </execute-query> > </user> > > Contrast this with the XML at the same point if the root <user> element > is removed from the stylesheet (THIS ONE WORKS): > > <?xml version="1.0" encoding="UTF-8" ?> > <execute-query xmlns="http://apache.org/cocoon/SQL/2.0"; > xmlns:sql="http://apache.org/cocoon/SQL/2.0";> > <use-connection>pool-TAL</use-connection> > <query>select USERNAME, SURNAME, INITIALS from STAFF where STAFFID = > '24'</query> > </execute-query> > > > Thanks in advance > > Simon > > ------------------------------------------------------------------- > Simon Price > Institute for Learning and Research Technology > University of Bristol > 8-10 Berkeley Square > Bristol BS8 1HH > United Kingdom > > Direct: +44 (0)7071 226 720 > Office: +44 (0)117 928 7193 > Fax: +44 (0)117 928 7112 > [EMAIL PROTECTED] > http://www.ilrt.bristol.ac.uk > > > > --------------------------------------------------------------------- > Please check that your question has not already been answered in the > FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html> > > To unsubscribe, e-mail: <[EMAIL PROTECTED]> > For additional commands, e-mail: <[EMAIL PROTECTED]> --------------------------------------------------------------------- Please check that your question has not already been answered in the FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html> To unsubscribe, e-mail: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]>
