Mailing-List: contact taglibs-user-help@jakarta.apache.org; run by ezmlm
Precedence: bulk
Reply-To: taglibs-user@jakarta.apache.org
Message-ID: <20010814205318.57404.qmail@web12408.mail.yahoo.com>
Date: Tue, 14 Aug 2001 13:53:18 -0700 (PDT)
From: Morgan Delagrange <mdelagra@yahoo.com>
Reply-To: morgand@apache.org
Subject: Re: DBtags question
To: Ranjit.Lingaiah@Sun.COM, morgand@apache.org
Cc: taglibs-user@jakarta.apache.org
In-Reply-To: <3B798CFC.231AF925@Sun.COM>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii


--- ranjit lingaiah <ranjit.lingaiah@Sun.COM> wrote:
> I'm using Tomcat 3.2.3. 
> 
> colName attribute fails with 'date' type of fields
> in DB.
> 
> As I said, getColumn works with position attribute
> for date type of
> fields,
> but fails when I use colName.
> 
> <sql:getColumn position="1" to="cur_date"/>    //
> SUCCESSFULL
> <sql:getColumn colName="cur_date" to="cur_date"/> 
> // FAILS
> 
> Are you saying I should look under getColumnNumber
> method in the source?
> 

You can if you want, although I don't think it will
actually reveal anything useful.  Since that method is
so self-contained, and the exception appears to show
that the correct column name is being passed in, it
seems like the only likely problems are:

1) Somehow I'm pulling the wrong ResultSetMetaData
object.  It's possible, so I'll keep my eye on it. 
Does this page have more than one statement?  It's
possible that some info is being incorrectly cached,
but I did not think that your version of Tomcat
supported caching taglibs.  I'll tack a release() call
into the end tags just to make sure, and you can try
the new build tomorrow.

2) A bug in your Oracle driver wrt. ResultSetMetaData
and Date fields.  It seems unlikely, but it's the only
other possibility that jumps out at me.

- Morgan


=====
Morgan Delagrange
http://jakarta.apache.org/taglibs
http://jakarta.apache.org/commons

__________________________________________________
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/