Return-Path: Delivered-To: apmail-jakarta-commons-dev-archive@www.apache.org Received: (qmail 93022 invoked from network); 14 Apr 2004 18:48:40 -0000 Received: from daedalus.apache.org (HELO mail.apache.org) (208.185.179.12) by minotaur-2.apache.org with SMTP; 14 Apr 2004 18:48:40 -0000 Received: (qmail 26802 invoked by uid 500); 14 Apr 2004 18:48:27 -0000 Delivered-To: apmail-jakarta-commons-dev-archive@jakarta.apache.org Received: (qmail 26723 invoked by uid 500); 14 Apr 2004 18:48:26 -0000 Mailing-List: contact commons-dev-help@jakarta.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "Jakarta Commons Developers List" Reply-To: "Jakarta Commons Developers List" Delivered-To: mailing list commons-dev@jakarta.apache.org Received: (qmail 26710 invoked from network); 14 Apr 2004 18:48:26 -0000 Received: from unknown (HELO web60802.mail.yahoo.com) (216.155.196.65) by daedalus.apache.org with SMTP; 14 Apr 2004 18:48:26 -0000 Message-ID: <20040414184828.14234.qmail@web60802.mail.yahoo.com> Received: from [64.32.141.17] by web60802.mail.yahoo.com via HTTP; Wed, 14 Apr 2004 11:48:28 PDT Date: Wed, 14 Apr 2004 11:48:28 -0700 (PDT) From: David Graham Subject: Re: DbUtils - OracleRowProcessor object To: Jakarta Commons Developers List In-Reply-To: <162CD748CF8119438D558F0A96BDC5919CB5B4@prw2kt82.corp.ercot.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N The DbUtils nightly builds include a more intelligent bean property to column matching implementation. Both of your issues should be fixed in the nightlies. David --- "Catoe, Shawn" wrote: > I work for a medium sized company in Texas. We use Oracle databases and > DbUtils. We ran into several issues with Oracle databases. > The first issue is that Oracle NUMBER comes back through the JDBC driver > as java.math.BigDecimal. Therefore, sets of numeric primitives in > objects will fail to set. An OracleRowProcessor was written to > accommodate this fact. The basis of it is this: > If it fails to find a compatible method and the value is a BigDecimal, > the code will then determine the numeric type of the parameter and > invoke the method using the BigDecimal methods to pass that parameter > type into the invoker. > The second issue, which seems could be used in all row processors, was > trying to set a method with an Object other than that methods member > type. The issue arose when we were trying to set a boolean primitive > with a "true"/"false" String. (Boolean.getBoolean(java.lang.String)) > The BasicRowProcessor determines that the String type is not of the > Boolean type and therefore will not set the member in the Object. In > the OracleRowProcessor submitted, it will attempt to invoke on a method > from the target that matches that method name and value class. To say > clearly, it will look for a method called setBoolean(String bool) to > invoke. This functionality might be useful in all RowProcessor > implementations. > > The file is attached. > > > > Thank You, > Shawn Catoe > > Free thinkers are dangerous. > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: commons-dev-unsubscribe@jakarta.apache.org > For additional commands, e-mail: commons-dev-help@jakarta.apache.org __________________________________ Do you Yahoo!? Yahoo! Tax Center - File online by April 15th http://taxes.yahoo.com/filing.html --------------------------------------------------------------------- To unsubscribe, e-mail: commons-dev-unsubscribe@jakarta.apache.org For additional commands, e-mail: commons-dev-help@jakarta.apache.org