I've already asked about this before - but I'm getting the exact same errors
again. If everytime I put some files into production I get lots of
NumberFormatExceptions for no apparent reason (I'm not using parseInt, I
checked the java file in the repository and its not using parseInt,
something else in the cocoon library or something must be) - that pretty
much makes it really pointless to use Cocoon in a production environment.
I'm becoming quite discouraged now (see previous posts about
numberformatexceptions and parseint). Basically, it seems to have something
to do with ESQL. Here is my esql tag... I've found if I delete the first
<tr><td>...</td></tr> inside the row-results it works fine and gives no
error. If I put that in.. bam.. error. This only happens on our production
FreeBSD machine running jdk1.2.2 - same code on our Linux dev box running
jdk1.2.2 works fine.
<esql:connection>
<esql:driver>org.gjt.mm.mysql.Driver</esql:driver>
<esql:dburl>jdbc:mysql://<xsp:expr>globals.getProp("dbhost")</xsp:expr>/<xsp
:expr>globals.getProp("dbname")</xsp:expr></esql:dburl>
<esql:username><xsp:expr>globals.getProp("dbuser")</xsp:expr></esql:username
>
<esql:password/>
<esql:execute-query>
<esql:query>select ps.*, Projects.ID projID, Projects.Title title,
Projects.Objective objective from ProjectSchedule ps, Projects where
week(ps.PublishDate) = week(sysdate()) and Projects.ID = ps.ProjectID order
by ps.PublishDate</esql:query>
<esql:results>
<esql:row-results>
<xsp:logic>
if ((curr % 2) == 0) {
bgcolor = "#B0C4E6";
} else {
bgcolor = "#E7EEF8";
}
</xsp:logic>
<xsp:content>
<tr valign="middle"><xsp:attribute
name="bgcolor"><xsp:expr>bgcolor</xsp:expr></xsp:attribute><td
width="20"><b><xsp:expr>curr</xsp:expr>.</b></td><td
colspan="2"><b><esql:get-date column="PublishDate" format="MMMM d"/> -
<redText><a><xsp:attribute
name="href">/projectLibrary/projectDetails.xml?aic=1&ID=<esql:get-string
column="projID"/></xsp:attribute><esql:get-xml column="title"
root="fragment"/></a></redText></b></td></tr>
<tr><td colspan="3"><xsp:attribute
name="bgcolor"><xsp:expr>bgcolor</xsp:expr></xsp:attribute><img
src="../images/ltbluepix.gif" height="1" width="560"/></td></tr>
<tr><td width="10"><xsp:attribute
name="bgcolor"><xsp:expr>bgcolor</xsp:expr></xsp:attribute><img
src="../images/spacer.gif"/></td><td width="470"
valign="middle"><xsp:attribute
name="bgcolor"><xsp:expr>bgcolor</xsp:expr></xsp:attribute><esql:get-string
column="objective"/></td></tr>
</xsp:content>
<xsp:logic>
curr++;
</xsp:logic>
</esql:row-results>
</esql:results>
</esql:execute-query>
</esql:connection>
Thanks,
- Brent
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>
To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
