Return-Path: 
 <cocoon-users-return-26179-apmail-xml-cocoon-users-archive=xml.apache.org@xml.apache.org>
Delivered-To: apmail-xml-cocoon-users-archive@xml.apache.org
Received: (qmail 90989 invoked by uid 500); 28 Nov 2001 22:57:40 -0000
Mailing-List: contact cocoon-users-help@xml.apache.org; run by ezmlm
Precedence: bulk
list-help: <mailto:cocoon-users-help@xml.apache.org>
list-unsubscribe: <mailto:cocoon-users-unsubscribe@xml.apache.org>
list-post: <mailto:cocoon-users@xml.apache.org>
Reply-To: cocoon-users@xml.apache.org
Delivered-To: mailing list cocoon-users@xml.apache.org
Received: (qmail 90978 invoked from network); 28 Nov 2001 22:57:39 -0000
Message-ID: <001f01c1785c$bd174df0$6401a8c0@domain>
From: "Brent L Johnson" <brent@bjohnson.net>
To: "Cocoon-Users" <cocoon-users@xml.apache.org>
Subject: [C1] NumberFormatException / parseInt
Date: Wed, 28 Nov 2001 17:33:42 -0500
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.50.4807.1700
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4807.1700
X-AntiAbuse: This header was added to track abuse,
 please include it with any abuse report
X-AntiAbuse: Primary Hostname - host11.globalhosting.com
X-AntiAbuse: Original Domain - xml.apache.org
X-AntiAbuse: Originator/Caller UID/GID - [0 0] / [0 0]
X-AntiAbuse: Sender Address Domain - bjohnson.net
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N

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