Albert, you should declare the "sql" namespace in usuaris.xsl; moreover, don't forget to add "sql:" in front of "row" and "rowset" template matching.
Yes, I know the "sql:" namespace is not displayed in your SQLTransformer output, but, nevertheless, could you please try ? Best regards, --------------------------------------------- Luca Morandini GIS Consultant [EMAIL PROTECTED] http://utenti.tripod.it/lmorandini/index.html --------------------------------------------- > -----Original Message----- > From: Albert Cervera Areny [mailto:[EMAIL PROTECTED]] > Sent: Friday, August 09, 2002 5:13 PM > To: [EMAIL PROTECTED] > Subject: RE: Problems with SQLTransformer > > > Hi, > > This is what I receive after the SQLTransform when I look it through the > browser (option view source code) > > <?xml version="1.0" encoding="UTF-8"?> > <rowset> > <row> > <id>081778</id> > <role/> > <nom>name</nom> > <passwd>paswd</passwd> > <programa>progname</programa> > </row> > </rowset> > > After the XSLTransform, the browser gives an error (because no initial tag > in the xml file) and if I look at the source code of the page I see: > > <?xml version="1.0" encoding="UTF-8"?> > > > 081778namepassdprogname > > About the usuaris.xsl it is quite simple: > > <?xml version="1.0" encoding="iso-8859-1"?> > > <xsl:stylesheet version="1.0" > xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> > > <xsl:template match="rowset"> > <xsl:apply-templates/> > </xsl:template> > > <xsl:template match="row"> > <authentication> > <ID><xsl:value-of select="id"/></ID> > <role><xsl:value-of select="role"/></role> > <data> > <xsl:copy-of select="nom"/> > <xsl:copy-of select="programa"/> > <xsl:copy-of select="instruccions"/> > </data> > </authentication> > </xsl:template> > </xsl:stylesheet> > > > Your step a) makes it sound like this has nothing to do with SQL > > transformer - that's the step that works unless I misunderstand you. > > When you say you see only data and no xml tags in the browser that > > sounds like a common non-problem I see all the time. A few questions: > > 1) Are the tags there when you do View Source in your browser? > > 2) When in e) you say modifications have no effect do you mean that if > > you literally re-arrange or remove items from the final output those > > changes are not reflected? > > I mean that if instead of the above code I put the following for usuaris.xsl: > <?xml version="1.0" encoding="iso-8859-1"?> > > <xsl:stylesheet version="1.0" > xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> > </xsl:stylesheet> > > Or > > <?xml version="1.0" encoding="iso-8859-1"?> > > <xsl:stylesheet version="1.0" > xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> > <xsl:template match="rowset"> > hello > </xsl:template> > </xsl:stylesheet> > > The output is exactly the same! > > > 3) Have you ensured that any namespaces in use are not the problem? (the > > xsl is looking for <foo> but is finding <ns:foo> ?) > > > > Geoff Howard > > > >> -----Original Message----- > >> From: Albert Cervera Areny [mailto:[EMAIL PROTECTED]] > >> Sent: Friday, August 09, 2002 10:01 AM > >> To: [EMAIL PROTECTED] > >> Subject: Problems with SQLTransformer > >> > >> > >> Hi, > >> I start a new thread about it because the problem deserves > >> this and I'm > >> desperate ;-) > >> > >> <map:generate src="docs/consulta.xml"/> > >> <map:transform type="sql"> > >> <map:parameter name="use-connection" value="cocoon"/> > >> </map:transform> > >> <map:transform src="stylesheets/usuaris.xsl"/> > >> <map:serialize type="xml"/> > >> > >> Looking at the source code of the generated xml with the browser I see > >> only data no xml tags. Only the initial one: <?xml ....> > >> I've been making some changes and it seems like after the > >> SQLTransform I > >> can't put a XSLTransform. I've tried the following things: > >> a) Take off the XSL transform and the result is correct. > >> The data I get > >> can be processed with xalan and usuaris.xsl and I get a new > >> well formed > >> XML file. > >> b) Change the name of usuaris.xsl (just in case I was modifing the > >> wrong one) and it gives an error as cocoon can't find the file. > >> c) Leave usuaris.xsl empty and It gives an error. > >> d) Only leave the initial and final xsl:stylesheet tags > >> and the output > >> is the same. > >> e) Various modifications in the xsl file but does not seem > >> to affect to > >> the output unless it is bad formed, then it gives an error. > >> So the file > >> is processed but incorrectly? > >> > >> I don't know if it might be a bug or I'm really doing something very > >> wrong, but it should be pretty stright forward, shouldn't it? > >> > >> Well... thanks for your patience ;-) > >> > >> > >> > Thanks! It worked without problems! > >> > > >> > But of course I couldn't wait until having another problem ;-) The > >> thing is that I'm trying to make this work: > >> > > >> > sitemap.xmap: > >> > > >> > <map:generate src="docs/usuaris.xml"/> > >> > <map:transform src="stylesheets/usuaris.xsl"> > >> > <map:parameter name="use-request-parameters" value="true"/> > >> > </map:transform> > >> > <map:transform type="sql"> > >> > <map:parameter name="use-connection" value="cocoon"/> > >> > </map:transform> > >> > <map:transform src="stylesheets/usuaris.xsl"/> > >> > <map:serialize type="xml"/> > >> > > >> > While debugging I commented the last transform and data arrives as I > >> expect. In fact, I save the xml generated file with the browser and > >> process it with xalan using the usuaris.xsl and it works! > >> But if I use > >> > this transform in the sitemap I get all the fields returned > >> but without > >> > any XML tags. (It should return as xalan all the authentication XML > >> structure) > >> > > >> > Yes I know I'm using the same stylesheet twice but its for an > >> > authentication process and It should work :-) > >> > > >> > The strange thing is that last step <map:transform > >> > src="stylesheets/usuaris.xsl"/>. Any clue? > >> > > >> > Thanks, once again! > >> > > >> > PS: I believe, after so many problems, some day I will be > >> able to answer > >> > all the questions in this list ;-) May be a new Trivial > >> Pursuit about > >> > cocoon? That > >> > > >> > > >> > On Thursday 08 August 2002 14:33, Vadim Gritsenko wrote: > >> >> > From: Albert Cervera Areny [mailto:[EMAIL PROTECTED]] > >> >> > > >> >> > I get the following error while trying to connect to a postgresql > >> >> > >> >> database > >> >> > >> >> > throw the SQLTransformer: > >> >> > > >> >> > java.sql.SQLException: No suitable driver > >> >> > > >> >> > I've seen in the list archives that it's been reported > >> various times > >> >> > >> >> but > >> >> > >> >> > none of the solutions seems to correct my problem. > >> >> > > >> >> > web.xml: > >> >> > > >> >> > <init-param> > >> >> > <param-name>load-class</param-name> > >> >> > <param-value> > >> >> > org.postgresql.Driver > >> >> > </param-value> > >> >> > </init-param> > >> >> > <init-param> > >> >> > <param-name>extra-classpath</param-name> > >> >> > <param-value>/usr/share/java/postgresql.jar</param-value> > >> >> > >> >> AFAIR, this will not work and has different purpose. > >> >> > >> >> Please jar under WEB-INF/lib. > >> >> > >> >> Vadim > >> >> > >> >> </init-param> > >> >> > >> >> > cocoon.xconf: > >> >> > > >> >> > <datasources> > >> >> > <jdbc logger="core.datasources.postgres" name="cocoon"> > >> >> > <pool-controller max="10" min="5"/> > >> >> > <driver>org.postgresql.Driver</driver> > >> >> > > >> <dburl>jdbc:postgresql://localhost/cocoon:5432</dburl> > >> >> <user>cocoon</user> > >> >> > <password>password</password> > >> >> > </jdbc> > >> >> > </datasources> > >> >> > > >> >> > I don't know if org.postgresql.Driver is necessari in > >> both files but > >> >> I started I've tried it in just one of them and doesn't work > >> >> neighter. Of course access to the database is enabled > >> correctly, the > >> >> port is > >> >> > >> >> 5432 as > >> >> > >> >> > NMAP says ;) and I can connect from psql. All connection > >> data seems > >> >> to > >> >> > >> >> be > >> >> > >> >> > correct... Any other ideas?? > >> >> > > >> >> > > >> >> > Thanks! > >> >> > > >> >> > Albert Cervera Areny > >> >> > >> >> > >> --------------------------------------------------------------------- > >> >> 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]> > >> > > >> > -- > >> > Albert Cervera Areny > >> > Dept. Informātica Sedifa, S.L. > >> > > >> > > >> > > >> > > >> > > >> --------------------------------------------------------------------- > >> > 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]> > >> > >> > >> -- > >> Albert Cervera Areny > >> Dept. Informātica Sedifa, S.L. > >> > >> > >> > >> --------------------------------------------------------------------- > >> 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]> > > > -- > Albert Cervera Areny > Dept. Informātica Sedifa, S.L. > > > > --------------------------------------------------------------------- > 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]>