cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Albert Cervera Areny" <informa...@sedifa.com>
Subject Problems with SQLTransformer
Date Fri, 09 Aug 2002 14:01:00 GMT
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:informatic@sedifa.com]
>> >
>> > 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:     <cocoon-users-unsubscribe@xml.apache.org>
>> For additional commands, e-mail:   <cocoon-users-help@xml.apache.org>
>
> --
> 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:     <cocoon-users-unsubscribe@xml.apache.org>
> For additional commands, e-mail:   <cocoon-users-help@xml.apache.org>


-- 
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:     <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail:   <cocoon-users-help@xml.apache.org>


Mime
View raw message