Yes!!! Finally that worked! Buff I've spent so many hours with it... I think I should revise the namespace lesson ;-)
Thanks to everyone for your suggestions! I promise to come back soon with a new challenge: Italy: one Rest of the world: zero ;-) and hopefully some answers too.... > 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]> -- 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]>