cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Yves Vindevogel <yves.vindevo...@implements.be>
Subject Re: mysql problem with sql transformer
Date Sat, 27 May 2006 01:32:58 GMT
Just tried to put my simple select query instead of my "call" and that 
works.
Is this a jdbc problem with calling stored procs ?
Or is this a sql transformer problem ?



Yves Vindevogel wrote:
> Hi,
>
> This is my call to the db in the shell
> mysql pdt20000 --execute "call spjobsperday(0, 2, '', '', '', '', '', 
> '', '', '', '')"
>
> +------------+------+-------+----------+----------+
> | EventDate | Jobs | Pages | FirstJob | LastJob |
> +------------+------+-------+----------+----------+
> | 0000-00-00 | 1 | 0 | 00:00:00 | 00:00:00 |
> | 2005-03-25 | 2 | 3 | 08:48:59 | 11:33:11 |
> +------------+------+-------+----------+----------+
>
>
> When I run the same through the sql transformer: I get this (number of 
> rows is different because that's a parameter, so that's not the reason)
>
> <sql:rowset>
> −
> <sql:row>
> <sql:eventdate>619-10-18</sql:eventdate>
> <sql:jobs>305420361</sql:jobs>
> <sql:pages/>
> <sql:firstjob/>
> <sql:lastjob>01:20:22</sql:lastjob>
> </sql:row>
> −
> <sql:row>
> <sql:eventdate>619-10-18</sql:eventdate>
> <sql:jobs>305420361</sql:jobs>
> <sql:pages/>
> <sql:firstjob/>
> <sql:lastjob>01:20:22</sql:lastjob>
> </sql:row>
> −
> <sql:row>
> <sql:eventdate>619-10-18</sql:eventdate>
> <sql:jobs>305420361</sql:jobs>
> <sql:pages/>
> <sql:firstjob/>
> <sql:lastjob>01:20:22</sql:lastjob>
> </sql:row>
> −
> <sql:row>
> <sql:eventdate>619-10-18</sql:eventdate>
> <sql:jobs>305420361</sql:jobs>
> <sql:pages/>
> <sql:firstjob/>
> <sql:lastjob>01:20:22</sql:lastjob>
> </sql:row>
>
>
> My data is really messed up.
>
> I'm using mysql 5.0.22
> JDBC is latest connector.
> Running Cocoon 2.1.19 under Jetty
>
> What could be the problem ?
> Bug ?
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
> For additional commands, e-mail: users-help@cocoon.apache.org
>
>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org


Mime
View raw message