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]>