[Opensource] JDBCExecutor and Oracle

[Jungierek, Michail]

Hello,

I'm using the framework in version 4.1ea4 with oracle db.

Now i have a problem with the method update() of the class JDBCExecutor
(current dataExecutor of DBObject). In case of a date or datetimfield
you call (row 353):

sqlCommand.append(JDBCUtil.getInstance().formatDateTime(theObject,oneFie
ld.g
etName()))

This version of formatDateTime produces with these values of

dateUpdateFunction="to_date('%s', 'yyyy-MM-dd ')" 
dateUpdateFormat="yyyy-MM-dd" 

in expresso-config.xml the following output in the sql (look for the quotes
around the to_date()):

GEBURTSDATUM = 'to_date('1963-01-22', 'yyyy-MM-dd ')'

For oracle would be correct the following call of formatDateTime (false
= no quotes around it)

sqlCommand.append(JDBCUtil.getInstance().formatDateTime(theObject,oneField.g
etName(), false))

Two possible cases for solution;

1. fixing

2. give the developer the right to set his own dataExecutor, this member 
variable of DBObject is private and no setter is given in DBObject, or is
any way to
set the dataExecutor which i'm not found?

Michail Jungierek
Techn. Projektmanager

FinanzScout24 AG
Steinstraße 7
20095 Hamburg
tel:+49 (0)40-30 70 7-430
fax:+49 (0)40-30 70 7-109
Michail.Jungierek at scout24.com
<www.finanzscout24.de>