Database Software

Using Oracle Lite, I have encountered a behavior that I cannot explain.

Release 10.3
JDK 1.6 on Win32
Creme J2ME CDC 1 with personal profile (similar to JDK 1.3).

Upon inserting into one table (EVENTS) in my database through JDBC (POLITE driver) on both Win32 and with the CreMe JVM (Pocket PC), the database truncates values in several columns in several tables.


INSERT INTO EVENTS
(
event_id,
created_by,
created_ts,
created_by,
event_type_cd,
p_id,
created_location
)
VALUES
(
104,
'55378008',
to_date('01-FEB-08', 'DD-MON-RR'),
'N/A',
'BOARD',
1,
'PPR'
)

CREATED_LOCATION is a varchar2(6) column in the oracle database that is replicated into the Lite database. In the other affected tables, there are also columns (varchar2(6)) as well.

Sometimes the insert works, and the new record is placed into the table. I repeat this process several times, and each time a new record is inserted into the EVENTS table.

At a random point during these inserts, the varchar2(6) columns containing 3 character codes (ABC, XYZ, for instance) are truncated from 3 characters to 2 (becoming AB, XY) for all rows. This behavior affects tables I have done nothing with (other than simple selects).

Has anyone seen this before?

I wonder if somehow the oracle lite database fetched through msync is somehow corrupted, or if there is something subtle I configured incorrectly in the publication, or a bug in jdbc, or a bug in the polite jdbc driver.

Any ideas would be very greatly appreciated.

Thanks,
Allen