From: Yves Vindevogel <[EMAIL PROTECTED]>
Date: Sat, 27 May 2006 03:12:45 +0200
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)
What does the document (in particular, the sql:execute-query section) being
fed into the transformer look like?
<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.
It would have helped if the command line output you quoted was for the same
call as the Cocoon transformer output - perhaps there's something about the
specific values that makes them be skipped. For example, are they displayed
as zeroes in the shell? Are they really zeroes or nulls (in which case,
it's not unreasonable that the elements come back empty)? How exactly are
the results "messed up" - just missing pages/firstjob entries, or are other
values wrong too? Are all of the pages/firstjob elements empty, or only
some of them? What's with those characters between the rows - are they
present in the transformer's input, a copy/paste artifact from your mail
client, or are they being inserted by the transformer?
I'm using mysql 5.0.22
JDBC is latest connector.
Running Cocoon 2.1.19 under Jetty
What could be the problem ?
Bug ?
Perhaps. It could also be a bug in the driver. Or just something about the
specific data values.
Can you try running it in e.g. Aquafold Datastudio
(http://www.aquafold.com/) or some other java-based SQL tool, using the same
JDBC driver jar? It could be the JDBC driver behaves differently to the
command-line tool.
Andrew.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
