About the CC mail i'll no repeat! Seriously!
Tnx!
David Graham wrote:
--- "Jos�_Fortunato_H._Tom�s" <[EMAIL PROTECTED]> wrote:
I have the following problem:
Bean setter for an Oracle DB table's collumn of type NUMBER isn't called.
To parcially solve I had to use to_char SQL directive:
--->
QueryRunner run = new QueryRunner( GcfServiceLocator.getInstance().getDataSourceForGCF() );
BeanListHandler bh = new BeanListHandler( CustomerValueObject.class );
Object[] args = {( "%" + name + "%" ).replaceAll( "\\s", "%"
).replaceAll( "%{2,}", "%" )};
query = "select" +
" to_char(CUSTOMER_ID) customerId" +
", CUSTOMER_NAME name" +
", BILL_CYCLE billCycle" +
", to_char(CUSTOMER_TYPE) customerType" +
", STATUS state" +
", GTP_FLAG gtpFlag" +
", CREATE_DATE createDate" +
", CREATED_BY createdBy" +
", MODIFICATION_DATE modificationDate" +
", MODIFIED_BY modifiedBy" +
" from CUSTOMER" +
" where" +
" CUSTOMER_NAME LIKE ?1"
;
logger.debug( "getCustomerListByName(" + query + ")" );
ret = (ArrayList)run.query(
query
, args
, bh
);
<---
First, do not cross post messages to commons-dev and commons-user and do
not copy individuals on the message. I received this message 3 times! This should have only been posted to commons-user.
Do not cast the result from run.query() to an ArrayList; BeanListHandler's API states that a List is returned and we could change it to a different implementation at any time.
I looked into the source, but for lack of time I could't found the correct place that maps props types and collunms between setters for lookup method by reflection.
BasicRowProcessor is the class to look at. It's javadoc says how it maps columns to properties: http://jakarta.apache.org/commons/dbutils/apidocs/org/apache/commons/dbutils/BasicRowProcessor.html#toBean(java.sql.ResultSet,%20java.lang.Class)
Is there a known issue ? What can I do?
Is there any code that I can aplly?
Or can you give-me an indication into the source so I contribute fastly?
You have a couple of options: 1. Implement your own RowProcessor 2. Have the BasicRowProcessor set all of the properties it can and you set the rest manually.
FYI, there is discussion on commons-dev about a new interface that allows specialized type conversion.
David
Thanks! --
__________________________________________________
Jos� Fortunato Tom�s
*Mediacapital** Telecomunica��es - IOL*
Rua M�rio Castelhano n� 40
2749-502 BARCARENA
Ext.: 12733
Telef.: 21 434 59 33
Fax.: 21 434 63 88
__________________________________ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--
__________________________________________________
Jos� Fortunato Tom�s
*Mediacapital** Telecomunica��es - IOL*
Rua M�rio Castelhano n� 40
2749-502 BARCARENA
Ext.: 12733
Telef.: 21 434 59 33
Fax.: 21 434 63 88
