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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
