In the latest nightly builds, QueryRunner.fillStatement() uses Types.VARCHAR to set columns to NULL: http://jakarta.apache.org/commons/dbutils/xref/org/apache/commons/dbutils/QueryRunner.html#118
If you are using DbUtils 1.0, try a nightly build. If you're already using the latest code and it still fails, subclass QueryRunner and override fillStatement() with the appropriate behavior. David --- Alfredo Ledezma Melendez <[EMAIL PROTECTED]> wrote: > Hello, > > I've been using dbutils with mysql, postgresql, even with SQL Server > successfully for quite a long time. But now I'm facing a little problem > with > Oracle9i (thin-driver and jdbc-odbc). I have a table with two fields of > type > DATE; when I try to UPDATE a row using methos update from QueryRunner in > this > table using null values, it throws the exception: > java.sql.SQLException: Invalid column type Query: UPDATE factura SET > fechaFacturacion = ?, fechaPedido = ? WHERE folioECAC = ? Parameters: > [null, > null, 278] > However, using not null values it runs perfect. I've been looking in > some forums > and they say the problem is that driver does not how to set null values > for > those values of the table. Is there any workaround, somebody has solved > this > problem before, should I use PreparedStatement instead of QueryRunner? > > Any help would be really appreciated. > > Best 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. > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > Get Firefox! http://www.mozilla.org/firefox/ __________________________________ Discover Yahoo! Stay in touch with email, IM, photo sharing and more. Check it out! http://discover.yahoo.com/stayintouch.html --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
