commons-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alfredo Ledezma Melendez <alfredo.lede...@mail.telcel.com>
Subject RE: [DBUtils] Oracle Row Processor
Date Thu, 07 Jul 2005 20:40:39 GMT


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:henry.voyer@gemplus.com]
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:grahamdavid1980@yahoo.com]
Sent: Thursday, July 07, 2005 3:49 PM
To: Jakarta Commons Users List; henry.voyer@gemplus.com
Subject: RE: [DBUtils] Oracle Row Processor




--- Henry Voyer <henry.voyer@gemplus.com> 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:grahamdavid1980@yahoo.com]
> Sent: Thursday, July 07, 2005 12:37 PM
> To: Jakarta Commons Users List; henry.voyer@gemplus.com
> 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 <henry.voyer@gemplus.com> 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: commons-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-user-help@jakarta.apache.org



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: commons-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-user-help@jakarta.apache.org


Mime
View raw message