Hello,

We are using cocoabase 4.5 and we are migrating from oracle 8i to oracle 10g.

We are experiencing performance problems when updating a table where the primary key is a DATE datatype
<CBField location="0" catalogname="null" schemaname="" tablename="DEPOT_POSITION" fieldname="COB_DATE" fieldvalue=":COB_DATE" dbfieldtype="DATE" fielddirection="0" dbtype="93" dbfieldsize="7" searchable="7" signed="7" keyposition="1">
</CBField>


Tracing the oracle we see that oracle is calling an internal function to convert the date cocobase is dispatching to the oracle datatype.
We think our performance problems can be reduced if this internal function is not called.

Is it posible to change the settings in the cocobase descriptor, the datatype for example, to not run this internal function?

Thanks in advance.

Hi,

Your field mapping refers to dbType="93", which is correct for Oracle's DATE type. But note this is the jdbc type code for java.sql.Timestamp. How are you declaring your primary key fields in your Java class - is it a java.sql.Timestamp?

THOUGHT Support