Henry,
I had the same problem, but it got fixed downloading a nightly build. The one I have is 1.1-dev and it works pretty well. Regards, ____________________________________________ Alfredo Ledezma Meléndez. Gerencia de Sistemas CRM Consultor Externo de Sistemas de Atención a Clientes RadioMovil DIPSA, S. A. de C. V. Ejército Nacional No. 488, Col. Anahuac, C.P. 11570 México D.F. -----Original Message----- From: Henry Voyer [mailto:[EMAIL PROTECTED] Sent: Thursday, July 07, 2005 3:08 PM To: 'David Graham'; 'Jakarta Commons Users List' Subject: RE: [DBUtils] Oracle Row Processor Hi David The version i have is the one that is available as 1.1 i have this in the callSetter method !!! try { // Don't call setter if the value object isn't the right type if (this.isCompatibleType(value, params[0])) { setter.invoke(target, new Object[] { value }); } -----Original Message----- From: David Graham [mailto:[EMAIL PROTECTED] Sent: Thursday, July 07, 2005 3:49 PM To: Jakarta Commons Users List; [EMAIL PROTECTED] Subject: RE: [DBUtils] Oracle Row Processor --- Henry Voyer <[EMAIL PROTECTED]> wrote: > Hi > > I just created my oracle row processor. > > The current implementation of BasicRowProcessor has a method > that checks if the field is valid : > private boolean isCompatibleType(Object value, Class type) > > This method ignore dates and most important specific JDBC values. That's not true. The first thing that method checks is if the object is an instance of the setter method's parameter type. This will handle all Objects. The rest of the method is only needed for primitive values. > > Oracle timestamp is transformed in the jdbc process into a > oracle.sql.DATE > object that needs to be transformed into a java.util.date . > > So in order to use dates in oracle we need to add the transformation > process > in the row processor. I think the method you're interested in is BeanProcessor.processColumn() http://jakarta.apache.org/commons/dbutils/xref/org/apache/commons/dbutils/Be anProcessor.html#378 Notice that if your bean property is a java.sql.Timestamp, ResultSet.getTimestamp() is called. Oracle will give you a proper Timestamp object rather than their horrible custom class. Download a nightly DbUtils build, change your bean property to Timestamp, and I think you'll find the default implementation works fine. David > > Regards > > > > -----Original Message----- > From: David Graham [mailto:[EMAIL PROTECTED] > Sent: Thursday, July 07, 2005 12:37 PM > To: Jakarta Commons Users List; [EMAIL PROTECTED] > Subject: Re: [DBUtils] Oracle Row Processor > > > I'm not quite sure what you mean. Can you be more specific about why > the > current implementation doesn't work for Oracle? > > Thanks, > David > > --- Henry Voyer <[EMAIL PROTECTED]> wrote: > > > Hi everyone > > > > Is there a free implementation of an Oracle Row processor ? > > > > Where can i find it ? > > > > Regards > > Get Firefox! http://www.mozilla.org/firefox/ __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Este mensaje es exclusivamente para el uso de la persona o entidad a quien esta dirigido; contiene informacion estrictamente confidencial y legalmente protegida, cuya divulgacion es sancionada por la ley. Si el lector de este mensaje no es a quien esta dirigido, ni se trata del empleado o agente responsable de esta informacion, se le notifica por medio del presente, que su reproduccion y distribucion, esta estrictamente prohibida. Si Usted recibio este comunicado por error, favor de notificarlo inmediatamente al remitente y destruir el mensaje. Todas las opiniones contenidas en este mail son propias del autor del mensaje y no necesariamente coinciden con las de Radiomovil Dipsa, S.A. de C.V. o alguna de sus empresas controladas, controladoras, afiliadas y subsidiarias. Este mensaje intencionalmente no contiene acentos. This message is for the sole use of the person or entity to whom it is being sent. Therefore, it contains strictly confidential and legally protected material whose disclosure is subject to penalty by law. If the person reading this message is not the one to whom it is being sent and/or is not an employee or the responsible agent for this information, this person is herein notified that any unauthorized dissemination, distribution or copying of the materials included in this facsimile is strictly prohibited. If you received this document by mistake please notify immediately to the subscriber and destroy the message. Any opinions contained in this e-mail are those of the author of the message and do not necessarily coincide with those of Radiomovil Dipsa, S.A. de C.V. or any of its control, controlled, affiliates and subsidiaries companies. No part of this message or attachments may be used or reproduced in any manner whatsoever. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
